1DROP TABLE IF EXISTS t; 2SET SESSION DEFAULT_STORAGE_ENGINE="TokuDB"; 3SET SESSION TOKUDB_DISABLE_SLOW_ALTER=1; 4CREATE TABLE t (a TINYINT, PRIMARY KEY(a)); 5ALTER TABLE t CHANGE COLUMN a a SMALLINT; 6ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 7DROP TABLE t; 8CREATE TABLE t (a TINYINT, KEY(a)); 9ALTER TABLE t CHANGE COLUMN a a SMALLINT; 10ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 11DROP TABLE t; 12CREATE TABLE t (a TINYINT, KEY(a) CLUSTERING=YES); 13ALTER TABLE t CHANGE COLUMN a a SMALLINT; 14ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 15DROP TABLE t; 16CREATE TABLE t (a TINYINT, PRIMARY KEY(a)); 17ALTER TABLE t CHANGE COLUMN a a MEDIUMINT; 18ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 19DROP TABLE t; 20CREATE TABLE t (a TINYINT, KEY(a)); 21ALTER TABLE t CHANGE COLUMN a a MEDIUMINT; 22ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 23DROP TABLE t; 24CREATE TABLE t (a TINYINT, KEY(a) CLUSTERING=YES); 25ALTER TABLE t CHANGE COLUMN a a MEDIUMINT; 26ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 27DROP TABLE t; 28CREATE TABLE t (a TINYINT, PRIMARY KEY(a)); 29ALTER TABLE t CHANGE COLUMN a a INT; 30ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 31DROP TABLE t; 32CREATE TABLE t (a TINYINT, KEY(a)); 33ALTER TABLE t CHANGE COLUMN a a INT; 34ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 35DROP TABLE t; 36CREATE TABLE t (a TINYINT, KEY(a) CLUSTERING=YES); 37ALTER TABLE t CHANGE COLUMN a a INT; 38ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 39DROP TABLE t; 40CREATE TABLE t (a TINYINT, PRIMARY KEY(a)); 41ALTER TABLE t CHANGE COLUMN a a BIGINT; 42ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 43DROP TABLE t; 44CREATE TABLE t (a TINYINT, KEY(a)); 45ALTER TABLE t CHANGE COLUMN a a BIGINT; 46ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 47DROP TABLE t; 48CREATE TABLE t (a TINYINT, KEY(a) CLUSTERING=YES); 49ALTER TABLE t CHANGE COLUMN a a BIGINT; 50ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 51DROP TABLE t; 52CREATE TABLE t (a SMALLINT, PRIMARY KEY(a)); 53ALTER TABLE t CHANGE COLUMN a a MEDIUMINT; 54ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 55DROP TABLE t; 56CREATE TABLE t (a SMALLINT, KEY(a)); 57ALTER TABLE t CHANGE COLUMN a a MEDIUMINT; 58ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 59DROP TABLE t; 60CREATE TABLE t (a SMALLINT, KEY(a) CLUSTERING=YES); 61ALTER TABLE t CHANGE COLUMN a a MEDIUMINT; 62ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 63DROP TABLE t; 64CREATE TABLE t (a SMALLINT, PRIMARY KEY(a)); 65ALTER TABLE t CHANGE COLUMN a a INT; 66ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 67DROP TABLE t; 68CREATE TABLE t (a SMALLINT, KEY(a)); 69ALTER TABLE t CHANGE COLUMN a a INT; 70ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 71DROP TABLE t; 72CREATE TABLE t (a SMALLINT, KEY(a) CLUSTERING=YES); 73ALTER TABLE t CHANGE COLUMN a a INT; 74ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 75DROP TABLE t; 76CREATE TABLE t (a SMALLINT, PRIMARY KEY(a)); 77ALTER TABLE t CHANGE COLUMN a a BIGINT; 78ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 79DROP TABLE t; 80CREATE TABLE t (a SMALLINT, KEY(a)); 81ALTER TABLE t CHANGE COLUMN a a BIGINT; 82ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 83DROP TABLE t; 84CREATE TABLE t (a SMALLINT, KEY(a) CLUSTERING=YES); 85ALTER TABLE t CHANGE COLUMN a a BIGINT; 86ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 87DROP TABLE t; 88CREATE TABLE t (a MEDIUMINT, PRIMARY KEY(a)); 89ALTER TABLE t CHANGE COLUMN a a INT; 90ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 91DROP TABLE t; 92CREATE TABLE t (a MEDIUMINT, KEY(a)); 93ALTER TABLE t CHANGE COLUMN a a INT; 94ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 95DROP TABLE t; 96CREATE TABLE t (a MEDIUMINT, KEY(a) CLUSTERING=YES); 97ALTER TABLE t CHANGE COLUMN a a INT; 98ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 99DROP TABLE t; 100CREATE TABLE t (a MEDIUMINT, PRIMARY KEY(a)); 101ALTER TABLE t CHANGE COLUMN a a BIGINT; 102ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 103DROP TABLE t; 104CREATE TABLE t (a MEDIUMINT, KEY(a)); 105ALTER TABLE t CHANGE COLUMN a a BIGINT; 106ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 107DROP TABLE t; 108CREATE TABLE t (a MEDIUMINT, KEY(a) CLUSTERING=YES); 109ALTER TABLE t CHANGE COLUMN a a BIGINT; 110ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 111DROP TABLE t; 112CREATE TABLE t (a INT, PRIMARY KEY(a)); 113ALTER TABLE t CHANGE COLUMN a a BIGINT; 114ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 115DROP TABLE t; 116CREATE TABLE t (a INT, KEY(a)); 117ALTER TABLE t CHANGE COLUMN a a BIGINT; 118ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 119DROP TABLE t; 120CREATE TABLE t (a INT, KEY(a) CLUSTERING=YES); 121ALTER TABLE t CHANGE COLUMN a a BIGINT; 122ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 123DROP TABLE t; 124CREATE TABLE t (a TINYINT UNSIGNED, PRIMARY KEY(a)); 125ALTER TABLE t CHANGE COLUMN a a SMALLINT UNSIGNED; 126ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 127DROP TABLE t; 128CREATE TABLE t (a TINYINT UNSIGNED, KEY(a)); 129ALTER TABLE t CHANGE COLUMN a a SMALLINT UNSIGNED; 130ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 131DROP TABLE t; 132CREATE TABLE t (a TINYINT UNSIGNED, KEY(a) CLUSTERING=YES); 133ALTER TABLE t CHANGE COLUMN a a SMALLINT UNSIGNED; 134ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 135DROP TABLE t; 136CREATE TABLE t (a TINYINT UNSIGNED, PRIMARY KEY(a)); 137ALTER TABLE t CHANGE COLUMN a a MEDIUMINT UNSIGNED; 138ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 139DROP TABLE t; 140CREATE TABLE t (a TINYINT UNSIGNED, KEY(a)); 141ALTER TABLE t CHANGE COLUMN a a MEDIUMINT UNSIGNED; 142ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 143DROP TABLE t; 144CREATE TABLE t (a TINYINT UNSIGNED, KEY(a) CLUSTERING=YES); 145ALTER TABLE t CHANGE COLUMN a a MEDIUMINT UNSIGNED; 146ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 147DROP TABLE t; 148CREATE TABLE t (a TINYINT UNSIGNED, PRIMARY KEY(a)); 149ALTER TABLE t CHANGE COLUMN a a INT UNSIGNED; 150ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 151DROP TABLE t; 152CREATE TABLE t (a TINYINT UNSIGNED, KEY(a)); 153ALTER TABLE t CHANGE COLUMN a a INT UNSIGNED; 154ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 155DROP TABLE t; 156CREATE TABLE t (a TINYINT UNSIGNED, KEY(a) CLUSTERING=YES); 157ALTER TABLE t CHANGE COLUMN a a INT UNSIGNED; 158ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 159DROP TABLE t; 160CREATE TABLE t (a TINYINT UNSIGNED, PRIMARY KEY(a)); 161ALTER TABLE t CHANGE COLUMN a a BIGINT UNSIGNED; 162ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 163DROP TABLE t; 164CREATE TABLE t (a TINYINT UNSIGNED, KEY(a)); 165ALTER TABLE t CHANGE COLUMN a a BIGINT UNSIGNED; 166ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 167DROP TABLE t; 168CREATE TABLE t (a TINYINT UNSIGNED, KEY(a) CLUSTERING=YES); 169ALTER TABLE t CHANGE COLUMN a a BIGINT UNSIGNED; 170ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 171DROP TABLE t; 172CREATE TABLE t (a SMALLINT UNSIGNED, PRIMARY KEY(a)); 173ALTER TABLE t CHANGE COLUMN a a MEDIUMINT UNSIGNED; 174ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 175DROP TABLE t; 176CREATE TABLE t (a SMALLINT UNSIGNED, KEY(a)); 177ALTER TABLE t CHANGE COLUMN a a MEDIUMINT UNSIGNED; 178ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 179DROP TABLE t; 180CREATE TABLE t (a SMALLINT UNSIGNED, KEY(a) CLUSTERING=YES); 181ALTER TABLE t CHANGE COLUMN a a MEDIUMINT UNSIGNED; 182ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 183DROP TABLE t; 184CREATE TABLE t (a SMALLINT UNSIGNED, PRIMARY KEY(a)); 185ALTER TABLE t CHANGE COLUMN a a INT UNSIGNED; 186ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 187DROP TABLE t; 188CREATE TABLE t (a SMALLINT UNSIGNED, KEY(a)); 189ALTER TABLE t CHANGE COLUMN a a INT UNSIGNED; 190ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 191DROP TABLE t; 192CREATE TABLE t (a SMALLINT UNSIGNED, KEY(a) CLUSTERING=YES); 193ALTER TABLE t CHANGE COLUMN a a INT UNSIGNED; 194ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 195DROP TABLE t; 196CREATE TABLE t (a SMALLINT UNSIGNED, PRIMARY KEY(a)); 197ALTER TABLE t CHANGE COLUMN a a BIGINT UNSIGNED; 198ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 199DROP TABLE t; 200CREATE TABLE t (a SMALLINT UNSIGNED, KEY(a)); 201ALTER TABLE t CHANGE COLUMN a a BIGINT UNSIGNED; 202ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 203DROP TABLE t; 204CREATE TABLE t (a SMALLINT UNSIGNED, KEY(a) CLUSTERING=YES); 205ALTER TABLE t CHANGE COLUMN a a BIGINT UNSIGNED; 206ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 207DROP TABLE t; 208CREATE TABLE t (a MEDIUMINT UNSIGNED, PRIMARY KEY(a)); 209ALTER TABLE t CHANGE COLUMN a a INT UNSIGNED; 210ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 211DROP TABLE t; 212CREATE TABLE t (a MEDIUMINT UNSIGNED, KEY(a)); 213ALTER TABLE t CHANGE COLUMN a a INT UNSIGNED; 214ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 215DROP TABLE t; 216CREATE TABLE t (a MEDIUMINT UNSIGNED, KEY(a) CLUSTERING=YES); 217ALTER TABLE t CHANGE COLUMN a a INT UNSIGNED; 218ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 219DROP TABLE t; 220CREATE TABLE t (a MEDIUMINT UNSIGNED, PRIMARY KEY(a)); 221ALTER TABLE t CHANGE COLUMN a a BIGINT UNSIGNED; 222ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 223DROP TABLE t; 224CREATE TABLE t (a MEDIUMINT UNSIGNED, KEY(a)); 225ALTER TABLE t CHANGE COLUMN a a BIGINT UNSIGNED; 226ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 227DROP TABLE t; 228CREATE TABLE t (a MEDIUMINT UNSIGNED, KEY(a) CLUSTERING=YES); 229ALTER TABLE t CHANGE COLUMN a a BIGINT UNSIGNED; 230ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 231DROP TABLE t; 232CREATE TABLE t (a INT UNSIGNED, PRIMARY KEY(a)); 233ALTER TABLE t CHANGE COLUMN a a BIGINT UNSIGNED; 234ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 235DROP TABLE t; 236CREATE TABLE t (a INT UNSIGNED, KEY(a)); 237ALTER TABLE t CHANGE COLUMN a a BIGINT UNSIGNED; 238ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 239DROP TABLE t; 240CREATE TABLE t (a INT UNSIGNED, KEY(a) CLUSTERING=YES); 241ALTER TABLE t CHANGE COLUMN a a BIGINT UNSIGNED; 242ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 243DROP TABLE t; 244