1 DROP TABLE IF EXISTS t6,t7;
2 CREATE TABLE t6(c1 REAL(1,0) NULL);
3 CREATE UNIQUE INDEX i1 ON t6(c1);
10 `c1` double(1,0) DEFAULT NULL,
11 UNIQUE KEY `i1` (`c1`)
12 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
16 CREATE TABLE t7(c1 REAL(5,4) NULL);
17 CREATE UNIQUE INDEX i1 ON t7(c1);
23 t7 CREATE TABLE `t7` (
24 `c1` double(5,4) DEFAULT NULL,
25 UNIQUE KEY `i1` (`c1`)
26 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
30 CREATE TABLE t6(c1 DOUBLE(1,0) NULL);
31 CREATE UNIQUE INDEX i1 ON t6(c1);
37 t6 CREATE TABLE `t6` (
38 `c1` double(1,0) DEFAULT NULL,
39 UNIQUE KEY `i1` (`c1`)
40 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
44 CREATE TABLE t7(c1 DOUBLE(5,4) NULL);
45 CREATE UNIQUE INDEX i1 ON t7(c1);
51 t7 CREATE TABLE `t7` (
52 `c1` double(5,4) DEFAULT NULL,
53 UNIQUE KEY `i1` (`c1`)
54 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
58 CREATE TABLE t6(c1 FLOAT(1,0) NULL);
59 CREATE UNIQUE INDEX i1 ON t6(c1);
65 t6 CREATE TABLE `t6` (
66 `c1` float(1,0) DEFAULT NULL,
67 UNIQUE KEY `i1` (`c1`)
68 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
72 CREATE TABLE t7(c1 FLOAT(5,4) NULL);
73 CREATE UNIQUE INDEX i1 ON t7(c1);
79 t7 CREATE TABLE `t7` (
80 `c1` float(5,4) DEFAULT NULL,
81 UNIQUE KEY `i1` (`c1`)
82 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
86 CREATE TABLE t6(c1 DECIMAL(1,0) NULL);
87 CREATE UNIQUE INDEX i1 ON t6(c1);
93 t6 CREATE TABLE `t6` (
94 `c1` decimal(1,0) DEFAULT NULL,
95 UNIQUE KEY `i1` (`c1`)
96 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
100 CREATE TABLE t7(c1 DECIMAL(5,4) NULL);
101 CREATE UNIQUE INDEX i1 ON t7(c1);
105 SHOW CREATE TABLE t7;
107 t7 CREATE TABLE `t7` (
108 `c1` decimal(5,4) DEFAULT NULL,
109 UNIQUE KEY `i1` (`c1`)
110 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
114 CREATE TABLE t6(c1 NUMERIC(1,0) NULL);
115 CREATE UNIQUE INDEX i1 ON t6(c1);
119 SHOW CREATE TABLE t6;
121 t6 CREATE TABLE `t6` (
122 `c1` decimal(1,0) DEFAULT NULL,
123 UNIQUE KEY `i1` (`c1`)
124 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
128 CREATE TABLE t7(c1 NUMERIC(5,4) NULL);
129 CREATE UNIQUE INDEX i1 ON t7(c1);
133 SHOW CREATE TABLE t7;
135 t7 CREATE TABLE `t7` (
136 `c1` decimal(5,4) DEFAULT NULL,
137 UNIQUE KEY `i1` (`c1`)
138 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
142 CREATE TABLE t6(c1 REAL(1,0) NOT NULL);
143 CREATE UNIQUE INDEX i1 ON t6(c1);
147 SHOW CREATE TABLE t6;
149 t6 CREATE TABLE `t6` (
150 `c1` double(1,0) NOT NULL,
151 UNIQUE KEY `i1` (`c1`)
152 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
156 CREATE TABLE t7(c1 REAL(5,4) NOT NULL);
157 CREATE UNIQUE INDEX i1 ON t7(c1);
161 SHOW CREATE TABLE t7;
163 t7 CREATE TABLE `t7` (
164 `c1` double(5,4) NOT NULL,
165 UNIQUE KEY `i1` (`c1`)
166 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
170 CREATE TABLE t6(c1 DOUBLE(1,0) NOT NULL);
171 CREATE UNIQUE INDEX i1 ON t6(c1);
175 SHOW CREATE TABLE t6;
177 t6 CREATE TABLE `t6` (
178 `c1` double(1,0) NOT NULL,
179 UNIQUE KEY `i1` (`c1`)
180 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
184 CREATE TABLE t7(c1 DOUBLE(5,4) NOT NULL);
185 CREATE UNIQUE INDEX i1 ON t7(c1);
189 SHOW CREATE TABLE t7;
191 t7 CREATE TABLE `t7` (
192 `c1` double(5,4) NOT NULL,
193 UNIQUE KEY `i1` (`c1`)
194 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
198 CREATE TABLE t6(c1 FLOAT(1,0) NOT NULL);
199 CREATE UNIQUE INDEX i1 ON t6(c1);
203 SHOW CREATE TABLE t6;
205 t6 CREATE TABLE `t6` (
206 `c1` float(1,0) NOT NULL,
207 UNIQUE KEY `i1` (`c1`)
208 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
212 CREATE TABLE t7(c1 FLOAT(5,4) NOT NULL);
213 CREATE UNIQUE INDEX i1 ON t7(c1);
217 SHOW CREATE TABLE t7;
219 t7 CREATE TABLE `t7` (
220 `c1` float(5,4) NOT NULL,
221 UNIQUE KEY `i1` (`c1`)
222 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
226 CREATE TABLE t6(c1 DECIMAL(1,0) NOT NULL);
227 CREATE UNIQUE INDEX i1 ON t6(c1);
231 SHOW CREATE TABLE t6;
233 t6 CREATE TABLE `t6` (
234 `c1` decimal(1,0) NOT NULL,
235 UNIQUE KEY `i1` (`c1`)
236 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
240 CREATE TABLE t7(c1 DECIMAL(5,4) NOT NULL);
241 CREATE UNIQUE INDEX i1 ON t7(c1);
245 SHOW CREATE TABLE t7;
247 t7 CREATE TABLE `t7` (
248 `c1` decimal(5,4) NOT NULL,
249 UNIQUE KEY `i1` (`c1`)
250 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
254 CREATE TABLE t6(c1 NUMERIC(1,0) NOT NULL);
255 CREATE UNIQUE INDEX i1 ON t6(c1);
259 SHOW CREATE TABLE t6;
261 t6 CREATE TABLE `t6` (
262 `c1` decimal(1,0) NOT NULL,
263 UNIQUE KEY `i1` (`c1`)
264 ) ENGINE=ENGINE DEFAULT CHARSET=latin1
268 CREATE TABLE t7(c1 NUMERIC(5,4) NOT NULL);
269 CREATE UNIQUE INDEX i1 ON t7(c1);
273 SHOW CREATE TABLE t7;
275 t7 CREATE TABLE `t7` (
276 `c1` decimal(5,4) NOT NULL,
277 UNIQUE KEY `i1` (`c1`)
278 ) ENGINE=ENGINE DEFAULT CHARSET=latin1