Jan - Feb 2023

5 commits
Mark more nodes with attribute no_query_jumble
13 Feb 2023Michael Paquiermaster16beta1REL_19_STABLE16beta1REL_18_STABLE16beta1REL_17_STABLE16beta1REL_16_STABLE16beta1
LLM analysis, 99% surepart of a posted patchsetmoderate changesfrom patchset #370 of 1 reviewer saw the final version

Takes the node-exclusion patch from #37, leaving out the regression-testing patch. The commit additionally excludes ForeignKeyCacheInfo in src/include/utils/rel.h and makes small comment and spacing adjustments.

  • Tom Lanesaw an earlier versiontrailerTom proposed attribute inheritance and corrected exclusions in #36, then endorsed the revision in #38, before the additional ForeignKeyCacheInfo exclusion was included.
Include values of A_Const nodes in query jumbling
7 Feb 2023Michael Paquiermaster16beta1REL_19_STABLE16beta1REL_18_STABLE16beta1REL_17_STABLE16beta1REL_16_STABLE16beta1
LLM analysis, 100% suremodified before commitlight changesfrom patchset #29

Matches the custom _jumbleA_Const implementation, annotation, and regression tests in #29. Differences are declaration alignment and correcting a test-comment typo in the SQL and expected output.

Generate code for query jumbling through gen_node_support.pl
31 Jan 2023Michael Paquiermaster16beta1REL_19_STABLE16beta1REL_18_STABLE16beta1REL_17_STABLE16beta1REL_16_STABLE16beta1
LLM analysis, 100% surepart of a posted patchsetmoderate changesfrom patchset #180 of 1 reviewer saw the final version

Commits the generator portion of #18 without utility_query_id, adding a case-insensitivity test and centralized documentation. Final edits include hashing WindowClause.orderClause, ignoring CommonTableExpr.aliascolnames and Var.varnullingrels, and using query ID 2 for zero-hash utility statements.

  • Peter Eisentrautsaw an earlier versiontrailerPeter reviewed annotations, patch structure, custom handling, documentation, and the optional GUC through #26, but the final field-selection and zero-hash logic adjustments followed that review.
Rework format of comments in headers for nodes
21 Jan 2023Michael Paquiermaster16beta1REL_19_STABLE16beta1REL_18_STABLE16beta1REL_17_STABLE16beta1REL_16_STABLE16beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #131 of 1 reviewer saw the final version

Commits the comment-formatting portion of #13, omitting most unnecessary location-comment moves and the plannodes.h change. The remaining differences are comment layout and whitespace, as explained in #15.

  • Peter Eisentrautsaw the final versiontrailerPeter approved the split in #11 and recommended committing the formatting patch after removing unnecessary location-comment changes in #14.
Move queryjumble.c code to src/backend/nodes/
21 Jan 2023Michael Paquiermaster16beta1REL_19_STABLE16beta1REL_18_STABLE16beta1REL_17_STABLE16beta1REL_16_STABLE16beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #131 of 1 reviewer saw the final version

Commits only the relocation member of #13, with matching file renames, include updates, and build changes. There are no substantive edits to that member; partial reflects selection from the four-patch series.

  • Peter Eisentrautsaw the final versiontrailerPeter requested a separate relocation patch in #6 and explicitly approved it for commit in #14.

Credits across 5 commits

Author
Michael Paquier4 LLM5
Reviewer
Peter Eisentraut3
Tom Lane1
Reported by
Tom Lane1
Committer
Michael Paquier5

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