| 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 |
| 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 |
| 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 |