Horton

Add tuple deformation test for virtual generated columns

David Rowley <drowley@postgresql.org>

View on postgr.es
Commit: 1f7dfe8c8ef725ded72f7398ceca4b39ea511aee
Author: David Rowley <drowley@postgresql.org>
Date: 2026-06-17T04:57:16Z
Releases: 19 (unreleased) 
Add tuple deformation test for virtual generated columns

Add coverage for a virtual generated NOT NULL column followed by a
physically stored NOT NULL column.  This exercises the tuple deformation
case fixed by 89eafad297a, where TupleDescFinalize() could incorrectly
treat a virtual generated column as part of the guaranteed physical column
prefix and compute cached offsets past it.

Without that fix, deforming the following column could read from the wrong
tuple offset.

Author: Chao Li <li.evan.chao@gmail.com>
Discussion: https://postgr.es/m/A4BC563C-0CA3-4EF3-952A-EA41F9E5BF1E%40gmail.com

Files

PathChange+/−
src/test/regress/expected/generated_stored.out modified +5 −0
src/test/regress/expected/generated_virtual.out modified +10 −0
src/test/regress/sql/generated_stored.sql modified +5 −0
src/test/regress/sql/generated_virtual.sql modified +6 −0

Discussion