Re: Postgres 9.2.2 Bug in Select with Left Join - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: Postgres 9.2.2 Bug in Select with Left Join
Date
Msg-id 20121218204618.14700@gmx.com
Whole thread Raw
In response to Postgres 9.2.2 Bug in Select with Left Join  ("liebehenz" <liebehenz@mts-software.com>)
List 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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres 9.2.2 Bug in Select with Left Join
Next
From: Josh Berkus
Date:
Subject: Arbitrary whitespace restrictions on range types