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 <[email protected]>
Reviewed-by: Chao Li <[email protected]>
Discussion: 
https://www.postgresql.org/message-id/CACJufxFDi7fnwB-8xXd_ExML7-7pKbTaK4j46AJ=4-14dxv...@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/343693c3c116688970be550fcbf15f7ddf55525b

Modified Files
--------------
.../test_ddl_deparse/expected/alter_table.out      | 41 ++++++++++++----------
.../modules/test_ddl_deparse/sql/alter_table.sql   | 27 +++++++-------
2 files changed, 36 insertions(+), 32 deletions(-)

Reply via email to