Skip site navigation (1) Skip section navigation (2)

Re: PG regression with row comparison when btree_gist is enabled (BUG)

From: Denis de Bernardy <ddebernardy(at)yahoo(dot)com>
To: Jeff Davis <pgsql(at)j-davis(dot)com>, "oleg(at)sai(dot)msu(dot)su" <oleg(at)sai(dot)msu(dot)su>
Cc: Teodor Sigaev <teodor(at)sigaev(dot)ru>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: PG regression with row comparison when btree_gist is enabled (BUG)
Date: 2011-06-20 07:23:45
Message-ID: 636928.87301.qm@web112417.mail.gq1.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-testers
I only did some cursory tests, but the patch (applied to Macport's beta2 distribution) seems to be working on my dev box (OSX / Snow Leopard).

I'll report back if I run into oddities further down the road.

Thanks a lot!
Denis





>________________________________
>From: Jeff Davis <pgsql(at)j-davis(dot)com>
>To: oleg(at)sai(dot)msu(dot)su
>Cc: Denis de Bernardy <ddebernardy(at)yahoo(dot)com>; Teodor Sigaev <teodor(at)sigaev(dot)ru>; pgsql-bugs(at)postgresql(dot)org
>Sent: Sunday, June 19, 2011 7:23 PM
>Subject: Re: PG regression with row comparison when btree_gist is enabled (BUG)
>
>On Sat, 2011-06-18 at 13:20 -0700, Jeff Davis wrote:
>> Interesting problem... the bug is in get_op_btree_interpretation() which
>> has code like this:
>> 
>>   /*                                                                                                
>>    * If we can't find any opfamily containing the op, perhaps it is a
>> <>                            
>>    * operator.  See if it has a negator that is in an
>> opfamily.                                      
>>    */
>>   op_negated = false;
>>   if (catlist->n_members == 0)
>> 
>> 
>> However, that's a bogus test, because btree_gist puts <> into an
>> opfamily. Thus, catlist->n_members == 1 even though we really do need to
>> look for the negator. Really, we need to unconditionally search for the
>> operator as well as unconditionally searching for the negator.
>
>Patch attached.
>
>Regards,
>    Jeff Davis
>
>
>

In response to

pgsql-bugs by date

Next:From: David HernándezDate: 2011-06-20 09:35:04
Subject: ¿Está el servidor en ejecución localmente y acept?==?ISO-8859-1?Q?ando conexiones en el socket de dominio Unix <</tmp/.s.PGSQL?==?ISO-8859-1?Q?.5432>>?
Previous:From: Craig RingerDate: 2011-06-20 07:16:47
Subject: Re: BUG #6064: != NULL, <> NULL do not work [sec=UNCLASSIFIED]

pgsql-testers by date

Next:From: Peder O. KlingenbergDate: 2011-06-23 12:37:01
Subject: Documentation nitpick
Previous:From: Jeff DavisDate: 2011-06-19 17:23:10
Subject: Re: PG regression with row comparison when btree_gist is enabled (BUG)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group