From: | bricklen <bricklen(at)gmail(dot)com> |
---|---|
To: | nikolay(dot)gorshkov(at)gmail(dot)com |
Cc: | 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 15:32:22 |
Message-ID: | CAGrpgQ-tgUEiB8tjpfWXRtQouH_gqfpz_-H_hx37fD=4dPxtMw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Wed, Dec 7, 2011 at 5:42 AM, <nikolay(dot)gorshkov(at)gmail(dot)com> wrote:
> PostgreSQL version information:
> # select version();
> 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
>
> Linux information:
> # uname -a
> Result: Linux hostname 2.6.32-21-generic-pae #32-Ubuntu SMP Fri Apr 16
> 09:39:35 UTC 2010 i686 GNU/Linux
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
Linux 2.6.18-238.12.1.el5 #1 SMP Tue May 31 13:22:04 EDT 2011 x86_64
x86_64 x86_64 GNU/Linux
or
PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc (GCC)
4.4.5 20110214 (Red Hat 4.4.5-6), 64-bit
Linux 2.6.32-71.29.1.el6.x86_64 #1 SMP Mon Jun 27 19:49:27 BST 2011
x86_64 x86_64 x86_64 GNU/Linux
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-12-07 16:08:37 | Re: BUG #6330: Incorrect select results when using mutually exclusive conditions for nullable column with index |
Previous Message | nikolay.gorshkov | 2011-12-07 13:42:03 | BUG #6330: Incorrect select results when using mutually exclusive conditions for nullable column with index |