From: | levertond(at)googlemail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #9041: Strange error message with LATERAL and mixed WHERE/ON conditions |
Date: | 2014-01-30 15:10:03 |
Message-ID: | 20140130151003.25475.92981@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 9041
Logged by: David Leverton
Email address: levertond(at)googlemail(dot)com
PostgreSQL version: 9.3.2
Operating system: Oracle Enterprise Linux 5 x86_64
Description:
The following query fails with the message "JOIN qualification cannot refer
to other relations":
SELECT *
FROM (SELECT 1 AS x) x
CROSS JOIN (SELECT 1 AS y) y
LEFT JOIN LATERAL (
SELECT *
FROM (SELECT 1 AS z) z
WHERE z.z = x.x
) z ON z.z = y.y;
I don't see why this shouldn't be legal, but if it isn't it should at least
give a less vague error message.
(For the record, the mixture of WHERE and ON is because in the real query,
the LATERAL subquery including the WHERE clause is actually an inlineable
SRF call.)
Postgres was installed using the pgrpms.org packages, and all settings other
than listen_addresses are at their default values.
From | Date | Subject | |
---|---|---|---|
Next Message | Tomáš Vondra | 2014-01-30 15:34:39 | Re: BUG #9038: trgm must have operand in index creation |
Previous Message | craig.macdonald | 2014-01-30 10:35:59 | BUG #9038: trgm must have operand in index creation |