Debian Codegraph @

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

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