Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL), 10.6, 10.7(EOL), 10.8(EOL), 10.11, 11.4, 11.8, 12.1(EOL)
-
None
Description
create table t (c date); |
alter table t change column if exists n c int unique; |
this should fail, because the column n does not exist. But it partially succeeds, the result is c date unique.
Another example, for ADD IF NOT EXISTS:
create table t (c date); |
alter table t add column if not exists c int unique; |
Same effect.