text: --+ holdcas on;
  --alter_table_change_type_strict
  --change the type of a numeric column to nchar varying
  
  create class coo(
          col1 numeric(7, 3),
          col2 numeric(10),
          col3 numeric(10, 3),
  	col4 numeric(20, 5)
  );
  
  insert numerico coo
   values(7382.234, -1234523456, -2112354.321, 738292753377772.56383);
  
  
  show columns in coo;
  
  
  --numeric -> nchar varying, old prec + 2 < new prec
  alter table coo change col1 col1 nchar varying(10);
  select * from coo order by 1;
  
  --numeric -> nchar varying, old prec + 2 = new prec, scale = 0
  alter table coo change col2 col2 nchar varying(12);
  select * from coo order by 1;
  
  --numeric -> nchar varying, new prec < old prec
  set system parameters 'alter_table_change_type_strict=yes';
  alter table coo change col3 col3 nchar varying(8);
  set system parameters 'alter_table_change_type_strict=no';
  alter table coo change col3 col3 nchar varying(8);
  select * from coo order by 1;
  
  --numeric -> nchar varying, new prec = 0
  alter table coo change col4 col4 nchar varying;
  select * from coo order by 1;
  
  
  show columns in coo;
  
  drop table coo;
  
  
  commit;
  --+ holdcas off;
  