From: Sergei Kornilov <sk@zsrv.org>
To: Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
To: michael.paquier@gmail.com <michael.paquier@gmail.com>
Cc: x4mmm@yandex-team.ru <x4mmm@yandex-team.ru>
Cc: david@nlpgo.com <david@nlpgo.com>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: Re: Index-only scan returns incorrect results when using a composite GIST index with a gist_trgm_ops column.
Date: Wed, 24 Jan 2018 00:13:51 +0300
Message-ID: <348951516742031@web54j.yandex.ru> (raw)
In-Reply-To: <20180118.211449.240575561.horiguchi.kyotaro@lab.ntt.co.jp>
References: <20180118.144851.24081723.horiguchi.kyotaro@lab.ntt.co.jp>
<62C2B9A0-51BC-40FF-9BCA-F203784CB9C1@yandex-team.ru>
<20180118082505.GA84508@paquier.xyz>
<20180118.211449.240575561.horiguchi.kyotaro@lab.ntt.co.jp>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: sk@zsrv.org, horiguchi.kyotaro@lab.ntt.co.jp, michael.paquier@gmail.com, x4mmm@yandex-team.ru, david@nlpgo.com, pgsql-bugs@lists.postgresql.org, pgsql-hackers@postgresql.org
Subject: Re: Index-only scan returns incorrect results when using a composite GIST index with a gist_trgm_ops column.
In-Reply-To: <348951516742031@web54j.yandex.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox