diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2019-01-26 09:22:27 +0100 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2019-01-26 09:22:27 +0100 |
| commit | 1e4730c639acb967b8e40e6f33e81ebe1721ea5f (patch) | |
| tree | 32f83b207473f591ce432dbba82625221d5e31a9 /src | |
| parent | ebfe20dc706bd3238a9bdf3b44cd8f82337e86a8 (diff) | |
| download | postgresql-1e4730c639acb967b8e40e6f33e81ebe1721ea5f.tar.gz postgresql-1e4730c639acb967b8e40e6f33e81ebe1721ea5f.zip | |
Make regression test output locale-independent
In some locales, letters sort before numbers, so change the object
naming to not depend on that. Introduced by commit
7c079d7417a8f2d4bf5144732e2f85117db9214f.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/create_table.out | 14 | ||||
| -rw-r--r-- | src/test/regress/sql/create_table.sql | 6 |
2 files changed, 10 insertions, 10 deletions
diff --git a/src/test/regress/expected/create_table.out b/src/test/regress/expected/create_table.out index bcab214401e..100fa53ab0c 100644 --- a/src/test/regress/expected/create_table.out +++ b/src/test/regress/expected/create_table.out @@ -460,9 +460,9 @@ DROP TABLE partitioned, partitioned2; CREATE TABLE list_parted ( a int ) PARTITION BY LIST (a); -CREATE TABLE part_1 PARTITION OF list_parted FOR VALUES IN ('1'); -CREATE TABLE part_2 PARTITION OF list_parted FOR VALUES IN (2); -CREATE TABLE part_3 PARTITION OF list_parted FOR VALUES IN ((2+1)); +CREATE TABLE part_p1 PARTITION OF list_parted FOR VALUES IN ('1'); +CREATE TABLE part_p2 PARTITION OF list_parted FOR VALUES IN (2); +CREATE TABLE part_p3 PARTITION OF list_parted FOR VALUES IN ((2+1)); CREATE TABLE part_null PARTITION OF list_parted FOR VALUES IN (null); \d+ list_parted Partitioned table "public.list_parted" @@ -470,10 +470,10 @@ CREATE TABLE part_null PARTITION OF list_parted FOR VALUES IN (null); --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: LIST (a) -Partitions: part_1 FOR VALUES IN (1), - part_2 FOR VALUES IN (2), - part_3 FOR VALUES IN (3), - part_null FOR VALUES IN (NULL) +Partitions: part_null FOR VALUES IN (NULL), + part_p1 FOR VALUES IN (1), + part_p2 FOR VALUES IN (2), + part_p3 FOR VALUES IN (3) -- forbidden expressions for partition bound CREATE TABLE part_bogus_expr_fail PARTITION OF list_parted FOR VALUES IN (somename); diff --git a/src/test/regress/sql/create_table.sql b/src/test/regress/sql/create_table.sql index cf6141ab6b2..22a3d901013 100644 --- a/src/test/regress/sql/create_table.sql +++ b/src/test/regress/sql/create_table.sql @@ -436,9 +436,9 @@ DROP TABLE partitioned, partitioned2; CREATE TABLE list_parted ( a int ) PARTITION BY LIST (a); -CREATE TABLE part_1 PARTITION OF list_parted FOR VALUES IN ('1'); -CREATE TABLE part_2 PARTITION OF list_parted FOR VALUES IN (2); -CREATE TABLE part_3 PARTITION OF list_parted FOR VALUES IN ((2+1)); +CREATE TABLE part_p1 PARTITION OF list_parted FOR VALUES IN ('1'); +CREATE TABLE part_p2 PARTITION OF list_parted FOR VALUES IN (2); +CREATE TABLE part_p3 PARTITION OF list_parted FOR VALUES IN ((2+1)); CREATE TABLE part_null PARTITION OF list_parted FOR VALUES IN (null); \d+ list_parted |