Re: BUG #12760: Lateral files with more than 2 laterals - Mailing list pgsql-bugs

* moe1234512345@gmail.com (moe1234512345@gmail.com) wrote:
> PostgreSQL version: 9.3.5

Happens in master too.

> set geqo_threshold  =3D 2;
>=20
> SELECT *
> FROM generate_series(1, 1) A,
> lateral ( SELECT B from generate_series(1, 1) B where B =3D A limit 1 ) AS
> B0,
> lateral ( SELECT C from generate_series(1, 1) C where C =3D A and C !=3D =
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