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

Started by Pavel Stehuleover 13 years ago3 messageshackers
Jump to latest
#1Pavel Stehule
pavel.stehule@gmail.com

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

Attachments:

planbug.sqlapplication/octet-stream; name=planbug.sqlDownload
#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Pavel Stehule (#1)
Re: betatesting: ERROR: failed to build any 2-way joins on 9.2

Pavel Stehule <pavel.stehule@gmail.com> 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

#3Pavel Stehule
pavel.stehule@gmail.com
In reply to: Tom Lane (#2)
Re: betatesting: ERROR: failed to build any 2-way joins on 9.2

2012/8/15 Tom Lane <tgl@sss.pgh.pa.us>:

Pavel Stehule <pavel.stehule@gmail.com> 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

Show quoted text

regards, tom lane