Skip to content

Commit 5862cda

Browse files
committed
Fix an ALTER TABLE test case so that it actually tests what the comment says it
is testing. Ah, the perils of making keywords optional ...
1 parent 8374246 commit 5862cda

File tree

2 files changed

+3
-2
lines changed

2 files changed

+3
-2
lines changed

src/test/regress/expected/alter_table.out

+2-1
Original file line numberDiff line numberDiff line change
@@ -351,7 +351,8 @@ alter table atacc3 inherit atacc2;
351351
ERROR: child table is missing column "test2"
352352
-- fail due to mismatched data type
353353
alter table atacc3 add test2 bool;
354-
alter table atacc3 add inherit atacc2;
354+
alter table atacc3 inherit atacc2;
355+
ERROR: child table "atacc3" has different type for column "test2"
355356
alter table atacc3 drop test2;
356357
-- succeed
357358
alter table atacc3 add test2 int;

src/test/regress/sql/alter_table.sql

+1-1
Original file line numberDiff line numberDiff line change
@@ -373,7 +373,7 @@ alter table atacc3 rename test2 to testx;
373373
alter table atacc3 inherit atacc2;
374374
-- fail due to mismatched data type
375375
alter table atacc3 add test2 bool;
376-
alter table atacc3 add inherit atacc2;
376+
alter table atacc3 inherit atacc2;
377377
alter table atacc3 drop test2;
378378
-- succeed
379379
alter table atacc3 add test2 int;

0 commit comments

Comments
 (0)