Horton

Align tests for stored and virtual generated columns

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 9a9998163bda0d8c17d84ea22ced6a60f8018634
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2026-03-27T14:49:34Z
Releases: 19 (unreleased) 
Align tests for stored and virtual generated columns

These tests were intended to be aligned with each other, but
additional tests for virtual generated columns disrupted that
alignment.  The test confirming that user-defined types are not
allowed in virtual generated columns has also been moved to the
generated_virtual.sql-specific section.

Author: Yugo Nagata <nagata@sraoss.co.jp>
Reviewed-by: Paul A Jungwirth <pj@illuminatedcomputing.com>
Reviewed-by: Mutaamba Maasha <maasha@gmail.com>
Reviewed-by: Surya Poondla <s_poondla@apple.com>
Discussion: https://www.postgresql.org/message-id/flat/20250808115142.e9ccb81f35466a9a131a4c55@sraoss.co.jp

Files

PathChange+/−
src/test/regress/expected/generated_stored.out modified +68 −2
src/test/regress/expected/generated_virtual.out modified +7 −7
src/test/regress/sql/generated_stored.sql modified +49 −2
src/test/regress/sql/generated_virtual.sql modified +4 −4

Discussion