1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
|
drop table if exists t;
set default_storage_engine='tokudb';
set tokudb_disable_slow_alter=1;
create table t (a tinyblob);
alter table t change column a aa tinyblob;
alter table t change column aa a3 blob;
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
alter table t change column aa a3 blob not null;
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
alter table t change column aa a3 mediumblob;
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
alter table t change column aa a3 mediumblob not null;
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
alter table t change column aa a3 longblob;
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
alter table t change column aa a3 longblob not null;
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
drop table t;
create table t (a blob);
alter table t change column a aa blob;
alter table t change column aa a3 tinyblob;
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
alter table t change column aa a3 mediumblob;
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
alter table t change column aa a3 longblob;
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
drop table t;
create table t (a mediumblob);
alter table t change column a aa mediumblob;
alter table t change column aa a3 tinyblob;
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
alter table t change column aa a3 blob;
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
alter table t change column aa a3 longblob;
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
drop table t;
create table t (a longblob);
alter table t change column a aa longblob;
alter table t change column aa a3 tinyblob;
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
alter table t change column aa a3 blob;
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
alter table t change column aa a3 mediumblob;
ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version
drop table t;
|