[RESENDING because the attachments seems to have caused the mail to
disappear]
Oleg Kharin wrote:
> Hi, Stefan
Hi Oleg!
I have readded the list and the testcases to the CC so that others can
participate in the discussion too ...
>
> init826.sql builds necessary tables and indexes. The test query is in
> the file query826.sql.
I can confirm that this works on 8.2.5 but fails:
* on -HEAD
* on 8.2.6 (so we have a rather bad regression)
with a join_collaps_limit > 3 and < 10 - you could increase that on your
box but it is likely that other queries are affected in a different way
so it might not help at all.
the testcase from oleg is available on:
http://www.kaltenbrunner.cc/files/init826.sql (DDL)
http://www.kaltenbrunner.cc/files/query826.sql (Query)
Stefan