Thread

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

   Pavel Stehule <pavel.stehule@gmail.com> — 2012-08-14T08:23:52Z

   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
   

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

   Tom Lane <tgl@sss.pgh.pa.us> — 2012-08-15T04:11:47Z

   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
   
   
   

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

   Pavel Stehule <pavel.stehule@gmail.com> — 2012-08-15T04:15:58Z

   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
   >
   >                         regards, tom lane