| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | depesz(at)depesz(dot)com |
| Cc: | pgsql-bugs mailing list <pgsql-bugs(at)postgresql(dot)org>, David Rowley <dgrowleyml(at)gmail(dot)com> |
| Subject: | Re: UNION removes almost all rows (not duplicates) - in fresh build of pg17! |
| Date: | 2024-05-20 17:11:24 |
| Message-ID: | 3538123.1716225084@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
hubert depesz lubaczewski <depesz(at)depesz(dot)com> writes:
> $ select count(*) from ( select * from pg_class where relkind = 'r' union select * from pg_class where relkind = 'i' );
> count
> ───────
> 1
> (1 row)
Ugh, that is awful. Bisecting shows it broke at
commit 66c0185a3d14bbbf51d0fc9d267093ffec735231
Author: David Rowley <drowley(at)postgresql(dot)org>
Date: Mon Mar 25 14:31:14 2024 +1300
Allow planner to use Merge Append to efficiently implement UNION
I've not looked at the patch, but somehow it's totally forgetting
what it's supposed to be unique-ifying on.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Haifang Wang (Centific Technologies Inc) | 2024-05-20 20:17:46 | RE: [EXTERNAL] Re: Windows Application Issues | PostgreSQL | REF # 48475607 |
| Previous Message | Alvaro Herrera | 2024-05-20 16:16:16 | Re: BUG #18377: Assert false in "partdesc->nparts >= pinfo->nparts", fileName="execPartition.c", lineNumber=1943 |