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
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
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