text: --+ holdcas on;
  ---- ALTER TABLE ...  CHANGE COLUMN  , type change
  -- constraints : no constraints
  -- ordering : no order defined
  -- name : same name
  
  set system parameters 'allow_truncated_string=yes';
  set system parameters 'alter_table_change_type_strict=yes';
  set system parameters 'error_log_level=warning';
  set system parameters 'error_log_warning=yes';
  
  -------------- SET 1 : domain increase
  create table t1 (s1 set (int,varchar(10)));
  insert into t1 values ({1,'123'}),({'1234567890'}),({'abc',2}),({3});
  
  select * from t1 order by 1;
  show columns in t1;
  
  alter table t1 change s1 s1 set (varchar(10),int, float);
  -- should be ok:
  insert into t1 values ({123,3.13});
  select * from t1 order by 1;
  show columns in t1;
  
  drop table t1;
  
  
  -------------- SET 2 : domain changed
  create table t1 (s1 set (int,varchar(10)));
  insert into t1 values ({1,'123'}),({'1234567890'}),({'abc',2}),({3});
  
  select * from t1 order by 1;
  show columns in t1;
  
  
  alter table t1 change s1 s1 set (varchar(10), float);
  
  insert into t1 values ({123,3.13});
  select * from t1 order by 1;
  show columns in t1;
  
  drop table t1;
  
  -------------- SET 3 : truncation
  create table t1 (s1 set (int,varchar(10)));
  insert into t1 values ({123456,'123'}),({'1234567890'}),({'abc',2}),({3});
  
  select * from t1 order by 1;
  show columns in t1;
  
  
  alter table t1 change s1 s1 set (varchar(5), int);
  
  insert into t1 values ({123,3.13});
  select * from t1 order by 1;
  show columns in t1;
  
  drop table t1;
  
  -------------- SET 4 : overflow
  create table t1 (s1 set (int,varchar(10)));
  insert into t1 values ({123456,'123'}),({'1234567890'}),({'abc',2}),({3});
  
  select * from t1 order by 1;
  show columns in t1;
  
  
  alter table t1 change s1 s1 set (varchar(10), short);
  
  insert into t1 values ({123,3.13});
  select * from t1 order by 1;
  show columns in t1;
  
  drop table t1;
  
  
  set system parameters 'allow_truncated_string=no';
  set system parameters 'alter_table_change_type_strict=yes';
  commit;
  --+ holdcas off;
  