pgsql: Unbreak index optimization for LIKE on bytea - Mailing list pgsql-committers

From Peter Eisentraut
Subject pgsql: Unbreak index optimization for LIKE on bytea
Date
Msg-id E1hFw8u-0001Hh-5G@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Unbreak index optimization for LIKE on bytea

The same code is used to handle both text and bytea, but bytea is not
collation-aware, so we shouldn't call get_collation_isdeterministic()
in that case, since that will error out with an invalid collation.

Reported-by: Jeevan Chalke <jeevan.chalke@enterprisedb.com>
Discussion:
https://www.postgresql.org/message-id/flat/CAM2%2B6%3DWaf3qJ1%3DyVTUH8_yG-SC0xcBMY%2BSFLhvKKNnWNXSUDBw%40mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/abb9c63b2c00109183cdb9f588d2f23fc383ed38

Modified Files
--------------
src/backend/utils/adt/like_support.c  |  4 +++-
src/test/regress/expected/strings.out | 16 ++++++++++++++++
src/test/regress/sql/strings.sql      | 13 +++++++++++++
3 files changed, 32 insertions(+), 1 deletion(-)


pgsql-committers by date:

Previous
From: Michael Paquier
Date:
Subject: pgsql: Fix SHOW ALL command for non-superusers with replicationconnect
Next
From: Masahiko Sawada
Date:
Subject: Re: pgsql: Increase upper limit for vacuum_cleanup_index_scale_factor