]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Ensure we allocate NAMEDATALEN bytes for names in Index Only Scans
authorDavid Rowley <drowley@postgresql.org>
Wed, 1 May 2024 01:23:25 +0000 (13:23 +1200)
committerDavid Rowley <drowley@postgresql.org>
Wed, 1 May 2024 01:23:25 +0000 (13:23 +1200)
commite3f9dcabd6f2c4c1845f16ec24b59e0751b055af
tree1fe0f0d51446e34d1b6101e4d374033106be07e0
parent56d30fb10d5ce5e2d8b432eeaca8ecf2fc2a6900
Ensure we allocate NAMEDATALEN bytes for names in Index Only Scans

As an optimization, we store "name" columns as cstrings in btree
indexes.

Here we modify it so that Index Only Scans convert these cstrings back
to names with NAMEDATALEN bytes rather than storing the cstring in the
tuple slot, as was happening previously.

Bug: #17855
Reported-by: Alexander Lakhin
Reviewed-by: Alexander Lakhin, Tom Lane
Discussion: https://postgr.es/m/17855-5f523e0f9769a566@postgresql.org
Backpatch-through: 12, all supported versions
src/backend/executor/nodeIndexonlyscan.c
src/include/catalog/pg_opclass.dat
src/include/nodes/execnodes.h
src/test/regress/expected/index_including.out
src/test/regress/sql/index_including.sql