Jul 2026

8 commits
Remove unreachable error check in JSON_TABLE plan transform
14 Jul 2026Alexander Korotkovmasterunreleased
LLM analysis, 100% surelanded as postedfrom patchset #291 of 1 reviewer saw the final version

The stable git patch ID exactly matches the sixth patch in #29, replacing the unreachable error in transformJsonTableNestedColumns() with Assert(jtc != NULL).

  • Thom Brownsaw the final versionLLM analysis, 100% sureQuestioned the unreachable error in #28 and confirmed the final fixes resolved his concerns in #30.
Avoid redundant re-evaluation of JSON_TABLE nested paths
14 Jul 2026Alexander Korotkovmasterunreleased
LLM analysis, 100% surelanded as postedfrom patchset #291 of 1 reviewer saw the final version

The stable git patch ID exactly matches the fifth patch in #29, removing redundant nested-plan advancement and eager path evaluation in jsonpath_exec.c.

  • Thom Brownsaw the final versionLLM analysis, 100% sureReported the slowdown in #26, verified its complete elimination in #28, and accepted the final series in #30.
Fix and polish JSON_TABLE documentation
14 Jul 2026Alexander Korotkovmasterunreleased
LLM analysis, 100% surelanded as postedfrom patchset #291 of 1 reviewer saw the final version

The stable git patch ID exactly matches the fourth patch in #29. Its author header credits Thom Brown, whose documentation patch was posted in #24 and incorporated with ordering polish in #25.

  • Alexander Korotkovsaw the final versioncommittercommitted the patch
Make JSON_TABLE generated path names avoid collisions
14 Jul 2026Alexander Korotkovmasterunreleased
LLM analysis, 100% surelanded as postedfrom patchset #291 of 1 reviewer saw the final version

The stable git patch ID exactly matches the third patch in #29, including collision avoidance and collecting explicit names before generating the root name in parse_jsontable.c.

  • Thom Brownsaw the final versionLLM analysis, 100% sureFound the remaining root-name collision while testing in #26, then verified the revised fix in #28 and accepted the final series in #30.
Fix JSON_TABLE PLAN deparse to keep parentheses around nested joins
14 Jul 2026Alexander Korotkovmasterunreleased
LLM analysis, 100% surelanded as postedfrom patchset #291 of 1 reviewer saw the final version

The stable git patch ID exactly matches the second patch in #29, correcting get_json_table_plan() parentheses and adding view-deparse regression coverage.

  • Thom Brownsaw the final versionLLM analysis, 100% sureVerified nested and mixed join parentheses plus schema dump/restore in #26, and confirmed the later series in #28 and #30.
Revert cascading of JSON_TABLE's ON ERROR
14 Jul 2026Alexander Korotkovmasterunreleasedreverts 1 commit here
LLM analysis, 100% surelanded as postedfrom patchset #291 of 1 reviewer saw the final version

The stable git patch ID exactly matches the first patch in #29, reverting table-to-column ON ERROR propagation and its deparser defaults, including the final ERROR ON EMPTY view test.

  • Thom Brownsaw the final versionLLM analysis, 100% sureVerified runtime and dumping behavior in #26, supplied the missing deparse test in #28, and accepted the final series in #30.
Bump catversion for JSON_TABLE PLAN clause
9 Jul 2026Alexander Korotkovmasterunreleased
LLM analysis, 100% surewritten from the discussion, no matching patch1 of 1 reviewer saw the final version

Changes only CATALOG_VERSION_NO in src/include/catalog/catversion.h, which no attachment changes. Thom Brown requested the missing bump in #21, and Alexander Korotkov confirmed it in #22.

  • Thom Brownsaw the final versionLLM analysis, 100% sureIdentified the missing catalog-version bump for changed node layouts in #21, directly prompting this commit.
JSON_TABLE PLAN clause
9 Jul 2026Alexander KorotkovmasterunreleasedAlso in: remaining sql/json patches (not this thread)Also in: PG 15 (and to a smaller degree 14) regression due to ExprEvalStep size (not this thread)Also in: SQL/JSON features for v15 (not this thread)Also in: SQL/JSON: functions (not this thread)
LLM analysis, 100% surelanded as postedfrom patchset #170 of 11 reviewers saw the final version

The stable git patch ID exactly matches #17, whose header credits Nikita Malakhov as primary author. This July 2026 submission supersedes the November 2024 source claimed by thread #48026; the from_discussion claims in thread #46113, thread #46380 and thread #38009 describe historical context rather than the latest matching patchset, so their attribution conflicts with this exact match.

  • Andres Freundno review foundtrailerThe commit credits him, but this thread contains no review activity by him.
  • Pavel Stehuleno review foundtrailerThe commit credits him, but this thread contains no review activity by him.
  • Andrew Alsupno review foundtrailerThe commit credits him, but this thread contains no review activity by him.
  • Erik Rijkersno review foundtrailerThe commit credits him, but this thread contains no review activity by him.
  • Zhihong Yuno review foundtrailerThe commit credits him, but this thread contains no review activity by him.
  • Himanshu Upadhyayano review foundtrailerThe commit credits him, but this thread contains no review activity by him.
  • Daniel Gustafssonno review foundtrailerThe commit credits him, but this thread contains no review activity by him.
  • Justin Pryzbyno review foundtrailerThe commit credits him, but this thread contains no review activity by him.
  • Álvaro Herrerano review foundtrailerThe commit credits him, but this thread contains no review activity by him.
  • jian heno review foundtrailerThe commit credits him, but this thread contains no review activity by him.
  • Vladlen Popolitovsaw an earlier versiontrailerReported successful macOS builds and tests in #3 and #5, before substantial parser/executor rework and later naming changes.

Credits across 8 commits

Author
Alexander KorotkovLLM5
Nikita Malakhov1
Thom Brown1
Reviewer
Alexander Korotkovcommitter1
Alvaro Herrera1
Andres Freund1
Andrew Alsup1
Daniel Gustafsson1
Erik Rijkers1
Himanshu Upadhyaya1
jian he1
Justin Pryzby1
Pavel Stehule1
Vladlen Popolitov1
Zhihong Yu1
Reported by
Thom Brown6
Co author
Alexander Korotkov1
Amit Langote1
Andrew Dunstan1
Anton A. Melnikov1
Nikita Glukhov1
Oleg Bartunov1
Teodor Sigaev1
Committer
Alexander Korotkov8

N LLM means N of the credits come from LLM analysis, not from commit trailers.