File tree 2 files changed +3
-2
lines changed
2 files changed +3
-2
lines changed Original file line number Diff line number Diff line change @@ -351,7 +351,8 @@ alter table atacc3 inherit atacc2;
351
351
ERROR: child table is missing column "test2"
352
352
-- fail due to mismatched data type
353
353
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"
355
356
alter table atacc3 drop test2;
356
357
-- succeed
357
358
alter table atacc3 add test2 int;
Original file line number Diff line number Diff line change @@ -373,7 +373,7 @@ alter table atacc3 rename test2 to testx;
373
373
alter table atacc3 inherit atacc2;
374
374
-- fail due to mismatched data type
375
375
alter table atacc3 add test2 bool;
376
- alter table atacc3 add inherit atacc2;
376
+ alter table atacc3 inherit atacc2;
377
377
alter table atacc3 drop test2;
378
378
-- succeed
379
379
alter table atacc3 add test2 int ;
You can’t perform that action at this time.
0 commit comments