Re: BUG #12760: Lateral files with more than 2 laterals

* moe1234512345(at)gmail(dot)com (moe1234512345(at)gmail(dot)com) wrote:
> PostgreSQL version: 9.3.5

Happens in master too.

> set geqo_threshold = 2;
>
> SELECT *
> FROM generate_series(1, 1) A,
> lateral ( SELECT B from generate_series(1, 1) B where B = A limit 1 ) AS
> B0,
> lateral ( SELECT C from generate_series(1, 1) C where C = A and C != B limit
> 1 ) AS C0

The result is:

ERROR: failed to join all relations together

Looks like an issue where GEQO and LATERAL don't get along. :/

Thanks,

Stephen