Jul 2026

1 commit
Fix qual pushdown past grouping with mismatched equivalence
6 Jul 2026Richard GuomasterunreleasedREL_19_STABLE19beta2REL_18_STABLE18.6
LLM analysis, 100% suremodified before commitlight changesfrom patchset #161 of 5 reviewers saw the final version

The committed production-code changes match #16; the remaining diff renames the aggregate regression-test composite type from t_rec to avg_rec and updates its uses and expected output. Richard Guo confirms committing and backpatching the patch in #20.

  • Thom Brownsaw an earlier versiontrailerThom prompted investigation of other pushdown paths in #2 and endorsed the shared approach in #5, before the collation walker was reworked.
  • Florin Irionsaw an earlier versiontrailerFlorin tested GROUP BY subquery pushdown in #6 and withdrew his suspected failure after retesting in #8, before the final walker changes.
  • Zsolt Parragisaw an earlier versiontrailerZsolt reported wrapped-expression and unknown-operator holes in #9 and supplied proposed fixes in #11, before the final collation rework.
  • Tender Wangsaw the final versiontrailerTender identified the ascii() failure and proposed conservative handling in #13 and #14, then tested and positively reviewed the final patch in #17 and #19.
  • Chengpeng Yansaw an earlier versiontrailerChengpeng explained the nondeterministic-partition failure and advocated conservative pushdown restrictions in #15, while explicitly noting that he had not reviewed all implementation details.

Credits across 1 commit

Author
Richard Guo1
Reviewer
Chengpeng Yan1
Florin Irion1
Tender Wang1
Thom Brown1
Zsolt Parragi1
Committer
Richard Guo1