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

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
Subject: Re: PG regression with row comparison when btree_gist is enabled (BUG)
Date: 2011-06-19 17:23:10
Message-ID: 1308504190.2597.71.camel@jdavis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-testers

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

Attachment Content-Type Size
rowcmp.patch.gz application/x-gzip 905 bytes

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2011-06-19 17:31:48 Re: BUG #6068: automatic analyze runs endlessly
Previous Message Tom Lane 2011-06-19 16:51:25 Re: BUG #6068: automatic analyze runs endlessly

Browse pgsql-testers by date

  From Date Subject
Next Message Denis de Bernardy 2011-06-20 07:23:45 Re: PG regression with row comparison when btree_gist is enabled (BUG)
Previous Message Mark Watson 2011-06-16 18:05:56 Re: 9.1Beta1 - Repeatable Crash on Windows