From: | Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> |
---|---|
To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'Jose Soares'" <jose(at)sferacarta(dot)com>, "'hackers'" <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | AW: [HACKERS] having and union in v7beta |
Date: | 2000-03-02 09:03:14 |
Message-ID: | 219F68D65015D011A8E000006F8590C604AF7D07@sdexcsrv1.f000.d0188.sd.spardat.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>> play=> explain select * from comuni union select * from comuni;
> *However*, we have not fixed the bug that causes "select foo union
> select foo" to be incorrectly simplified --- the UNION code is still
> applying cnfify. (Which it probably shouldn't, but I haven't wanted
> to touch that code until I have the time to rewrite it completely.)
> The reason 7.0beta1 generates the "right" answer is that it has a
> recently-introduced bug in the comparison routines that causes it to
> think the two select subqueries aren't the same.
But if the two queries are the same, the union CAN be simplified,
since the union of two identical masses (I don't know the correct word here)
is still that one mass.
Thus 6.5 simplification is correct in this particular case.
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Vince Vielhaber | 2000-03-02 11:14:22 | Re: [HACKERS] bitten by docs |
Previous Message | Zeugswetter Andreas SB | 2000-03-02 08:54:57 | AW: [HACKERS] Locking |