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