* 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