Remove redundant DISTINCT when GROUP BY already guarantees uniqueness

Edit
ID 6869
Title Remove redundant DISTINCT when GROUP BY already guarantees uniqueness
CI (CFBot) Summary
Stats (from CFBot) Patch version: v1, Patch count: 1, First patch: +237−1, All patches: +237−1
Tags Performance
Created 2026-06-09 12:30:15
Last modified 2026-06-09 12:30:16 (4 hours ago)
Latest email 2026-06-08 20:55:52 (19 hours ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Needs review
Target version stable
Authors Ilia Evdokimov (ilidock95)
Reviewers Become reviewer
Committer
Links
Emails
Remove redundant DISTINCT when GROUP BY already guarantees uniqueness
First at 2026-06-08 11:12:20 by Ilia Evdokimov <ilya.evdokimov at tantorlabs.com>
Latest at 2026-06-08 20:55:52 by Zsolt Parragi <zsolt.parragi at percona.com>
Latest attachment (v1-0001-Remove-redundant-DISTINCT-when-GROUP-BY-guarantee.patch) at 2026-06-08 11:12:20 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com>
    Attachment (v1-0001-Remove-redundant-DISTINCT-when-GROUP-BY-guarantee.patch) at 2026-06-08 11:12:20 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
History
When Who What
2026-06-09 12:30:16 Ilia Evdokimov (ilidock95) Attached mail thread faf8f63f-b476-4ca8-89f9-7cfc104b522c@tantorlabs.com
2026-06-09 12:30:15 Ilia Evdokimov (ilidock95) Created patch record
Edit