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

Sergei Kornilov <sk@zsrv.org>

From: Sergei Kornilov <sk@zsrv.org>

To: Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>, "michael.paquier@gmail.com" <michael.paquier@gmail.com>

Cc: "x4mmm@yandex-team.ru" <x4mmm@yandex-team.ru>, "david@nlpgo.com" <david@nlpgo.com>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Date: 2018-01-23T21:13:51Z

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

Commits

Improve stability of recently-added regression test case.
- afb5fb290e90 10.6 landed
- 6d2c760b059e 11.1 landed
- 4f6a77e46af2 9.5.15 landed
- 3e406417b8da 9.6.11 landed
- 17d6a8fb764c 12.0 landed
Fix IOS planning when only some index columns can return an attribute.
- be55bfc9386d 9.5.13 landed
- b5febc1d125c 11.0 landed
- 3f26be83ec1e 9.6.9 landed
- 147b59971eba 10.4 landed
Ability to advance replication slots
- 9c7d06d60680 11.0 cited
Allow no-op GiST support functions to be omitted.
- d3a4f89d8a3e 11.0 cited