pgsql: Add a test for creating an index on a whole-row expression.

From: Robert Haas <rhaas(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add a test for creating an index on a whole-row expression.
Date: 2026-03-24 14:14:10
Message-ID: E1w52WH-001FGT-1K@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add a test for creating an index on a whole-row expression.

Surprisingly, we have no existing test for this. Had this test
been present before commit 570e2fcc041a55ba8991a640cc3f3f0e122feac3
the Assert added in commit c98ad086ad9b1ca9dbb2725f246298fa8450d82f
would have caught the bug.

Reviewed-by: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Discussion: http://postgr.es/m/CA+TgmoacixUZVvi00hOjk_d9B4iYKswWP1gNqQ8Vfray-AcOCA@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/4647ee2da37c106f0b964171227df956082d39a4

Modified Files
--------------
src/test/regress/expected/indexing.out | 11 +++++++++++
src/test/regress/sql/indexing.sql | 12 ++++++++++++
2 files changed, 23 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Nathan Bossart 2026-03-24 14:33:07 pgsql: test_bloomfilter: Fix error message.
Previous Message Peter Eisentraut 2026-03-24 13:36:49 pgsql: Fix accidentally casting away const