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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Re: PG regression with row comparison when btree_gist is enabled (BUG)
Дата
Msg-id 24699.1309978787@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Re: PG regression with row comparison when btree_gist is enabled (BUG)  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-bugs
Jeff Davis <pgsql@j-davis.com> writes:
> On Wed, 2011-07-06 at 13:25 -0400, Tom Lane wrote:
>> Actually, I'd just been working on this myself.  I think the cleanest
>> solution will be to get rid of the duplicative logic by making
>> predtest.c use get_op_btree_interpretation().  That will require
>> changing get_op_btree_interpretation() so it can return amoplefttype
>> and amoprighttype too, but given the small number of callers, an API
>> change for it doesn't seem like a problem.

> Sounds good to me.

Committed that way.  Just for the archives' sake, the test case I was
using for the planner side of things was

create index tenk1p on tenk1 (twothousand) where twothousand <> 42;
explain select * from tenk1 where twothousand < 40;

which should use the partial index, but it was failing to prove the
implication when btree_gist was installed.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: Re: PG regression with row comparison when btree_gist is enabled (BUG)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #6092: specific casting required for gist indexing of bigint