1DROP TABLE IF EXISTS t; 2SET SESSION TOKUDB_DISABLE_SLOW_ALTER=ON; 3SET SESSION DEFAULT_STORAGE_ENGINE='TokuDB'; 4CREATE TABLE t (a TINYINT DEFAULT 1); 5ALTER TABLE t CHANGE COLUMN a a TINYINT DEFAULT 100; 6SHOW CREATE TABLE t; 7Table Create Table 8t CREATE TABLE `t` ( 9 `a` tinyint(4) DEFAULT 100 10) ENGINE=TokuDB DEFAULT CHARSET=latin1 11ALTER TABLE t CHANGE COLUMN a a SMALLINT DEFAULT 200; 12SHOW CREATE TABLE t; 13Table Create Table 14t CREATE TABLE `t` ( 15 `a` smallint(6) DEFAULT 200 16) ENGINE=TokuDB DEFAULT CHARSET=latin1 17ALTER TABLE t CHANGE COLUMN a a MEDIUMINT DEFAULT 300; 18SHOW CREATE TABLE t; 19Table Create Table 20t CREATE TABLE `t` ( 21 `a` mediumint(9) DEFAULT 300 22) ENGINE=TokuDB DEFAULT CHARSET=latin1 23ALTER TABLE t CHANGE COLUMN a a INT DEFAULT 400; 24SHOW CREATE TABLE t; 25Table Create Table 26t CREATE TABLE `t` ( 27 `a` int(11) DEFAULT 400 28) ENGINE=TokuDB DEFAULT CHARSET=latin1 29ALTER TABLE t CHANGE COLUMN a a BIGINT DEFAULT 500; 30SHOW CREATE TABLE t; 31Table Create Table 32t CREATE TABLE `t` ( 33 `a` bigint(20) DEFAULT 500 34) ENGINE=TokuDB DEFAULT CHARSET=latin1 35DROP TABLE t; 36CREATE TABLE t (a TINYINT NOT NULL DEFAULT 1); 37ALTER TABLE t CHANGE COLUMN a a TINYINT NOT NULL DEFAULT 100; 38SHOW CREATE TABLE t; 39Table Create Table 40t CREATE TABLE `t` ( 41 `a` tinyint(4) NOT NULL DEFAULT 100 42) ENGINE=TokuDB DEFAULT CHARSET=latin1 43ALTER TABLE t CHANGE COLUMN a a SMALLINT NOT NULL DEFAULT 200; 44SHOW CREATE TABLE t; 45Table Create Table 46t CREATE TABLE `t` ( 47 `a` smallint(6) NOT NULL DEFAULT 200 48) ENGINE=TokuDB DEFAULT CHARSET=latin1 49ALTER TABLE t CHANGE COLUMN a a MEDIUMINT NOT NULL DEFAULT 300; 50SHOW CREATE TABLE t; 51Table Create Table 52t CREATE TABLE `t` ( 53 `a` mediumint(9) NOT NULL DEFAULT 300 54) ENGINE=TokuDB DEFAULT CHARSET=latin1 55ALTER TABLE t CHANGE COLUMN a a INT NOT NULL DEFAULT 400; 56SHOW CREATE TABLE t; 57Table Create Table 58t CREATE TABLE `t` ( 59 `a` int(11) NOT NULL DEFAULT 400 60) ENGINE=TokuDB DEFAULT CHARSET=latin1 61ALTER TABLE t CHANGE COLUMN a a BIGINT NOT NULL DEFAULT 500; 62SHOW CREATE TABLE t; 63Table Create Table 64t CREATE TABLE `t` ( 65 `a` bigint(20) NOT NULL DEFAULT 500 66) ENGINE=TokuDB DEFAULT CHARSET=latin1 67DROP TABLE t; 68CREATE TABLE t (a TINYINT UNSIGNED DEFAULT 1); 69ALTER TABLE t CHANGE COLUMN a a TINYINT UNSIGNED DEFAULT 100; 70SHOW CREATE TABLE t; 71Table Create Table 72t CREATE TABLE `t` ( 73 `a` tinyint(3) unsigned DEFAULT 100 74) ENGINE=TokuDB DEFAULT CHARSET=latin1 75ALTER TABLE t CHANGE COLUMN a a SMALLINT UNSIGNED DEFAULT 200; 76SHOW CREATE TABLE t; 77Table Create Table 78t CREATE TABLE `t` ( 79 `a` smallint(5) unsigned DEFAULT 200 80) ENGINE=TokuDB DEFAULT CHARSET=latin1 81ALTER TABLE t CHANGE COLUMN a a MEDIUMINT UNSIGNED DEFAULT 300; 82SHOW CREATE TABLE t; 83Table Create Table 84t CREATE TABLE `t` ( 85 `a` mediumint(8) unsigned DEFAULT 300 86) ENGINE=TokuDB DEFAULT CHARSET=latin1 87ALTER TABLE t CHANGE COLUMN a a INT UNSIGNED DEFAULT 400; 88SHOW CREATE TABLE t; 89Table Create Table 90t CREATE TABLE `t` ( 91 `a` int(10) unsigned DEFAULT 400 92) ENGINE=TokuDB DEFAULT CHARSET=latin1 93ALTER TABLE t CHANGE COLUMN a a BIGINT UNSIGNED DEFAULT 500; 94SHOW CREATE TABLE t; 95Table Create Table 96t CREATE TABLE `t` ( 97 `a` bigint(20) unsigned DEFAULT 500 98) ENGINE=TokuDB DEFAULT CHARSET=latin1 99DROP TABLE t; 100CREATE TABLE t (a TINYINT UNSIGNED NOT NULL DEFAULT 1); 101ALTER TABLE t CHANGE COLUMN a a TINYINT UNSIGNED NOT NULL DEFAULT 100; 102SHOW CREATE TABLE t; 103Table Create Table 104t CREATE TABLE `t` ( 105 `a` tinyint(3) unsigned NOT NULL DEFAULT 100 106) ENGINE=TokuDB DEFAULT CHARSET=latin1 107ALTER TABLE t CHANGE COLUMN a a SMALLINT UNSIGNED NOT NULL DEFAULT 200; 108SHOW CREATE TABLE t; 109Table Create Table 110t CREATE TABLE `t` ( 111 `a` smallint(5) unsigned NOT NULL DEFAULT 200 112) ENGINE=TokuDB DEFAULT CHARSET=latin1 113ALTER TABLE t CHANGE COLUMN a a MEDIUMINT UNSIGNED NOT NULL DEFAULT 300; 114SHOW CREATE TABLE t; 115Table Create Table 116t CREATE TABLE `t` ( 117 `a` mediumint(8) unsigned NOT NULL DEFAULT 300 118) ENGINE=TokuDB DEFAULT CHARSET=latin1 119ALTER TABLE t CHANGE COLUMN a a INT UNSIGNED NOT NULL DEFAULT 400; 120SHOW CREATE TABLE t; 121Table Create Table 122t CREATE TABLE `t` ( 123 `a` int(10) unsigned NOT NULL DEFAULT 400 124) ENGINE=TokuDB DEFAULT CHARSET=latin1 125ALTER TABLE t CHANGE COLUMN a a BIGINT UNSIGNED NOT NULL DEFAULT 500; 126SHOW CREATE TABLE t; 127Table Create Table 128t CREATE TABLE `t` ( 129 `a` bigint(20) unsigned NOT NULL DEFAULT 500 130) ENGINE=TokuDB DEFAULT CHARSET=latin1 131DROP TABLE t; 132