Re: Index-only scan returns incorrect results when using a composite GIST index with a gist_trgm_ops column.

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>, "michael(dot)paquier(at)gmail(dot)com" <michael(dot)paquier(at)gmail(dot)com>
Cc: "x4mmm(at)yandex-team(dot)ru" <x4mmm(at)yandex-team(dot)ru>, "david(at)nlpgo(dot)com" <david(at)nlpgo(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Index-only scan returns incorrect results when using a composite GIST index with a gist_trgm_ops column.
Date: 2018-01-23 21:13:51
Message-ID: 348951516742031@web54j.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Hello
I tested this patch and think it can be commited to master. Is there a CF record? I can not find one.

Should we also make backport to older versions? I test on REL_10_STABLE - patch builds and works ok, but "make check" fails on new testcase with error:
> CREATE INDEX ON t USING gist (a test_inet_ops, a inet_ops);
>+ ERROR: missing support function 4 for attribute 1 of index "t_a_a1_idx"
and with different explain results.

regards, Sergei

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2018-01-23 23:23:19 Re: BUG #14912: Undocumented: 'psql -l' assumes database 'postgresql' not $USER
Previous Message Tom Lane 2018-01-23 20:19:37 Re: ERROR: could not devise a query plan for the given query (UNIONS and LATERAL)

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2018-01-23 21:18:24 Re: [HACKERS] Support for Secure Transport SSL library on macOS as OpenSSL alternative
Previous Message Alvaro Herrera 2018-01-23 21:09:46 Re: Using ProcSignal to get memory context stats from a running backend