pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Paquier <michael@paquier.xyz>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Add some regression tests for missing DDL patterns
Date: Thu, 12 Dec 2024 02:17:34 +0000
Message-ID: <E1tLYli-002HRs-1v@gemulon.postgresql.org> (raw)

Add some regression tests for missing DDL patterns

The following commands gain increased coverage for some of the errors
they can trigger:
- ALTER TABLE .. ALTER COLUMN
- CREATE DOMAIN
- CREATE TYPE (LIKE)

This has come up while discussing the possibility to add more
information about the location of the error in such queries, and it
is useful on its own as there was no coverage until now for the
patterns added in this commit.

Author: Jian He, Kirill Reshke
Reviewed-By: Álvaro Herrera, Michael Paquier
Discussion: https://postgr.es/m/CALdSSPhqfvKbDwqJaY=yEePi_aq61GmMpW88i6ZH7CMG_2Z4Cg@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/0172b4c9449e92a3988f669d9e7e9000454d16ce

Modified Files
--------------
src/test/regress/expected/alter_table.out |  7 +++++++
src/test/regress/expected/domain.out      | 27 +++++++++++++++++++++++++++
src/test/regress/expected/float8.out      |  2 ++
src/test/regress/expected/identity.out    |  2 ++
src/test/regress/sql/alter_table.sql      |  5 +++++
src/test/regress/sql/domain.sql           | 14 ++++++++++++++
src/test/regress/sql/float8.sql           |  1 +
src/test/regress/sql/identity.sql         |  1 +
8 files changed, 59 insertions(+)



Message-ID: <E1tLYli-002HRs-1v@gemulon.postgresql.org>
Permalink:  ../E1tLYli-002HRs-1v@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1tLYli-002HRs-1v@gemulon.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: michael@paquier.xyz, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Add some regression tests for missing DDL patterns
  In-Reply-To: <E1tLYli-002HRs-1v@gemulon.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox