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 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74
|
SET DEFAULT_STORAGE_ENGINE='tokudb';
DROP TABLE IF EXISTS foo,bar;
set session tokudb_disable_slow_alter=ON;
create table foo (aa int, bb int, cc int, dd int, ee int, a int, b varchar(20), c int, d int, e int, primary key (e), key(d), unique key(c), key (b) clustering=yes);
alter table foo drop column e;
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo drop column d;
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo drop column c;
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo drop column b;
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo add column aaa int first;
alter table foo drop column aaa;
alter table foo add column aaa int first;
alter table foo drop column aaa, drop index d;
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo drop column aaa, add index (bb);
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo drop index b, add index b(b);
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo drop column aaa, drop index b, add index b(d);
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo drop column aaa, drop index b, add index b(b);
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo drop column aaa, drop index b, add index b(b(5)) clustering=yes;
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo drop column aaa, drop index b, add index b(b) clustering=yes;
alter table foo add column aaa int, drop index d;
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo add column aaa int, add index (bb);
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo add column aaa int, drop index b, add index b(b);
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo add column aaa int, drop index b, add index b(d);
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo add column aaa int, drop index b, add unique index b(b);
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo add column aaa int, drop index b, add index b(b);
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo add column aaa int, drop index b, add index b(b(5)) clustering=yes;
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo add column aaa int, drop index b, add index b(b) clustering=yes;
alter table foo drop column aaa, drop index c;
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo drop column aaa, add index (bb);
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo drop index c, add index c(c);
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo drop column aaa, drop index c, add index c(d);
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo drop column aaa, drop index c, add index c(c);
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo drop column aaa, drop index c, add unique index c(c);
alter table foo add column aaa int, drop index c;
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo add column aaa int, add index (bb);
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo add column aaa int, drop index c, add index c(c);
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo add column aaa int, drop index c, add index c(d);
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo add column aaa int, drop index c, add index c(c) clustering=yes;
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo add column aaa int, drop index c, add index c(c);
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo add column aaa int, drop index c, add unique index c(c);
alter table foo add column aaaa int, drop column c;
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo add column aaaa int, add column bbbb int, drop column c;
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
alter table foo add column aaaa int, drop column c, drop column b;
ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version
drop table foo;
|