Debian Codegraph @

mysql-test/suite/engines/funcs/r/ix_index_decimals.result

raw
1 DROP TABLE IF EXISTS t6,t7;
2 CREATE TABLE t6(c1 REAL(1,0) NULL);
3 Warnings:
4 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
5 CREATE INDEX i1 ON t6(c1);
6 SHOW TABLES;
7 Tables_in_test
8 t6
9 SHOW CREATE TABLE t6;
10 Table Create Table
11 t6 CREATE TABLE `t6` (
12 `c1` double(1,0) DEFAULT NULL,
13 KEY `i1` (`c1`)
14 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
15 DROP TABLE t6;
16 SHOW TABLES;
17 Tables_in_test
18 CREATE TABLE t7(c1 REAL(5,4) NULL);
19 Warnings:
20 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
21 CREATE INDEX i1 ON t7(c1);
22 SHOW TABLES;
23 Tables_in_test
24 t7
25 SHOW CREATE TABLE t7;
26 Table Create Table
27 t7 CREATE TABLE `t7` (
28 `c1` double(5,4) DEFAULT NULL,
29 KEY `i1` (`c1`)
30 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
31 DROP TABLE t7;
32 SHOW TABLES;
33 Tables_in_test
34 CREATE TABLE t6(c1 DOUBLE(1,0) NULL);
35 Warnings:
36 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
37 CREATE INDEX i1 ON t6(c1);
38 SHOW TABLES;
39 Tables_in_test
40 t6
41 SHOW CREATE TABLE t6;
42 Table Create Table
43 t6 CREATE TABLE `t6` (
44 `c1` double(1,0) DEFAULT NULL,
45 KEY `i1` (`c1`)
46 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
47 DROP TABLE t6;
48 SHOW TABLES;
49 Tables_in_test
50 CREATE TABLE t7(c1 DOUBLE(5,4) NULL);
51 Warnings:
52 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
53 CREATE INDEX i1 ON t7(c1);
54 SHOW TABLES;
55 Tables_in_test
56 t7
57 SHOW CREATE TABLE t7;
58 Table Create Table
59 t7 CREATE TABLE `t7` (
60 `c1` double(5,4) DEFAULT NULL,
61 KEY `i1` (`c1`)
62 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
63 DROP TABLE t7;
64 SHOW TABLES;
65 Tables_in_test
66 CREATE TABLE t6(c1 FLOAT(1,0) NULL);
67 Warnings:
68 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
69 CREATE INDEX i1 ON t6(c1);
70 SHOW TABLES;
71 Tables_in_test
72 t6
73 SHOW CREATE TABLE t6;
74 Table Create Table
75 t6 CREATE TABLE `t6` (
76 `c1` float(1,0) DEFAULT NULL,
77 KEY `i1` (`c1`)
78 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
79 DROP TABLE t6;
80 SHOW TABLES;
81 Tables_in_test
82 CREATE TABLE t7(c1 FLOAT(5,4) NULL);
83 Warnings:
84 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
85 CREATE INDEX i1 ON t7(c1);
86 SHOW TABLES;
87 Tables_in_test
88 t7
89 SHOW CREATE TABLE t7;
90 Table Create Table
91 t7 CREATE TABLE `t7` (
92 `c1` float(5,4) DEFAULT NULL,
93 KEY `i1` (`c1`)
94 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
95 DROP TABLE t7;
96 SHOW TABLES;
97 Tables_in_test
98 CREATE TABLE t6(c1 DECIMAL(1,0) NULL);
99 CREATE INDEX i1 ON t6(c1);
100 SHOW TABLES;
101 Tables_in_test
102 t6
103 SHOW CREATE TABLE t6;
104 Table Create Table
105 t6 CREATE TABLE `t6` (
106 `c1` decimal(1,0) DEFAULT NULL,
107 KEY `i1` (`c1`)
108 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
109 DROP TABLE t6;
110 SHOW TABLES;
111 Tables_in_test
112 CREATE TABLE t7(c1 DECIMAL(5,4) NULL);
113 CREATE INDEX i1 ON t7(c1);
114 SHOW TABLES;
115 Tables_in_test
116 t7
117 SHOW CREATE TABLE t7;
118 Table Create Table
119 t7 CREATE TABLE `t7` (
120 `c1` decimal(5,4) DEFAULT NULL,
121 KEY `i1` (`c1`)
122 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
123 DROP TABLE t7;
124 SHOW TABLES;
125 Tables_in_test
126 CREATE TABLE t6(c1 NUMERIC(1,0) NULL);
127 CREATE INDEX i1 ON t6(c1);
128 SHOW TABLES;
129 Tables_in_test
130 t6
131 SHOW CREATE TABLE t6;
132 Table Create Table
133 t6 CREATE TABLE `t6` (
134 `c1` decimal(1,0) DEFAULT NULL,
135 KEY `i1` (`c1`)
136 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
137 DROP TABLE t6;
138 SHOW TABLES;
139 Tables_in_test
140 CREATE TABLE t7(c1 NUMERIC(5,4) NULL);
141 CREATE INDEX i1 ON t7(c1);
142 SHOW TABLES;
143 Tables_in_test
144 t7
145 SHOW CREATE TABLE t7;
146 Table Create Table
147 t7 CREATE TABLE `t7` (
148 `c1` decimal(5,4) DEFAULT NULL,
149 KEY `i1` (`c1`)
150 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
151 DROP TABLE t7;
152 SHOW TABLES;
153 Tables_in_test
154 CREATE TABLE t6(c1 REAL(1,0) NOT NULL);
155 Warnings:
156 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
157 CREATE INDEX i1 ON t6(c1);
158 SHOW TABLES;
159 Tables_in_test
160 t6
161 SHOW CREATE TABLE t6;
162 Table Create Table
163 t6 CREATE TABLE `t6` (
164 `c1` double(1,0) NOT NULL,
165 KEY `i1` (`c1`)
166 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
167 DROP TABLE t6;
168 SHOW TABLES;
169 Tables_in_test
170 CREATE TABLE t7(c1 REAL(5,4) NOT NULL);
171 Warnings:
172 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
173 CREATE INDEX i1 ON t7(c1);
174 SHOW TABLES;
175 Tables_in_test
176 t7
177 SHOW CREATE TABLE t7;
178 Table Create Table
179 t7 CREATE TABLE `t7` (
180 `c1` double(5,4) NOT NULL,
181 KEY `i1` (`c1`)
182 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
183 DROP TABLE t7;
184 SHOW TABLES;
185 Tables_in_test
186 CREATE TABLE t6(c1 DOUBLE(1,0) NOT NULL);
187 Warnings:
188 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
189 CREATE INDEX i1 ON t6(c1);
190 SHOW TABLES;
191 Tables_in_test
192 t6
193 SHOW CREATE TABLE t6;
194 Table Create Table
195 t6 CREATE TABLE `t6` (
196 `c1` double(1,0) NOT NULL,
197 KEY `i1` (`c1`)
198 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
199 DROP TABLE t6;
200 SHOW TABLES;
201 Tables_in_test
202 CREATE TABLE t7(c1 DOUBLE(5,4) NOT NULL);
203 Warnings:
204 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
205 CREATE INDEX i1 ON t7(c1);
206 SHOW TABLES;
207 Tables_in_test
208 t7
209 SHOW CREATE TABLE t7;
210 Table Create Table
211 t7 CREATE TABLE `t7` (
212 `c1` double(5,4) NOT NULL,
213 KEY `i1` (`c1`)
214 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
215 DROP TABLE t7;
216 SHOW TABLES;
217 Tables_in_test
218 CREATE TABLE t6(c1 FLOAT(1,0) NOT NULL);
219 Warnings:
220 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
221 CREATE INDEX i1 ON t6(c1);
222 SHOW TABLES;
223 Tables_in_test
224 t6
225 SHOW CREATE TABLE t6;
226 Table Create Table
227 t6 CREATE TABLE `t6` (
228 `c1` float(1,0) NOT NULL,
229 KEY `i1` (`c1`)
230 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
231 DROP TABLE t6;
232 SHOW TABLES;
233 Tables_in_test
234 CREATE TABLE t7(c1 FLOAT(5,4) NOT NULL);
235 Warnings:
236 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
237 CREATE INDEX i1 ON t7(c1);
238 SHOW TABLES;
239 Tables_in_test
240 t7
241 SHOW CREATE TABLE t7;
242 Table Create Table
243 t7 CREATE TABLE `t7` (
244 `c1` float(5,4) NOT NULL,
245 KEY `i1` (`c1`)
246 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
247 DROP TABLE t7;
248 SHOW TABLES;
249 Tables_in_test
250 CREATE TABLE t6(c1 DECIMAL(1,0) NOT NULL);
251 CREATE INDEX i1 ON t6(c1);
252 SHOW TABLES;
253 Tables_in_test
254 t6
255 SHOW CREATE TABLE t6;
256 Table Create Table
257 t6 CREATE TABLE `t6` (
258 `c1` decimal(1,0) NOT NULL,
259 KEY `i1` (`c1`)
260 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
261 DROP TABLE t6;
262 SHOW TABLES;
263 Tables_in_test
264 CREATE TABLE t7(c1 DECIMAL(5,4) NOT NULL);
265 CREATE INDEX i1 ON t7(c1);
266 SHOW TABLES;
267 Tables_in_test
268 t7
269 SHOW CREATE TABLE t7;
270 Table Create Table
271 t7 CREATE TABLE `t7` (
272 `c1` decimal(5,4) NOT NULL,
273 KEY `i1` (`c1`)
274 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
275 DROP TABLE t7;
276 SHOW TABLES;
277 Tables_in_test
278 CREATE TABLE t6(c1 NUMERIC(1,0) NOT NULL);
279 CREATE INDEX i1 ON t6(c1);
280 SHOW TABLES;
281 Tables_in_test
282 t6
283 SHOW CREATE TABLE t6;
284 Table Create Table
285 t6 CREATE TABLE `t6` (
286 `c1` decimal(1,0) NOT NULL,
287 KEY `i1` (`c1`)
288 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
289 DROP TABLE t6;
290 SHOW TABLES;
291 Tables_in_test
292 CREATE TABLE t7(c1 NUMERIC(5,4) NOT NULL);
293 CREATE INDEX i1 ON t7(c1);
294 SHOW TABLES;
295 Tables_in_test
296 t7
297 SHOW CREATE TABLE t7;
298 Table Create Table
299 t7 CREATE TABLE `t7` (
300 `c1` decimal(5,4) NOT NULL,
301 KEY `i1` (`c1`)
302 ) ENGINE=ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
303 DROP TABLE t7;
304 SHOW TABLES;
305 Tables_in_test