Postgres 9.2.2 Bug in Select with Left Join

"liebehenz" <liebehenz@mts-software.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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

liebehenz wrote:

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

Character-based results are preferred on a list like this. A psql
session is good. A self-contained test case (which take things from
creation and population of test data through to the misbehavior is
ideal).

For starters can you show us (copy/paste) the results of running
this in psql?:

\d artikel
select a_id, char_length(a_name), a_name
 from artikel
 where a_id in (323, 324);

-Kevin

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs