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