Fix qual pushdown past grouping with mismatched equivalence

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v3, Patch count: 1, First patch: +1365−237, All patches: +1365−237

Tags

Bugfix

Created

2026-05-29 01:58:24

Last modified

2026-07-07 01:00:58 (2 weeks ago)

Latest email

2026-07-07 00:46:34 (2 weeks ago)

Status

PG20-1 (2026-07-01 – 2026-07-31): Committed

Target version

stable

Authors

Richard Guo (richardguo)

Reviewers

Florin Irion (irionr) Become reviewer

Committer

Richard Guo (richardguo)

Links

Emails

Fix HAVING-to-WHERE pushdown with mismatched operator families: First at 2026-05-26 08:48:24 by Richard Guo <guofenglinux at gmail.com>
Latest at 2026-07-07 00:46:34 by Richard Guo <guofenglinux at gmail.com>
Latest attachment (v3-0001-Fix-qual-pushdown-past-grouping-with-mismatched-e.patch) at 2026-06-30 09:22:15 from Richard Guo <guofenglinux at gmail.com>
    Attachment (v3-0001-Fix-qual-pushdown-past-grouping-with-mismatched-e.patch) at 2026-06-30 09:22:15 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (nocfbot-0001-Catch-grouping-columns-wrapped-in-an-express.patch) at 2026-06-23 15:52:18 from Zsolt Parragi <zsolt.parragi at percona.com> (Patch: Yes)
    Attachment (v2-0001-Fix-qual-pushdown-past-grouping-with-mismatched-e.patch) at 2026-05-28 09:11:25 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-HAVING-to-WHERE-pushdown-with-mismatched-oper.patch) at 2026-05-26 08:48:24 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)

History

When	Who	What
2026-07-07 01:00:58	Richard Guo (richardguo)	Closed in commitfest PG20-1 with status: Committed
2026-07-07 01:00:58	Richard Guo (richardguo)	Changed committer to richardguo
2026-06-18 13:09:11	Florin Irion (irionr)	Added irionr as reviewer
2026-05-29 01:58:24	Richard Guo (richardguo)	Attached mail thread CAMbWs4-QLZpn3UVOpeG2fOxxhdnkDNMZ_3Zcm3dqJwRAphz68g@mail.gmail.com
2026-05-29 01:58:24	Richard Guo (richardguo)	Created patch record