Re: betatesting: ERROR: failed to build any 2-way joins on 9.2

От:

Tom Lane <tgl@sss.pgh.pa.us>

Дата:

15 августа 2012 г. в 04:11:51

Pavel Stehule  writes:
> My colleague found a issue on 9.2 - sorry for query formatting - this
> query is generated from ours query engine

Fixed, thanks for the report.
		regards, tom lane

Re: betatesting: ERROR: failed to build any 2-way joins on 9.2

От:

Pavel Stehule <pavel.stehule@gmail.com>

Дата:

15 августа 2012 г. в 04:16:43

2012/8/15 Tom Lane :
> Pavel Stehule  writes:
>> My colleague found a issue on 9.2 - sorry for query formatting - this
>> query is generated from ours query engine
>
> Fixed, thanks for the report.

thank you

Pavel
>
>                         regards, tom lane

betatesting: ERROR: failed to build any 2-way joins on 9.2

От:

Pavel Stehule <pavel.stehule@gmail.com>

Дата:

14 августа 2012 г. в 08:24:36

Hello

My colleague found a issue on 9.2 - sorry for query formatting - this
query is generated from ours query engine

testdb=# \i planbug.sql
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
DROP TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
psql:planbug.sql:66: ERROR:  failed to build any 2-way joins
LOCATION:  join_search_one_level, joinrels.c:199

it works on 9.1