Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit1c95f0b

Browse files
committed
Use less-generic table name in new regression test case.
Creating global objects named "foo" isn't an especially wise thing,but especially not in a test script that has already used that namefor something else, and most especially not in a script that runsin parallel with other scripts that use that name :-(Per buildfarm.
1 parent38d1037 commit1c95f0b

File tree

2 files changed

+8
-8
lines changed

2 files changed

+8
-8
lines changed

‎src/test/regress/expected/alter_table.out

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -3034,18 +3034,18 @@ CREATE TABLE list_partitioned (a int not null) partition by list (a);
30343034
ALTER TABLE list_partitioned ALTER a DROP NOT NULL;
30353035
DROP TABLE list_partitioned;
30363036
-- partitioned table cannot participate in regular inheritance
3037-
CREATE TABLEfoo (
3037+
CREATE TABLEnonpartitioned (
30383038
a int,
30393039
b int
30403040
);
3041-
ALTER TABLE partitioned INHERITfoo;
3041+
ALTER TABLE partitioned INHERITnonpartitioned;
30423042
ERROR: cannot change inheritance of partitioned table
3043-
ALTER TABLEfoo INHERIT partitioned;
3043+
ALTER TABLEnonpartitioned INHERIT partitioned;
30443044
ERROR: cannot inherit from partitioned table "partitioned"
30453045
-- cannot add NO INHERIT constraint to partitioned tables
30463046
ALTER TABLE partitioned ADD CONSTRAINT chk_a CHECK (a > 0) NO INHERIT;
30473047
ERROR: cannot add NO INHERIT constraint to partitioned table "partitioned"
3048-
DROP TABLE partitioned,foo;
3048+
DROP TABLE partitioned,nonpartitioned;
30493049
--
30503050
-- ATTACH PARTITION
30513051
--

‎src/test/regress/sql/alter_table.sql

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1923,17 +1923,17 @@ ALTER TABLE list_partitioned ALTER a DROP NOT NULL;
19231923
DROPTABLE list_partitioned;
19241924

19251925
-- partitioned table cannot participate in regular inheritance
1926-
CREATETABLEfoo (
1926+
CREATETABLEnonpartitioned (
19271927
aint,
19281928
bint
19291929
);
1930-
ALTERTABLE partitioned INHERITfoo;
1931-
ALTERTABLEfoo INHERIT partitioned;
1930+
ALTERTABLE partitioned INHERITnonpartitioned;
1931+
ALTERTABLEnonpartitioned INHERIT partitioned;
19321932

19331933
-- cannot add NO INHERIT constraint to partitioned tables
19341934
ALTERTABLE partitioned ADDCONSTRAINT chk_aCHECK (a>0) NO INHERIT;
19351935

1936-
DROPTABLE partitioned,foo;
1936+
DROPTABLE partitioned,nonpartitioned;
19371937

19381938
--
19391939
-- ATTACH PARTITION

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp