From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | moe1234512345(at)gmail(dot)com |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #12760: Lateral files with more than 2 laterals |
Date: | 2015-02-10 23:12:08 |
Message-ID: | 2882.1423609928@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
moe1234512345(at)gmail(dot)com writes:
> 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
It's a good idea to show what problem you're seeing, though in this case
I didn't have much trouble reproducing it:
regression=# 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;
ERROR: failed to join all relations together
Will look, thanks for the report!
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2015-02-11 00:04:33 | Re: BUG #12760: Lateral files with more than 2 laterals |
Previous Message | Stephen Frost | 2015-02-10 23:08:34 | Re: BUG #12760: Lateral files with more than 2 laterals |