Re: BUG #6330: Incorrect select results when using mutually exclusive conditions for nullable column with index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: bricklen <bricklen(at)gmail(dot)com>
Cc: nikolay(dot)gorshkov(at)gmail(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6330: Incorrect select results when using mutually exclusive conditions for nullable column with index
Date: 2011-12-07 16:08:37
Message-ID: 19361.1323274117@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

bricklen <bricklen(at)gmail(dot)com> writes:
> On Wed, Dec 7, 2011 at 5:42 AM, <nikolay(dot)gorshkov(at)gmail(dot)com> wrote:
>> PostgreSQL version information:
>> Result: PostgreSQL 9.0.4 on i486-pc-linux-gnu, compiled by GCC gcc-4.4.real
>> (Ubuntu 4.4.3-4ubuntu5) 4.4.3, 32-bit

> FWIW, I could not reproduce it on
> PostgreSQL 9.0.5 on x86_64-unknown-linux-gnu, compiled by GCC gcc
> (GCC) 4.1.2 20080704 (Red Hat 4.1.2-50), 64-bit

Yeah, this is fixed as of 9.0.5:
http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=bbfcc7149

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2011-12-07 18:16:21 Re: BUG #6329: ODBC ANSI driver psqlODBC v09.00.0310.1
Previous Message bricklen 2011-12-07 15:32:22 Re: BUG #6330: Incorrect select results when using mutually exclusive conditions for nullable column with index