From: | "Jozsef Szalay" <jszalay(at)storediq(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5263: Query execution fails with "ERROR: FULL JOIN is only supported with merge-joinable join conditions" |
Date: | 2010-01-05 01:43:17 |
Message-ID: | 201001050143.o051hHFu063915@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5263
Logged by: Jozsef Szalay
Email address: jszalay(at)storediq(dot)com
PostgreSQL version: 8.4.2
Operating system: Windows, Linux (Fedora/CentOS)
Description: Query execution fails with "ERROR: FULL JOIN is only
supported with merge-joinable join conditions"
Details:
Create a table:
CREATE TABLE test
(
id integer,
description character varying,
CONSTRAINT test_pkey PRIMARY KEY (id)
);
Execute the following query:
SELECT *
FROM (SELECT id, 0 AS value
FROM test
WHERE description = 'abc'
) t1
FULL OUTER JOIN
(SELECT id, 1 AS value
FROM test
WHERE description = 'def'
) t2 USING (id, value);
You'll get the "ERROR: FULL JOIN is only supported with merge-joinable join
conditions"
This used to work with 8.3.7 (and before).
I can make the query work by adding an "ORDER BY id, value" clause to each
sub-query or if I use the same constant (e.g. "0") as value in both
sub-queries.
From | Date | Subject | |
---|---|---|---|
Next Message | venkat nemani | 2010-01-05 07:06:45 | BUG #5264: could not create shared memory segment: Invalid argument |
Previous Message | Robert Haas | 2010-01-04 19:28:29 | Re: BUG #5261: Invalide page header |