| From: | Andrey Borodin <x4mmm(at)yandex-team(dot)ru> |
|---|---|
| To: | Sergei Kornilov <sk(at)zsrv(dot)org> |
| Cc: | 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>, "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-24 06:34:18 |
| Message-ID: | 2685319A-AE71-437E-AE44-902770243361@yandex-team.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
Hi!
> 24 янв. 2018 г., в 2:13, Sergei Kornilov <sk(at)zsrv(dot)org> написал(а):
>
> 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.
To be usable for 10 the patch must use full-featured opclass in tests: there is no decompress GiST function in test_inet_ops which was required before 11.
I think, explain results will be identical.
Best regards, Andrey Borodin.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kyotaro HORIGUCHI | 2018-01-24 07:11:53 | Re: Index-only scan returns incorrect results when using a composite GIST index with a gist_trgm_ops column. |
| Previous Message | PG Bug reporting form | 2018-01-24 05:48:16 | BUG #15027: EPEL / Potgres 95 yum repo package version conflict affecting postgis22_95 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2018-01-24 06:44:04 | Re: [HACKERS] taking stdbool.h into use |
| Previous Message | Peter Geoghegan | 2018-01-24 06:31:35 | Re: [HACKERS] parallel.c oblivion of worker-startup failures |