Mario Weilguni <[EMAIL PROTECTED]> writes:
> ERROR: failed to build any 8-way joins
Could you provide a self-contained test case for this? You probably
don't need any data, just the table schemas.
I fixed a problem with a similar symptom a couple days ago, but that was
in logic that was new in
Thanks for the info. Is there a fix for 8.1 branch, the production system is
still 8.1.
Regards
Mario Weilguni
Am Donnerstag, 15. Februar 2007 16:25 schrieb Alvaro Herrera:
> Mario Weilguni wrote:
> > Interesting: remove any of the above where conditions solves the problem
> > go away,
Mario Weilguni wrote:
> Interesting: remove any of the above where conditions solves the problem go
> away, e.g. removing "and bei.id=10157309".
>
> Testet with 8.2.1 and 8.1.4, same effect on both systems. Because of the
> large number of tables involved it's difficult to find a self containe
Interesting problem, seems to be planer related:
select 1
from beitraege bei,
b_zuordnungen bz,
(select bei_id
from b_zuordnungen bz,
ben_zuordnungen z,
strukturelemente se
where se.id = z.str_i