Re: Postgres 9.2.2 Bug in Select with Left Join

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