FAQ
Hello

there are maybe planner bug.

test case:

CREATE TABLE person (
id SERIAL PRIMARY KEY,
name VARCHAR(64)
) WITHOUT OIDS;

CREATE TABLE person_data (
id SERIAL PRIMARY KEY
) WITHOUT OIDS;

------------------------------------

SELECT name
FROM person
WHERE name IN (
SELECT name FROM person p
LEFT JOIN person_data ON p.id = person_data.id
)

postgres=# explain SELECT name
FROM person
WHERE name IN (
SELECT name FROM person p
LEFT JOIN person_data ON p.id = person_data.id);
ERROR: failed to build any 2-way joins

it works on 8.3

report by Vaclav Novotny

Regards

Pavel

Search Discussions

  • Tom Lane at May 23, 2010 at 4:35 pm

    Pavel Stehule writes:
    postgres=# explain SELECT name
    FROM person
    WHERE name IN (
    SELECT name FROM person p
    LEFT JOIN person_data ON p.id = person_data.id);
    ERROR: failed to build any 2-way joins
    Fixed, thanks.

    regards, tom lane

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedMay 22, '10 at 12:48a
activeMay 23, '10 at 4:35p
posts2
users2
websitepostgresql.org...
irc#postgresql

2 users in discussion

Pavel Stehule: 1 post Tom Lane: 1 post

People

Translate

site design / logo © 2022 Grokbase