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