From 7524c3ab5cd1c72ec13ed63ecd526e88b24d5f22 Mon Sep 17 00:00:00 2001 From: Ian Barwick Date: Mon, 15 Dec 2014 22:10:42 +0900 Subject: [PATCH] Add CREATE DOMAIN test --- src/test/regress/ddl-deparse/ddl-schedule | 1 + .../regress/ddl-deparse/expected/create_domain.out | 9 +++++++++ src/test/regress/ddl-deparse/sql/create_domain.sql | 10 ++++++++++ 3 files changed, 20 insertions(+) create mode 100644 src/test/regress/ddl-deparse/expected/create_domain.out create mode 100644 src/test/regress/ddl-deparse/sql/create_domain.sql diff --git a/src/test/regress/ddl-deparse/ddl-schedule b/src/test/regress/ddl-deparse/ddl-schedule index 24e9369577..4c66a5e55c 100644 --- a/src/test/regress/ddl-deparse/ddl-schedule +++ b/src/test/regress/ddl-deparse/ddl-schedule @@ -11,6 +11,7 @@ test: deparse_init # DDL tests test: create_schema test: create_type_enum +test: create_domain test: create_sequence_1 test: create_table test: create_sequence_2 diff --git a/src/test/regress/ddl-deparse/expected/create_domain.out b/src/test/regress/ddl-deparse/expected/create_domain.out new file mode 100644 index 0000000000..1b2200d137 --- /dev/null +++ b/src/test/regress/ddl-deparse/expected/create_domain.out @@ -0,0 +1,9 @@ +--- +--- CREATE_DOMAIN +--- +CREATE DOMAIN domainvarchar VARCHAR(5); +CREATE DOMAIN japanese_postal_code AS TEXT +CHECK( + VALUE ~ '^\d{3}$' +OR VALUE ~ '^\d{3}-\d{4}$' +); diff --git a/src/test/regress/ddl-deparse/sql/create_domain.sql b/src/test/regress/ddl-deparse/sql/create_domain.sql new file mode 100644 index 0000000000..6ab5525870 --- /dev/null +++ b/src/test/regress/ddl-deparse/sql/create_domain.sql @@ -0,0 +1,10 @@ +--- +--- CREATE_DOMAIN +--- +CREATE DOMAIN domainvarchar VARCHAR(5); + +CREATE DOMAIN japanese_postal_code AS TEXT +CHECK( + VALUE ~ '^\d{3}$' +OR VALUE ~ '^\d{3}-\d{4}$' +); -- 2.39.5