Improve DDL deparsing test
authorHeikki Linnakangas <heikki.linnakangas@iki.fi>
Wed, 10 Dec 2025 17:27:02 +0000 (19:27 +0200)
committerHeikki Linnakangas <heikki.linnakangas@iki.fi>
Wed, 10 Dec 2025 17:27:02 +0000 (19:27 +0200)
commit343693c3c116688970be550fcbf15f7ddf55525b
treec4713690b4bb395b915cd1f88d821fe90eaa7ce1
parenteebec3ca4b5ef13d01837966f51b391143670131
Improve DDL deparsing test

1. The test initially focuses on the "parent" table, then switches to
the "part" table, and goes back to the "parent" table. That seems a
little weird, so move the tests around so that all the commands on the
"parent" table are done first, followed by the "part" table.

2. ALTER TABLE ALTER COLUMN SET EXPRESSION was not tested, so add
that.

Author: jian he <jian.universality@gmail.com>
Reviewed-by: Chao Li <li.evan.chao@gmail.com>
Discussion: https://www.postgresql.org/message-id/CACJufxFDi7fnwB-8xXd_ExML7-7pKbTaK4j46AJ=4-14DXvtVg@mail.gmail.com
src/test/modules/test_ddl_deparse/expected/alter_table.out
src/test/modules/test_ddl_deparse/sql/alter_table.sql