EVOLUTION-MANAGER

Edit File: other_alter.result

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)engine=TokuDB; create table bar (a int) engine=TokuDB; alter table foo drop primary key; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo drop primary key, add column z int; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo drop primary key, drop column aa; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table bar add primary key (a); ERROR 42000: Table 'bar' uses an extension that doesn't exist in this XYZ version alter table bar add primary key (a), add column z int; ERROR 42000: Table 'bar' uses an extension that doesn't exist in this XYZ version alter table foo drop primary key, add primary key (b); ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo drop primary key, add primary key (b), add column z int; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo drop primary key, add primary key (b), drop column aa; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo add fulltext key(b); ERROR HY000: The storage engine TokuDB doesn't support FULLTEXT indexes alter table foo add spatial key (aa); ERROR HY000: The storage engine TokuDB doesn't support SPATIAL indexes alter table foo alter column cc set default 101010; alter table foo alter column cc set default NULL; alter table foo alter column cc drop default; alter table foo alter column cc set default 101010, add column z int; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo alter column cc set default NULL, add column z int; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo alter column cc drop default, add column z int; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo alter column cc set default 101010, drop column aa; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo alter column cc set default NULL, drop column aa; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo alter column cc drop default, drop column aa; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo change column aa aaa int, add column z int; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo change column e epk int, add column z int; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo change column aa aaa int, drop column bb; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo change column e epk int, drop column bb; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version show create table foo; Table Create Table foo CREATE TABLE `foo` ( `aa` int(11) DEFAULT NULL, `bb` int(11) DEFAULT NULL, `cc` int(11), `dd` int(11) DEFAULT NULL, `ee` int(11) DEFAULT NULL, `a` int(11) DEFAULT NULL, `b` varchar(20) DEFAULT NULL, `c` int(11) DEFAULT NULL, `d` int(11) DEFAULT NULL, `e` int(11) NOT NULL, PRIMARY KEY (`e`), UNIQUE KEY `c` (`c`), KEY `d` (`d`), KEY `b` (`b`) `clustering`=yes ) ENGINE=TokuDB DEFAULT CHARSET=latin1 alter table foo change column aa aa int NOT NULL; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo change column aa aa varchar(20); ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo change column aa aa int after cc; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo modify column aa int NOT NULL; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo modify column aa varchar(20); ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo modify column aa int after cc; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo change column aa aa int NOT NULL, add column z int; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo change column aa aa bigint, add column z int; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo change column aa aa varchar(20), add column z int; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo change column aa aa int after cc, add column z int; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo modify column aa int NOT NULL, add column z int; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo modify column aa bigint, add column z int; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo modify column aa varchar(20), add column z int; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo modify column aa int after cc, add column z int; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo change column aa aa int NOT NULL, drop column bb; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo change column aa aa bigint, drop column bb; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo change column aa aa varchar(20), drop column bb; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo change column aa aa int after cc, drop column bb; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo modify column aa int NOT NULL, drop column bb; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo modify column aa bigint, drop column bb; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo modify column aa varchar(20), drop column bb; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version alter table foo modify column aa int after cc, drop column bb; ERROR 42000: Table 'foo' uses an extension that doesn't exist in this XYZ version drop table foo; drop table bar;