Fix var_eq_const: sum selectivity of all matching MCV entries instead of stopping at first match

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v2, Patch count: 1, First patch: +21−10, All patches: +21−10

Tags

Bugfix Good First Review

Created

2026-07-30 11:06:48

Last modified

2026-07-30 11:06:48 (2 weeks ago)

Latest email

2026-08-06 14:56:39 (1 week ago)

Status

PG20-2 (2026-09-01 – 2026-09-30): Needs review

Target version

Authors

Zizhuan Liu (liuzizhuan)

Reviewers

Damil Shahzad (damils) Become reviewer

Committer

Links

Emails

Fix var_eq_const: sum selectivity of all matching MCV entries instead of stopping at first match: First at 2026-07-30 11:03:42 by ZizhuanLiu X-MAN <44973863 at qq.com>
Latest at 2026-08-06 14:56:39 by Damil Shahzad <shahzaddamil at gmail.com>
Latest attachment (match collate between column and express.xlsx) at 2026-08-06 09:00:50 from ZizhuanLiu X-MAN <44973863 at qq.com>
    Attachment (match collate between column and express.xlsx) at 2026-08-06 09:00:50 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: No)
    Attachment (v2-0001-Fix-var_eq_const-sum-selectivity-of-all-matching-.patch) at 2026-08-06 07:25:04 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: No)
    Attachment (match collate between column and express.xlsx) at 2026-08-05 10:31:34 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: No)
    Attachment (v1-0001-Merge-MCV-match-and-sum-loops-in-var_eq_cons.patch) at 2026-08-05 07:33:14 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: No)
    Attachment (v1-0001-Fix-var_eq_const-sum-selectivity-of-all-matching-.patch) at 2026-07-30 11:03:42 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: No)

History

When	Who	What
2026-08-05 10:36:11	Zizhuan Liu (liuzizhuan)	Posted comment with messageid <178592617169.1181.1374052989897980607.pgcf@coridan.postgresql.org>
2026-08-04 09:44:36	Damil Shahzad (damils)	Added damils as reviewer
2026-07-30 11:06:48	Zizhuan Liu (liuzizhuan)	Attached mail thread tencent_A15A9D89A86F2E4B086ABA462578B9B64307@qq.com
2026-07-30 11:06:48	Zizhuan Liu (liuzizhuan)	Created patch record