1
DROP TABLE IF EXISTS t5;
2
CREATE TEMPORARY TABLE t5(c1 BIT(10) NULL);
7
t5 CREATE TEMPORARY TABLE `t5` (
8
`c1` bit(10) DEFAULT NULL
9
) ENGINE=ENGINE DEFAULT CHARSET=latin1
13
CREATE TEMPORARY TABLE t5(c1 TINYINT(10) NULL);
18
t5 CREATE TEMPORARY TABLE `t5` (
19
`c1` tinyint(10) DEFAULT NULL
20
) ENGINE=ENGINE DEFAULT CHARSET=latin1
24
CREATE TEMPORARY TABLE t5(c1 SMALLINT(10) NULL);
29
t5 CREATE TEMPORARY TABLE `t5` (
30
`c1` smallint(10) DEFAULT NULL
31
) ENGINE=ENGINE DEFAULT CHARSET=latin1
35
CREATE TEMPORARY TABLE t5(c1 MEDIUMINT(10) NULL);
40
t5 CREATE TEMPORARY TABLE `t5` (
41
`c1` mediumint(10) DEFAULT NULL
42
) ENGINE=ENGINE DEFAULT CHARSET=latin1
46
CREATE TEMPORARY TABLE t5(c1 INT(10) NULL);
51
t5 CREATE TEMPORARY TABLE `t5` (
52
`c1` int(10) DEFAULT NULL
53
) ENGINE=ENGINE DEFAULT CHARSET=latin1
57
CREATE TEMPORARY TABLE t5(c1 INTEGER(10) NULL);
62
t5 CREATE TEMPORARY TABLE `t5` (
63
`c1` int(10) DEFAULT NULL
64
) ENGINE=ENGINE DEFAULT CHARSET=latin1
68
CREATE TEMPORARY TABLE t5(c1 BIGINT(10) NULL);
73
t5 CREATE TEMPORARY TABLE `t5` (
74
`c1` bigint(10) DEFAULT NULL
75
) ENGINE=ENGINE DEFAULT CHARSET=latin1
79
CREATE TEMPORARY TABLE t5(c1 CHAR(10) NULL);
84
t5 CREATE TEMPORARY TABLE `t5` (
85
`c1` char(10) DEFAULT NULL
86
) ENGINE=ENGINE DEFAULT CHARSET=latin1
90
CREATE TEMPORARY TABLE t5(c1 VARCHAR(10) NULL);
95
t5 CREATE TEMPORARY TABLE `t5` (
96
`c1` varchar(10) DEFAULT NULL
97
) ENGINE=ENGINE DEFAULT CHARSET=latin1
101
CREATE TEMPORARY TABLE t5(c1 BINARY(10) NULL);
104
SHOW CREATE TABLE t5;
106
t5 CREATE TEMPORARY TABLE `t5` (
107
`c1` binary(10) DEFAULT NULL
108
) ENGINE=ENGINE DEFAULT CHARSET=latin1
112
CREATE TEMPORARY TABLE t5(c1 VARBINARY(10) NULL);
115
SHOW CREATE TABLE t5;
117
t5 CREATE TEMPORARY TABLE `t5` (
118
`c1` varbinary(10) DEFAULT NULL
119
) ENGINE=ENGINE DEFAULT CHARSET=latin1
123
CREATE TEMPORARY TABLE t5(c1 BIT(10) NOT NULL);
126
SHOW CREATE TABLE t5;
128
t5 CREATE TEMPORARY TABLE `t5` (
129
`c1` bit(10) NOT NULL
130
) ENGINE=ENGINE DEFAULT CHARSET=latin1
134
CREATE TEMPORARY TABLE t5(c1 TINYINT(10) NOT NULL);
137
SHOW CREATE TABLE t5;
139
t5 CREATE TEMPORARY TABLE `t5` (
140
`c1` tinyint(10) NOT NULL
141
) ENGINE=ENGINE DEFAULT CHARSET=latin1
145
CREATE TEMPORARY TABLE t5(c1 SMALLINT(10) NOT NULL);
148
SHOW CREATE TABLE t5;
150
t5 CREATE TEMPORARY TABLE `t5` (
151
`c1` smallint(10) NOT NULL
152
) ENGINE=ENGINE DEFAULT CHARSET=latin1
156
CREATE TEMPORARY TABLE t5(c1 MEDIUMINT(10) NOT NULL);
159
SHOW CREATE TABLE t5;
161
t5 CREATE TEMPORARY TABLE `t5` (
162
`c1` mediumint(10) NOT NULL
163
) ENGINE=ENGINE DEFAULT CHARSET=latin1
167
CREATE TEMPORARY TABLE t5(c1 INT(10) NOT NULL);
170
SHOW CREATE TABLE t5;
172
t5 CREATE TEMPORARY TABLE `t5` (
173
`c1` int(10) NOT NULL
174
) ENGINE=ENGINE DEFAULT CHARSET=latin1
178
CREATE TEMPORARY TABLE t5(c1 INTEGER(10) NOT NULL);
181
SHOW CREATE TABLE t5;
183
t5 CREATE TEMPORARY TABLE `t5` (
184
`c1` int(10) NOT NULL
185
) ENGINE=ENGINE DEFAULT CHARSET=latin1
189
CREATE TEMPORARY TABLE t5(c1 BIGINT(10) NOT NULL);
192
SHOW CREATE TABLE t5;
194
t5 CREATE TEMPORARY TABLE `t5` (
195
`c1` bigint(10) NOT NULL
196
) ENGINE=ENGINE DEFAULT CHARSET=latin1
200
CREATE TEMPORARY TABLE t5(c1 CHAR(10) NOT NULL);
203
SHOW CREATE TABLE t5;
205
t5 CREATE TEMPORARY TABLE `t5` (
206
`c1` char(10) NOT NULL
207
) ENGINE=ENGINE DEFAULT CHARSET=latin1
211
CREATE TEMPORARY TABLE t5(c1 VARCHAR(10) NOT NULL);
214
SHOW CREATE TABLE t5;
216
t5 CREATE TEMPORARY TABLE `t5` (
217
`c1` varchar(10) NOT NULL
218
) ENGINE=ENGINE DEFAULT CHARSET=latin1
222
CREATE TEMPORARY TABLE t5(c1 BINARY(10) NOT NULL);
225
SHOW CREATE TABLE t5;
227
t5 CREATE TEMPORARY TABLE `t5` (
228
`c1` binary(10) NOT NULL
229
) ENGINE=ENGINE DEFAULT CHARSET=latin1
233
CREATE TEMPORARY TABLE t5(c1 VARBINARY(10) NOT NULL);
236
SHOW CREATE TABLE t5;
238
t5 CREATE TEMPORARY TABLE `t5` (
239
`c1` varbinary(10) NOT NULL
240
) ENGINE=ENGINE DEFAULT CHARSET=latin1