Re: BUG #3865: ERROR: failed to build any 8-way joins

[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