Re: ENUM and SET column types member changes

[Peter Brawley]

drop table if exists t;
create table t(e enum('a','c','e','g') );
insert into t values( 3 ), ( 4 );
alter table t modify column e enum('a','b','c','d','e','f','g');
insert into t values( 3 ), ( 4 );
select e from t;
+------+
| e    |
+------+
| e    |
| g    |
| c    |
| d    |
+------+