Postgres 9.2.2 Bug in Select with Left Join

Lists: pgsql-bugs
From: "liebehenz" <liebehenz(at)mts-software(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Postgres 9.2.2 Bug in Select with Left Join
Date: 2012-12-18 11:26:15
Message-ID: !&!AAAAAAAAAAAYAAAAAAAAAN7pRPgMguhNgpQSSKBMW8oCgQAAEAAAAHkFZ00NkmZIlg6BzSJwrKcBAAAAAA==@mts-software.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

Hello,

i have here a strange bug.

a_name (char var 48) is sometimes empty in the select of the new 9.2.2
Version,

the a_name is in the table column set.

Something is going wrong.

here in screenshot same identical database on 9.2.1 Server and 9.2.2 Server

that's not good.

Attachment Content-Type Size
Screenshot - 18.12.2012 , 12_15_57.png image/png 192.6 KB

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "liebehenz" <liebehenz(at)mts-software(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Postgres 9.2.2 Bug in Select with Left Join
Date: 2012-12-18 15:31:24
Message-ID: 8433.1355844684@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

"liebehenz" <liebehenz(at)mts-software(dot)com> writes:
> i have here a strange bug.

Can't really say anything about this without a self-contained test case
(which your screenshot isn't, even if it were 100% readable).

However, are you sure that it's 9.2.2 and not 9.2.1 that's wrong?
There were several planner bugs fixed in between.

regards, tom lane