Re: QUAL Pushdown causes ERROR on syntactically and semantically correct SQL Query

2023-06-05 Thread Tom Lane
Hans Buschmann writes: > I have reworked the case of BUG #17842 to include the data and the questions > for further investigation. This wasn't a bug before, and it still isn't. Postgres doesn't guarantee anything about the order of execution of a query's WHERE and JOIN clauses, and we do not in

Re: QUAL Pushdown causes ERROR on syntactically and semantically correct SQL Query

2023-06-05 Thread David G. Johnston
On Mon, Jun 5, 2023, 07:40 Hans Buschmann wrote: > I have reworked the case of BUG #17842 to include the data and the > questions for further investigation. > > > The problem is NOT to correct the query to a working case, but to show a > fundamental problem with qual pushdown. > The optimization

QUAL Pushdown causes ERROR on syntactically and semantically correct SQL Query

2023-06-05 Thread Hans Buschmann
I have reworked the case of BUG #17842 to include the data and the questions for further investigation. qualstest_data contais the data export with --insert (to test it on other DB systems) qualstest_query contains the failing query and a short introduction to the data. The problem is NOT to