Request a Demo
Home   >   mailing lists

Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" - Mailing list pgsql-bugs

From shihao zhong
Subject Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t"
Date
Msg-id CAGRkXqTtXhQKxju0gMmMO6SWxFJw7G3viWt6txJhyZiDguYFWg@mail.gmail.com
Whole thread
In response to Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view
Hi Tom,

Thanks for pushing these, and for the credit.

> I'm imagining inventing a new RTEKind, say RTE_SETOP, and building
> one of those for each set operation in the nest.

Yes, I would like to work on that. I will start with the RTE and the
Vars, and leave building the setop tlists at parse time for a
follow-on patch.

I will post the first version in a new thread on hackers.

Thanks,
Shihao

pgsql-bugs by date:

Previous
From: shihao zhong
Date:
Subject: Re: BUG #17545: Incorrect selectivity for IS NOT DISTINCT FROM and NULLs
Next
From: Tom Lane
Date:
Subject: Re: BUG #19748: tsvectorrecv accepts duplicate lexemes and position 0 that tsvectorin rejects