Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL), 10.7(EOL), 10.8(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.