Debian Codegraph @

mysql-test/suite/engines/iuds/r/insert_decimal.result

raw
1 DROP TABLE IF EXISTS t1,t2;
2 SET sql_mode='NO_ENGINE_SUBSTITUTION';
3 CREATE TABLE t1(c1 DECIMAL(10,5) UNSIGNED NOT NULL, c2 DECIMAL(10,5) SIGNED NULL, c3 DECIMAL, c4 INT, UNIQUE INDEX idx(c1,c2));
4 Warnings:
5 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
6 CREATE TABLE t2(c1 DECIMAL(10,0) SIGNED NOT NULL, c2 DECIMAL(10) UNSIGNED NULL, c3 DECIMAL, c4 INT);
7 Warnings:
8 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
9 INSERT INTO t1 VALUES('00100.05000','-00100.05000','00100.05000',1);
10 Warnings:
11 Note 1265 Data truncated for column 'c3' at row 1
12 INSERT INTO t2 VALUES('-1000000000','1000000000','1000000000',2);
13 INSERT INTO t1(c1) VALUES('12345.000009');
14 Warnings:
15 Note 1265 Data truncated for column 'c1' at row 1
16 INSERT INTO t1 VALUES('99999.99999','-99999.99999','99999.99999',3);
17 Warnings:
18 Note 1265 Data truncated for column 'c3' at row 1
19 INSERT INTO t2 VALUES('-9999999999','-9999999999','9999999999',4);
20 Warnings:
21 Warning 1264 Out of range value for column 'c2' at row 1
22 SELECT * FROM t1;
23 c1 c2 c3 c4
24 100.05000 -100.05000 100 1
25 12345.00001 NULL NULL NULL
26 99999.99999 -99999.99999 100000 3
27 INSERT INTO t1 VALUES('100000.000002','-100000.000002','100000.000002',5);
28 ERROR 23000: Duplicate entry '99999.99999--99999.99999' for key 't1.idx'
29 DELETE FROM t1 WHERE c1='99999.99999' AND c2='-99999.99999';
30 SELECT * FROM t1;
31 c1 c2 c3 c4
32 100.05000 -100.05000 100 1
33 12345.00001 NULL NULL NULL
34 INSERT INTO t1 VALUES('100000.000002','-100000.000002','100000.000002',5);
35 Warnings:
36 Warning 1264 Out of range value for column 'c1' at row 1
37 Warning 1264 Out of range value for column 'c2' at row 1
38 Note 1265 Data truncated for column 'c3' at row 1
39 INSERT INTO t2 VALUES('10000000000','-10000000000','10000000000',6);
40 Warnings:
41 Warning 1264 Out of range value for column 'c1' at row 1
42 Warning 1264 Out of range value for column 'c2' at row 1
43 Warning 1264 Out of range value for column 'c3' at row 1
44 insert into t1 values ("0.0","0.0","0.0",7),("01.0","01.0","01.0",10);
45 insert into t1 values ("-.1","-.1","-.1",13);
46 Warnings:
47 Warning 1264 Out of range value for column 'c1' at row 1
48 Note 1265 Data truncated for column 'c3' at row 1
49 insert into t1 values ("+111111111.11","+111111111.11","+111111111.11",19);
50 Warnings:
51 Warning 1264 Out of range value for column 'c1' at row 1
52 Warning 1264 Out of range value for column 'c2' at row 1
53 Note 1265 Data truncated for column 'c3' at row 1
54 insert into t2 values ("0.0","0.0","0.0",7),("-0.0","-0.0","-0.0",8),("+0.0","+0.0","+0.0",9),("01.0","01.0","01.0",10),("+01.0","+01.0","+01.0",11),("-01.0","-01.0","-01.0",12);
55 Warnings:
56 Warning 1264 Out of range value for column 'c2' at row 6
57 insert into t2 values ("-.1","-.1","-.1",13),("+.1","+.1","+.1",14),(".1",".1",".1",15);
58 Warnings:
59 Note 1265 Data truncated for column 'c1' at row 1
60 Warning 1264 Out of range value for column 'c2' at row 1
61 Note 1265 Data truncated for column 'c3' at row 1
62 Note 1265 Data truncated for column 'c1' at row 2
63 Note 1265 Data truncated for column 'c2' at row 2
64 Note 1265 Data truncated for column 'c3' at row 2
65 Note 1265 Data truncated for column 'c1' at row 3
66 Note 1265 Data truncated for column 'c2' at row 3
67 Note 1265 Data truncated for column 'c3' at row 3
68 insert into t2 values ("00000000000001","00000000000001","00000000000001",16),("+0000000000001","+0000000000001","+0000000000001",17),("-0000000000001","-0000000000001","-0000000000001",18);
69 Warnings:
70 Warning 1264 Out of range value for column 'c2' at row 3
71 insert into t2 values ("+111111111.11","+111111111.11","+111111111.11",19),("111111111.11","111111111.11","111111111.11",20),("-11111111.11","-11111111.11","-11111111.11",21);
72 Warnings:
73 Note 1265 Data truncated for column 'c1' at row 1
74 Note 1265 Data truncated for column 'c2' at row 1
75 Note 1265 Data truncated for column 'c3' at row 1
76 Note 1265 Data truncated for column 'c1' at row 2
77 Note 1265 Data truncated for column 'c2' at row 2
78 Note 1265 Data truncated for column 'c3' at row 2
79 Note 1265 Data truncated for column 'c1' at row 3
80 Warning 1264 Out of range value for column 'c2' at row 3
81 Note 1265 Data truncated for column 'c3' at row 3
82 insert into t2 values ("-111111111.11","-111111111.11","-111111111.11",22),("+1111111111.11","+1111111111.11","+1111111111.11",23),("1111111111.11","1111111111.11","1111111111.11",24);
83 Warnings:
84 Note 1265 Data truncated for column 'c1' at row 1
85 Warning 1264 Out of range value for column 'c2' at row 1
86 Note 1265 Data truncated for column 'c3' at row 1
87 Note 1265 Data truncated for column 'c1' at row 2
88 Note 1265 Data truncated for column 'c2' at row 2
89 Note 1265 Data truncated for column 'c3' at row 2
90 Note 1265 Data truncated for column 'c1' at row 3
91 Note 1265 Data truncated for column 'c2' at row 3
92 Note 1265 Data truncated for column 'c3' at row 3
93 insert into t2 values ("1e+1000","1e+1000","1e+1000",25),("1e-1000","1e-1000","1e-1000",26),("-1e+1000","-1e+1000","-1e+1000",27);
94 Warnings:
95 Warning 1264 Out of range value for column 'c1' at row 1
96 Warning 1264 Out of range value for column 'c2' at row 1
97 Warning 1264 Out of range value for column 'c3' at row 1
98 Note 1265 Data truncated for column 'c1' at row 2
99 Note 1265 Data truncated for column 'c2' at row 2
100 Note 1265 Data truncated for column 'c3' at row 2
101 Warning 1264 Out of range value for column 'c1' at row 3
102 Warning 1264 Out of range value for column 'c2' at row 3
103 Warning 1264 Out of range value for column 'c3' at row 3
104 insert into t2 values ("1e+4294967296","1e+4294967296","1e+4294967296",28),("1e-4294967296","1e-4294967296","1e-4294967296",29);
105 Warnings:
106 Warning 1264 Out of range value for column 'c1' at row 1
107 Warning 1264 Out of range value for column 'c2' at row 1
108 Warning 1264 Out of range value for column 'c3' at row 1
109 Note 1265 Data truncated for column 'c1' at row 2
110 Note 1265 Data truncated for column 'c2' at row 2
111 Note 1265 Data truncated for column 'c3' at row 2
112 insert into t2 values ("1e+18446744073709551615","1e+18446744073709551615","1e+18446744073709551615",30),("1e+18446744073709551616","1e+18446744073709551616","1e+18446744073709551616",31),("1e-9223372036854775807","1e-9223372036854775807","1e-9223372036854775807",32),("1e-9223372036854775809","1e-9223372036854775809","1e-9223372036854775809",33);
113 Warnings:
114 Warning 1264 Out of range value for column 'c1' at row 1
115 Warning 1264 Out of range value for column 'c2' at row 1
116 Warning 1264 Out of range value for column 'c3' at row 1
117 Warning 1366 Incorrect decimal value: '1e+18446744073709551616' for column 'c1' at row 2
118 Warning 1366 Incorrect decimal value: '1e+18446744073709551616' for column 'c2' at row 2
119 Warning 1366 Incorrect decimal value: '1e+18446744073709551616' for column 'c3' at row 2
120 Note 1265 Data truncated for column 'c1' at row 3
121 Note 1265 Data truncated for column 'c2' at row 3
122 Note 1265 Data truncated for column 'c3' at row 3
123 Warning 1366 Incorrect decimal value: '1e-9223372036854775809' for column 'c1' at row 4
124 Warning 1366 Incorrect decimal value: '1e-9223372036854775809' for column 'c2' at row 4
125 Warning 1366 Incorrect decimal value: '1e-9223372036854775809' for column 'c3' at row 4
126 SELECT * FROM t1;
127 c1 c2 c3 c4
128 0.00000 -0.10000 0 13
129 0.00000 0.00000 0 7
130 1.00000 1.00000 1 10
131 100.05000 -100.05000 100 1
132 12345.00001 NULL NULL NULL
133 99999.99999 -99999.99999 100000 5
134 99999.99999 99999.99999 111111111 19
135 SELECT * FROM t2;
136 c1 c2 c3 c4
137 -1 0 -1 12
138 -1 0 -1 18
139 -1000000000 1000000000 1000000000 2
140 -11111111 0 -11111111 21
141 -111111111 0 -111111111 22
142 -9999999999 0 -9999999999 27
143 -9999999999 0 9999999999 4
144 0 0 0 13
145 0 0 0 14
146 0 0 0 15
147 0 0 0 26
148 0 0 0 29
149 0 0 0 31
150 0 0 0 32
151 0 0 0 33
152 0 0 0 7
153 0 0 0 8
154 0 0 0 9
155 1 1 1 10
156 1 1 1 11
157 1 1 1 16
158 1 1 1 17
159 111111111 111111111 111111111 19
160 111111111 111111111 111111111 20
161 1111111111 1111111111 1111111111 23
162 1111111111 1111111111 1111111111 24
163 9999999999 0 9999999999 6
164 9999999999 9999999999 9999999999 25
165 9999999999 9999999999 9999999999 28
166 9999999999 9999999999 9999999999 30
167 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) as max_value, sum(c1) as sum, avg(c1) as avg FROM t1;
168 total_rows min_value max_value sum avg
169 7 0.00000 99999.99999 212446.04999 30349.435712857
170 SELECT count(*) as total_rows, min(c2) as min_value, max(c2) as max_value, sum(c2) as sum, avg(c2) as avg FROM t1;
171 total_rows min_value max_value sum avg
172 7 -99999.99999 99999.99999 -99.15000 -16.525000000
173 SELECT count(*) as total_rows, min(c3) as min_value, max(c3) as max_value, sum(c3) as sum, avg(c3) as avg FROM t1;
174 total_rows min_value max_value sum avg
175 7 0 111111111 111211212 18535202.0000
176 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) as max_value, sum(c1) as sum, avg(c1) as avg FROM t2;
177 total_rows min_value max_value sum avg
178 30 -9999999999 9999999999 21322222222 710740740.7333
179 SELECT count(*) as total_rows, min(c2) as min_value, max(c2) as max_value, sum(c2) as sum, avg(c2) as avg FROM t2;
180 total_rows min_value max_value sum avg
181 30 0 9999999999 33444444445 1114814814.8333
182 SELECT count(*) as total_rows, min(c3) as min_value, max(c3) as max_value, sum(c3) as sum, avg(c3) as avg FROM t2;
183 total_rows min_value max_value sum avg
184 30 -9999999999 9999999999 43322222220 1444074074.0000
185 SELECT * FROM t1;
186 c1 c2 c3 c4
187 0.00000 -0.10000 0 13
188 0.00000 0.00000 0 7
189 1.00000 1.00000 1 10
190 100.05000 -100.05000 100 1
191 12345.00001 NULL NULL NULL
192 99999.99999 -99999.99999 100000 5
193 99999.99999 99999.99999 111111111 19
194 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) FROM t1;
195 total_rows min_value max(c1)
196 7 0.00000 99999.99999
197 SELECT * FROM t1 WHERE c3 = '0.0';
198 c1 c2 c3 c4
199 0.00000 -0.10000 0 13
200 0.00000 0.00000 0 7
201 SELECT c1,c2 FROM t1;
202 c1 c2
203 0.00000 -0.10000
204 0.00000 0.00000
205 1.00000 1.00000
206 100.05000 -100.05000
207 12345.00001 NULL
208 99999.99999 -99999.99999
209 99999.99999 99999.99999
210 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
211 c1 c2
212 0.00000 0.00000
213 0.00000 -0.10000
214 1.00000 1.00000
215 100.05000 -100.05000
216 12345.00001 NULL
217 99999.99999 99999.99999
218 99999.99999 -99999.99999
219 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
220 c1 c2 c3 c4
221 0.00000 -0.10000 0 13
222 0.00000 0.00000 0 7
223 SELECT * FROM t1 ORDER BY c1,c2 DESC LIMIT 2;
224 c1 c2 c3 c4
225 0.00000 0.00000 0 7
226 0.00000 -0.10000 0 13
227 SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2;
228 c1 c2 c3 c4
229 0.00000 -0.10000 0 13
230 0.00000 0.00000 0 7
231 SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2 LIMIT 2;
232 c1 c2 c3 c4
233 0.00000 -0.10000 0 13
234 0.00000 0.00000 0 7
235 SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2 DESC;
236 c1 c2 c3 c4
237 0.00000 0.00000 0 7
238 0.00000 -0.10000 0 13
239 SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2 DESC LIMIT 2;
240 c1 c2 c3 c4
241 0.00000 0.00000 0 7
242 0.00000 -0.10000 0 13
243 SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2;
244 c1 c2 c3 c4
245 1.00000 1.00000 1 10
246 100.05000 -100.05000 100 1
247 12345.00001 NULL NULL NULL
248 99999.99999 -99999.99999 100000 5
249 99999.99999 99999.99999 111111111 19
250 SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2 LIMIT 2;
251 c1 c2 c3 c4
252 1.00000 1.00000 1 10
253 100.05000 -100.05000 100 1
254 SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2;
255 c1 c2 c3 c4
256 1.00000 1.00000 1 10
257 100.05000 -100.05000 100 1
258 12345.00001 NULL NULL NULL
259 99999.99999 -99999.99999 100000 5
260 99999.99999 99999.99999 111111111 19
261 SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2 LIMIT 2;
262 c1 c2 c3 c4
263 1.00000 1.00000 1 10
264 100.05000 -100.05000 100 1
265 SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2;
266 c1 c2 c3 c4
267 0.00000 -0.10000 0 13
268 0.00000 0.00000 0 7
269 1.00000 1.00000 1 10
270 100.05000 -100.05000 100 1
271 12345.00001 NULL NULL NULL
272 99999.99999 -99999.99999 100000 5
273 99999.99999 99999.99999 111111111 19
274 SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2 LIMIT 2;
275 c1 c2 c3 c4
276 0.00000 -0.10000 0 13
277 0.00000 0.00000 0 7
278 SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2;
279 c1 c2 c3 c4
280 SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2 LIMIT 2;
281 c1 c2 c3 c4
282 SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2;
283 c1 c2 c3 c4
284 0.00000 -0.10000 0 13
285 0.00000 0.00000 0 7
286 SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2 LIMIT 2;
287 c1 c2 c3 c4
288 0.00000 -0.10000 0 13
289 0.00000 0.00000 0 7
290 SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2;
291 c1 c2 c3 c4
292 0.00000 -0.10000 0 13
293 0.00000 0.00000 0 7
294 SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2 LIMIT 2;
295 c1 c2 c3 c4
296 0.00000 -0.10000 0 13
297 0.00000 0.00000 0 7
298 SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2;
299 c1 c2 c3 c4
300 0.00000 -0.10000 0 13
301 0.00000 0.00000 0 7
302 1.00000 1.00000 1 10
303 100.05000 -100.05000 100 1
304 12345.00001 NULL NULL NULL
305 99999.99999 -99999.99999 100000 5
306 99999.99999 99999.99999 111111111 19
307 SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2 LIMIT 2;
308 c1 c2 c3 c4
309 0.00000 -0.10000 0 13
310 0.00000 0.00000 0 7
311 SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2;
312 c1 c2 c3 c4
313 0.00000 -0.10000 0 13
314 0.00000 0.00000 0 7
315 99999.99999 -99999.99999 100000 5
316 99999.99999 99999.99999 111111111 19
317 SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2 LIMIT 2;
318 c1 c2 c3 c4
319 0.00000 -0.10000 0 13
320 0.00000 0.00000 0 7
321 SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2;
322 c1 c2 c3 c4
323 1.00000 1.00000 1 10
324 SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2 LIMIT 2;
325 c1 c2 c3 c4
326 1.00000 1.00000 1 10
327 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2;
328 c1 c2 c3 c4
329 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 LIMIT 2;
330 c1 c2 c3 c4
331 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2;
332 c1 c2 c3 c4
333 0.00000 -0.10000 0 13
334 0.00000 0.00000 0 7
335 1.00000 1.00000 1 10
336 100.05000 -100.05000 100 1
337 12345.00001 NULL NULL NULL
338 99999.99999 -99999.99999 100000 5
339 99999.99999 99999.99999 111111111 19
340 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 LIMIT 2;
341 c1 c2 c3 c4
342 0.00000 -0.10000 0 13
343 0.00000 0.00000 0 7
344 SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2 DESC;
345 c1 c2 c3 c4
346 1.00000 1.00000 1 10
347 100.05000 -100.05000 100 1
348 12345.00001 NULL NULL NULL
349 99999.99999 99999.99999 111111111 19
350 99999.99999 -99999.99999 100000 5
351 SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2 DESC LIMIT 2;
352 c1 c2 c3 c4
353 1.00000 1.00000 1 10
354 100.05000 -100.05000 100 1
355 SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2 DESC;
356 c1 c2 c3 c4
357 1.00000 1.00000 1 10
358 100.05000 -100.05000 100 1
359 12345.00001 NULL NULL NULL
360 99999.99999 99999.99999 111111111 19
361 99999.99999 -99999.99999 100000 5
362 SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2 DESC LIMIT 2;
363 c1 c2 c3 c4
364 1.00000 1.00000 1 10
365 100.05000 -100.05000 100 1
366 SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2 DESC;
367 c1 c2 c3 c4
368 0.00000 0.00000 0 7
369 0.00000 -0.10000 0 13
370 1.00000 1.00000 1 10
371 100.05000 -100.05000 100 1
372 12345.00001 NULL NULL NULL
373 99999.99999 99999.99999 111111111 19
374 99999.99999 -99999.99999 100000 5
375 SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2 DESC LIMIT 2;
376 c1 c2 c3 c4
377 0.00000 0.00000 0 7
378 0.00000 -0.10000 0 13
379 SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2 DESC;
380 c1 c2 c3 c4
381 SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2 DESC LIMIT 2;
382 c1 c2 c3 c4
383 SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2 DESC;
384 c1 c2 c3 c4
385 0.00000 0.00000 0 7
386 0.00000 -0.10000 0 13
387 SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2 DESC LIMIT 2;
388 c1 c2 c3 c4
389 0.00000 0.00000 0 7
390 0.00000 -0.10000 0 13
391 SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2 DESC;
392 c1 c2 c3 c4
393 0.00000 0.00000 0 7
394 0.00000 -0.10000 0 13
395 SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2 DESC LIMIT 2;
396 c1 c2 c3 c4
397 0.00000 0.00000 0 7
398 0.00000 -0.10000 0 13
399 SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2 DESC;
400 c1 c2 c3 c4
401 0.00000 0.00000 0 7
402 0.00000 -0.10000 0 13
403 1.00000 1.00000 1 10
404 100.05000 -100.05000 100 1
405 12345.00001 NULL NULL NULL
406 99999.99999 99999.99999 111111111 19
407 99999.99999 -99999.99999 100000 5
408 SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
409 c1 c2 c3 c4
410 0.00000 0.00000 0 7
411 0.00000 -0.10000 0 13
412 SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2 DESC;
413 c1 c2 c3 c4
414 0.00000 0.00000 0 7
415 0.00000 -0.10000 0 13
416 99999.99999 99999.99999 111111111 19
417 99999.99999 -99999.99999 100000 5
418 SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2 DESC LIMIT 2;
419 c1 c2 c3 c4
420 0.00000 0.00000 0 7
421 0.00000 -0.10000 0 13
422 SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2 DESC;
423 c1 c2 c3 c4
424 1.00000 1.00000 1 10
425 SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2 DESC LIMIT 2;
426 c1 c2 c3 c4
427 1.00000 1.00000 1 10
428 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC;
429 c1 c2 c3 c4
430 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC LIMIT 2;
431 c1 c2 c3 c4
432 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC;
433 c1 c2 c3 c4
434 0.00000 0.00000 0 7
435 0.00000 -0.10000 0 13
436 1.00000 1.00000 1 10
437 100.05000 -100.05000 100 1
438 12345.00001 NULL NULL NULL
439 99999.99999 99999.99999 111111111 19
440 99999.99999 -99999.99999 100000 5
441 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC LIMIT 2;
442 c1 c2 c3 c4
443 0.00000 0.00000 0 7
444 0.00000 -0.10000 0 13
445 SELECT * FROM t1;
446 c1 c2 c3 c4
447 0.00000 -0.10000 0 13
448 0.00000 0.00000 0 7
449 1.00000 1.00000 1 10
450 100.05000 -100.05000 100 1
451 12345.00001 NULL NULL NULL
452 99999.99999 -99999.99999 100000 5
453 99999.99999 99999.99999 111111111 19
454 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) FROM t1;
455 total_rows min_value max(c1)
456 7 0.00000 99999.99999
457 SELECT * FROM t1 WHERE c3 = '-0.0';
458 c1 c2 c3 c4
459 0.00000 -0.10000 0 13
460 0.00000 0.00000 0 7
461 SELECT c1,c2 FROM t1;
462 c1 c2
463 0.00000 -0.10000
464 0.00000 0.00000
465 1.00000 1.00000
466 100.05000 -100.05000
467 12345.00001 NULL
468 99999.99999 -99999.99999
469 99999.99999 99999.99999
470 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
471 c1 c2
472 0.00000 0.00000
473 0.00000 -0.10000
474 1.00000 1.00000
475 100.05000 -100.05000
476 12345.00001 NULL
477 99999.99999 99999.99999
478 99999.99999 -99999.99999
479 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
480 c1 c2 c3 c4
481 0.00000 -0.10000 0 13
482 0.00000 0.00000 0 7
483 SELECT * FROM t1 ORDER BY c1,c2 DESC LIMIT 2;
484 c1 c2 c3 c4
485 0.00000 0.00000 0 7
486 0.00000 -0.10000 0 13
487 SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2;
488 c1 c2 c3 c4
489 99999.99999 -99999.99999 100000 5
490 99999.99999 99999.99999 111111111 19
491 SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2 LIMIT 2;
492 c1 c2 c3 c4
493 99999.99999 -99999.99999 100000 5
494 99999.99999 99999.99999 111111111 19
495 SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2 DESC;
496 c1 c2 c3 c4
497 99999.99999 99999.99999 111111111 19
498 99999.99999 -99999.99999 100000 5
499 SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
500 c1 c2 c3 c4
501 99999.99999 99999.99999 111111111 19
502 99999.99999 -99999.99999 100000 5
503 SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2;
504 c1 c2 c3 c4
505 0.00000 -0.10000 0 13
506 0.00000 0.00000 0 7
507 1.00000 1.00000 1 10
508 100.05000 -100.05000 100 1
509 12345.00001 NULL NULL NULL
510 SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2 LIMIT 2;
511 c1 c2 c3 c4
512 0.00000 -0.10000 0 13
513 0.00000 0.00000 0 7
514 SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2;
515 c1 c2 c3 c4
516 SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2 LIMIT 2;
517 c1 c2 c3 c4
518 SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2;
519 c1 c2 c3 c4
520 99999.99999 -99999.99999 100000 5
521 99999.99999 99999.99999 111111111 19
522 SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2 LIMIT 2;
523 c1 c2 c3 c4
524 99999.99999 -99999.99999 100000 5
525 99999.99999 99999.99999 111111111 19
526 SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2;
527 c1 c2 c3 c4
528 0.00000 -0.10000 0 13
529 0.00000 0.00000 0 7
530 1.00000 1.00000 1 10
531 100.05000 -100.05000 100 1
532 12345.00001 NULL NULL NULL
533 SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2 LIMIT 2;
534 c1 c2 c3 c4
535 0.00000 -0.10000 0 13
536 0.00000 0.00000 0 7
537 SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2;
538 c1 c2 c3 c4
539 0.00000 -0.10000 0 13
540 0.00000 0.00000 0 7
541 1.00000 1.00000 1 10
542 100.05000 -100.05000 100 1
543 12345.00001 NULL NULL NULL
544 99999.99999 -99999.99999 100000 5
545 99999.99999 99999.99999 111111111 19
546 SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2 LIMIT 2;
547 c1 c2 c3 c4
548 0.00000 -0.10000 0 13
549 0.00000 0.00000 0 7
550 SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2;
551 c1 c2 c3 c4
552 99999.99999 -99999.99999 100000 5
553 99999.99999 99999.99999 111111111 19
554 SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2 LIMIT 2;
555 c1 c2 c3 c4
556 99999.99999 -99999.99999 100000 5
557 99999.99999 99999.99999 111111111 19
558 SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2;
559 c1 c2 c3 c4
560 100.05000 -100.05000 100 1
561 12345.00001 NULL NULL NULL
562 99999.99999 -99999.99999 100000 5
563 99999.99999 99999.99999 111111111 19
564 SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2 LIMIT 2;
565 c1 c2 c3 c4
566 100.05000 -100.05000 100 1
567 12345.00001 NULL NULL NULL
568 SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2;
569 c1 c2 c3 c4
570 100.05000 -100.05000 100 1
571 99999.99999 -99999.99999 100000 5
572 99999.99999 99999.99999 111111111 19
573 SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2 LIMIT 2;
574 c1 c2 c3 c4
575 100.05000 -100.05000 100 1
576 99999.99999 -99999.99999 100000 5
577 SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2;
578 c1 c2 c3 c4
579 SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2 LIMIT 2;
580 c1 c2 c3 c4
581 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2;
582 c1 c2 c3 c4
583 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 LIMIT 2;
584 c1 c2 c3 c4
585 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2;
586 c1 c2 c3 c4
587 0.00000 -0.10000 0 13
588 0.00000 0.00000 0 7
589 1.00000 1.00000 1 10
590 100.05000 -100.05000 100 1
591 12345.00001 NULL NULL NULL
592 99999.99999 -99999.99999 100000 5
593 99999.99999 99999.99999 111111111 19
594 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 LIMIT 2;
595 c1 c2 c3 c4
596 0.00000 -0.10000 0 13
597 0.00000 0.00000 0 7
598 SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2 DESC;
599 c1 c2 c3 c4
600 0.00000 0.00000 0 7
601 0.00000 -0.10000 0 13
602 1.00000 1.00000 1 10
603 100.05000 -100.05000 100 1
604 12345.00001 NULL NULL NULL
605 SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
606 c1 c2 c3 c4
607 0.00000 0.00000 0 7
608 0.00000 -0.10000 0 13
609 SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2 DESC;
610 c1 c2 c3 c4
611 SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
612 c1 c2 c3 c4
613 SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2 DESC;
614 c1 c2 c3 c4
615 99999.99999 99999.99999 111111111 19
616 99999.99999 -99999.99999 100000 5
617 SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
618 c1 c2 c3 c4
619 99999.99999 99999.99999 111111111 19
620 99999.99999 -99999.99999 100000 5
621 SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2 DESC;
622 c1 c2 c3 c4
623 0.00000 0.00000 0 7
624 0.00000 -0.10000 0 13
625 1.00000 1.00000 1 10
626 100.05000 -100.05000 100 1
627 12345.00001 NULL NULL NULL
628 SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
629 c1 c2 c3 c4
630 0.00000 0.00000 0 7
631 0.00000 -0.10000 0 13
632 SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2 DESC;
633 c1 c2 c3 c4
634 0.00000 0.00000 0 7
635 0.00000 -0.10000 0 13
636 1.00000 1.00000 1 10
637 100.05000 -100.05000 100 1
638 12345.00001 NULL NULL NULL
639 99999.99999 99999.99999 111111111 19
640 99999.99999 -99999.99999 100000 5
641 SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
642 c1 c2 c3 c4
643 0.00000 0.00000 0 7
644 0.00000 -0.10000 0 13
645 SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2 DESC;
646 c1 c2 c3 c4
647 99999.99999 99999.99999 111111111 19
648 99999.99999 -99999.99999 100000 5
649 SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
650 c1 c2 c3 c4
651 99999.99999 99999.99999 111111111 19
652 99999.99999 -99999.99999 100000 5
653 SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2 DESC;
654 c1 c2 c3 c4
655 100.05000 -100.05000 100 1
656 12345.00001 NULL NULL NULL
657 99999.99999 99999.99999 111111111 19
658 99999.99999 -99999.99999 100000 5
659 SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
660 c1 c2 c3 c4
661 100.05000 -100.05000 100 1
662 12345.00001 NULL NULL NULL
663 SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2 DESC;
664 c1 c2 c3 c4
665 100.05000 -100.05000 100 1
666 99999.99999 99999.99999 111111111 19
667 99999.99999 -99999.99999 100000 5
668 SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2 DESC LIMIT 2;
669 c1 c2 c3 c4
670 100.05000 -100.05000 100 1
671 99999.99999 99999.99999 111111111 19
672 SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2 DESC;
673 c1 c2 c3 c4
674 SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
675 c1 c2 c3 c4
676 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC;
677 c1 c2 c3 c4
678 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC LIMIT 2;
679 c1 c2 c3 c4
680 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC;
681 c1 c2 c3 c4
682 0.00000 0.00000 0 7
683 0.00000 -0.10000 0 13
684 1.00000 1.00000 1 10
685 100.05000 -100.05000 100 1
686 12345.00001 NULL NULL NULL
687 99999.99999 99999.99999 111111111 19
688 99999.99999 -99999.99999 100000 5
689 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC LIMIT 2;
690 c1 c2 c3 c4
691 0.00000 0.00000 0 7
692 0.00000 -0.10000 0 13
693 SELECT * FROM t1;
694 c1 c2 c3 c4
695 0.00000 -0.10000 0 13
696 0.00000 0.00000 0 7
697 1.00000 1.00000 1 10
698 100.05000 -100.05000 100 1
699 12345.00001 NULL NULL NULL
700 99999.99999 -99999.99999 100000 5
701 99999.99999 99999.99999 111111111 19
702 SELECT count(*) as total_rows, min(c2) as min_value, max(c2) FROM t1;
703 total_rows min_value max(c2)
704 7 -99999.99999 99999.99999
705 SELECT * FROM t1 WHERE c3 = '-0.0';
706 c1 c2 c3 c4
707 0.00000 -0.10000 0 13
708 0.00000 0.00000 0 7
709 SELECT c1,c2 FROM t1;
710 c1 c2
711 0.00000 -0.10000
712 0.00000 0.00000
713 1.00000 1.00000
714 100.05000 -100.05000
715 12345.00001 NULL
716 99999.99999 -99999.99999
717 99999.99999 99999.99999
718 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
719 c1 c2
720 0.00000 0.00000
721 0.00000 -0.10000
722 1.00000 1.00000
723 100.05000 -100.05000
724 12345.00001 NULL
725 99999.99999 99999.99999
726 99999.99999 -99999.99999
727 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
728 c1 c2 c3 c4
729 0.00000 -0.10000 0 13
730 0.00000 0.00000 0 7
731 SELECT * FROM t1 ORDER BY c1,c2 DESC LIMIT 2;
732 c1 c2 c3 c4
733 0.00000 0.00000 0 7
734 0.00000 -0.10000 0 13
735 SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2;
736 c1 c2 c3 c4
737 99999.99999 -99999.99999 100000 5
738 SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2 LIMIT 2;
739 c1 c2 c3 c4
740 99999.99999 -99999.99999 100000 5
741 SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2 DESC;
742 c1 c2 c3 c4
743 99999.99999 -99999.99999 100000 5
744 SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
745 c1 c2 c3 c4
746 99999.99999 -99999.99999 100000 5
747 SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2;
748 c1 c2 c3 c4
749 0.00000 -0.10000 0 13
750 0.00000 0.00000 0 7
751 1.00000 1.00000 1 10
752 100.05000 -100.05000 100 1
753 99999.99999 99999.99999 111111111 19
754 SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2 LIMIT 2;
755 c1 c2 c3 c4
756 0.00000 -0.10000 0 13
757 0.00000 0.00000 0 7
758 SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2;
759 c1 c2 c3 c4
760 0.00000 -0.10000 0 13
761 0.00000 0.00000 0 7
762 1.00000 1.00000 1 10
763 100.05000 -100.05000 100 1
764 99999.99999 99999.99999 111111111 19
765 SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2 LIMIT 2;
766 c1 c2 c3 c4
767 0.00000 -0.10000 0 13
768 0.00000 0.00000 0 7
769 SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2;
770 c1 c2 c3 c4
771 0.00000 -0.10000 0 13
772 0.00000 0.00000 0 7
773 1.00000 1.00000 1 10
774 100.05000 -100.05000 100 1
775 99999.99999 -99999.99999 100000 5
776 99999.99999 99999.99999 111111111 19
777 SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2 LIMIT 2;
778 c1 c2 c3 c4
779 0.00000 -0.10000 0 13
780 0.00000 0.00000 0 7
781 SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2;
782 c1 c2 c3 c4
783 SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2 LIMIT 2;
784 c1 c2 c3 c4
785 SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2;
786 c1 c2 c3 c4
787 99999.99999 -99999.99999 100000 5
788 SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2 LIMIT 2;
789 c1 c2 c3 c4
790 99999.99999 -99999.99999 100000 5
791 SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2;
792 c1 c2 c3 c4
793 99999.99999 -99999.99999 100000 5
794 SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2 LIMIT 2;
795 c1 c2 c3 c4
796 99999.99999 -99999.99999 100000 5
797 SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2;
798 c1 c2 c3 c4
799 0.00000 -0.10000 0 13
800 0.00000 0.00000 0 7
801 100.05000 -100.05000 100 1
802 99999.99999 -99999.99999 100000 5
803 SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2 LIMIT 2;
804 c1 c2 c3 c4
805 0.00000 -0.10000 0 13
806 0.00000 0.00000 0 7
807 SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2;
808 c1 c2 c3 c4
809 0.00000 0.00000 0 7
810 99999.99999 -99999.99999 100000 5
811 SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2 LIMIT 2;
812 c1 c2 c3 c4
813 0.00000 0.00000 0 7
814 99999.99999 -99999.99999 100000 5
815 SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2;
816 c1 c2 c3 c4
817 99999.99999 -99999.99999 100000 5
818 SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2 LIMIT 2;
819 c1 c2 c3 c4
820 99999.99999 -99999.99999 100000 5
821 SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2;
822 c1 c2 c3 c4
823 12345.00001 NULL NULL NULL
824 SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2 LIMIT 2;
825 c1 c2 c3 c4
826 12345.00001 NULL NULL NULL
827 SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2;
828 c1 c2 c3 c4
829 0.00000 -0.10000 0 13
830 0.00000 0.00000 0 7
831 1.00000 1.00000 1 10
832 100.05000 -100.05000 100 1
833 99999.99999 -99999.99999 100000 5
834 99999.99999 99999.99999 111111111 19
835 SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2 LIMIT 2;
836 c1 c2 c3 c4
837 0.00000 -0.10000 0 13
838 0.00000 0.00000 0 7
839 SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2 DESC;
840 c1 c2 c3 c4
841 0.00000 0.00000 0 7
842 0.00000 -0.10000 0 13
843 1.00000 1.00000 1 10
844 100.05000 -100.05000 100 1
845 99999.99999 99999.99999 111111111 19
846 SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
847 c1 c2 c3 c4
848 0.00000 0.00000 0 7
849 0.00000 -0.10000 0 13
850 SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2 DESC;
851 c1 c2 c3 c4
852 0.00000 0.00000 0 7
853 0.00000 -0.10000 0 13
854 1.00000 1.00000 1 10
855 100.05000 -100.05000 100 1
856 99999.99999 99999.99999 111111111 19
857 SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
858 c1 c2 c3 c4
859 0.00000 0.00000 0 7
860 0.00000 -0.10000 0 13
861 SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2 DESC;
862 c1 c2 c3 c4
863 0.00000 0.00000 0 7
864 0.00000 -0.10000 0 13
865 1.00000 1.00000 1 10
866 100.05000 -100.05000 100 1
867 99999.99999 99999.99999 111111111 19
868 99999.99999 -99999.99999 100000 5
869 SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
870 c1 c2 c3 c4
871 0.00000 0.00000 0 7
872 0.00000 -0.10000 0 13
873 SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2 DESC;
874 c1 c2 c3 c4
875 SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
876 c1 c2 c3 c4
877 SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2 DESC;
878 c1 c2 c3 c4
879 99999.99999 -99999.99999 100000 5
880 SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
881 c1 c2 c3 c4
882 99999.99999 -99999.99999 100000 5
883 SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2 DESC;
884 c1 c2 c3 c4
885 99999.99999 -99999.99999 100000 5
886 SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
887 c1 c2 c3 c4
888 99999.99999 -99999.99999 100000 5
889 SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2 DESC;
890 c1 c2 c3 c4
891 0.00000 0.00000 0 7
892 0.00000 -0.10000 0 13
893 100.05000 -100.05000 100 1
894 99999.99999 -99999.99999 100000 5
895 SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2 DESC LIMIT 2;
896 c1 c2 c3 c4
897 0.00000 0.00000 0 7
898 0.00000 -0.10000 0 13
899 SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2 DESC;
900 c1 c2 c3 c4
901 0.00000 0.00000 0 7
902 99999.99999 -99999.99999 100000 5
903 SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2 DESC LIMIT 2;
904 c1 c2 c3 c4
905 0.00000 0.00000 0 7
906 99999.99999 -99999.99999 100000 5
907 SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2 DESC;
908 c1 c2 c3 c4
909 99999.99999 -99999.99999 100000 5
910 SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
911 c1 c2 c3 c4
912 99999.99999 -99999.99999 100000 5
913 SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2 DESC;
914 c1 c2 c3 c4
915 12345.00001 NULL NULL NULL
916 SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2 DESC LIMIT 2;
917 c1 c2 c3 c4
918 12345.00001 NULL NULL NULL
919 SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2 DESC;
920 c1 c2 c3 c4
921 0.00000 0.00000 0 7
922 0.00000 -0.10000 0 13
923 1.00000 1.00000 1 10
924 100.05000 -100.05000 100 1
925 99999.99999 99999.99999 111111111 19
926 99999.99999 -99999.99999 100000 5
927 SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2 DESC LIMIT 2;
928 c1 c2 c3 c4
929 0.00000 0.00000 0 7
930 0.00000 -0.10000 0 13
931 SELECT c1 FROM t1 GROUP BY c1;
932 c1
933 0.00000
934 1.00000
935 100.05000
936 12345.00001
937 99999.99999
938 SELECT DISTINCT c1 FROM t1;
939 c1
940 0.00000
941 1.00000
942 100.05000
943 12345.00001
944 99999.99999
945 SELECT c1,MIN(c2) FROM t1 GROUP BY c1;
946 c1 MIN(c2)
947 0.00000 -0.10000
948 1.00000 1.00000
949 100.05000 -100.05000
950 12345.00001 NULL
951 99999.99999 -99999.99999
952 CREATE TABLE t5(c1 DECIMAL(65,0) UNSIGNED NOT NULL, c2 DECIMAL(65,0) SIGNED NULL, c3 DECIMAL, c4 INT, INDEX idx(c1,c2));
953 Warnings:
954 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
955 INSERT INTO t5 VALUES('1e+64','-1e+64','1e+64',1),('1e-64','-1e-64','1e-64',2);
956 Warnings:
957 Warning 1264 Out of range value for column 'c3' at row 1
958 Note 1265 Data truncated for column 'c1' at row 2
959 Note 1265 Data truncated for column 'c2' at row 2
960 Note 1265 Data truncated for column 'c3' at row 2
961 INSERT INTO t5 VALUES('1.2e+65','-1.2e+65','1.2e+65',3),('1.2e-65','-1.2e-65','1.2e-65',4);
962 Warnings:
963 Warning 1264 Out of range value for column 'c1' at row 1
964 Warning 1264 Out of range value for column 'c2' at row 1
965 Warning 1264 Out of range value for column 'c3' at row 1
966 Note 1265 Data truncated for column 'c1' at row 2
967 Note 1265 Data truncated for column 'c2' at row 2
968 Note 1265 Data truncated for column 'c3' at row 2
969 SELECT * FROM t5;
970 c1 c2 c3 c4
971 0 0 0 2
972 0 0 0 4
973 10000000000000000000000000000000000000000000000000000000000000000 -10000000000000000000000000000000000000000000000000000000000000000 9999999999 1
974 99999999999999999999999999999999999999999999999999999999999999999 -99999999999999999999999999999999999999999999999999999999999999999 9999999999 3
975 DROP TABLE t5;
976 CREATE TABLE t5(c1 DECIMAL(18,9) UNSIGNED, c2 DECIMAL(18,9) SIGNED) /* requires 8 bytes */;
977 Warnings:
978 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
979 INSERT INTO t5 VALUES(123456789.123456789,-123456789.123456789);
980 SELECT c1,c2 FROM t5;
981 c1 c2
982 123456789.123456789 -123456789.123456789
983 ALTER TABLE t5 CHANGE c1 c1 DECIMAL(19,9) UNSIGNED, CHANGE c2 c2 DECIMAL(19,9) SIGNED /* requires 9 bytes */;
984 Warnings:
985 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
986 INSERT INTO t5 VALUES(1234567891.123456789,-1234567891.123456789);
987 SELECT c1,c2 FROM t5;
988 c1 c2
989 123456789.123456789 -123456789.123456789
990 1234567891.123456789 -1234567891.123456789
991 ALTER TABLE t5 CHANGE c1 c1 DECIMAL(21,10) UNSIGNED, CHANGE c2 c2 DECIMAL(21,10) SIGNED /* requires 10 bytes */;
992 Warnings:
993 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
994 INSERT INTO t5 VALUES(12345678912.1234567891,-12345678912.1234567891);
995 SELECT c1,c2 FROM t5;
996 c1 c2
997 123456789.1234567890 -123456789.1234567890
998 1234567891.1234567890 -1234567891.1234567890
999 12345678912.1234567891 -12345678912.1234567891
1000 ALTER TABLE t5 CHANGE c1 c1 DECIMAL(23,11) UNSIGNED, CHANGE c2 c2 DECIMAL(23,11) SIGNED /* requires 11 bytes */;
1001 Warnings:
1002 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1003 INSERT INTO t5 VALUES(123456789123.12345678912,-123456789123.12345678912);
1004 SELECT c1,c2 FROM t5;
1005 c1 c2
1006 123456789.12345678900 -123456789.12345678900
1007 1234567891.12345678900 -1234567891.12345678900
1008 12345678912.12345678910 -12345678912.12345678910
1009 123456789123.12345678912 -123456789123.12345678912
1010 ALTER TABLE t5 CHANGE c1 c1 DECIMAL(25,12) UNSIGNED, CHANGE c2 c2 DECIMAL(25,12) SIGNED /* requires 12 bytes */;
1011 Warnings:
1012 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1013 INSERT INTO t5 VALUES(1234567891234.123456789123,-1234567891234.123456789123);
1014 SELECT c1,c2 FROM t5;
1015 c1 c2
1016 123456789.123456789000 -123456789.123456789000
1017 1234567891.123456789000 -1234567891.123456789000
1018 12345678912.123456789100 -12345678912.123456789100
1019 123456789123.123456789120 -123456789123.123456789120
1020 1234567891234.123456789123 -1234567891234.123456789123
1021 SELECT SUM(c1),SUM(c2) FROM t5;
1022 SUM(c1) SUM(c2)
1023 1371728383949.617283945343 -1371728383949.617283945343
1024 DROP TABLE t5;
1025 CREATE TABLE t5(c1 DECIMAL(16,6), c2 tinyint);
1026 INSERT INTO t5 VALUES(1.1325,3);
1027 SELECT ROUND(c1,c2),TRUNCATE(c1,c2) FROM t5;
1028 ROUND(c1,c2) TRUNCATE(c1,c2)
1029 1.133000 1.132000
1030 DROP TABLE t5;
1031 CREATE TABLE t7(c1 DECIMAL(66,0));
1032 ERROR 42000: Too-big precision 66 specified for 'c1'. Maximum is 65.
1033 CREATE TABLE t7(c1 DECIMAL(5,10));
1034 ERROR 42000: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'c1').
1035 DROP TABLE t1,t2;
1036 CREATE TABLE t1(c1 FLOAT(10,5) UNSIGNED NOT NULL, c2 FLOAT(10,5) SIGNED NULL, c3 FLOAT, c4 INT, UNIQUE INDEX idx(c1,c2));
1037 Warnings:
1038 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
1039 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1040 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
1041 CREATE TABLE t2(c1 FLOAT(10,0) SIGNED NOT NULL, c2 FLOAT(10,0) UNSIGNED NULL, c3 FLOAT, c4 INT);
1042 Warnings:
1043 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
1044 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
1045 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1046 INSERT INTO t1 VALUES('00100.05000','-00100.05000','00100.05000',1);
1047 INSERT INTO t2 VALUES('-1000000000','1000000000','1000000000',2);
1048 INSERT INTO t1(c1) VALUES('12345.000009');
1049 INSERT INTO t1 VALUES('99999.99999','-99999.99999','99999.99999',3);
1050 INSERT INTO t2 VALUES('-9999999999','-9999999999','9999999999',4);
1051 Warnings:
1052 Warning 1264 Out of range value for column 'c2' at row 1
1053 SELECT * FROM t1;
1054 c1 c2 c3 c4
1055 100.05000 -100.05000 100.05 1
1056 12345.00000 NULL NULL NULL
1057 100000.00000 -100000.00000 100000 3
1058 INSERT INTO t1 VALUES('100000.000002','-100000.000002','100000.000002',5);
1059 ERROR 23000: Duplicate entry '100000.00000--100000.00000' for key 't1.idx'
1060 DELETE FROM t1 WHERE c1>'99999' AND c2<'-99999';
1061 INSERT INTO t1 VALUES('100000.000002','-100000.000002','100000.000002',5);
1062 Warnings:
1063 Warning 1264 Out of range value for column 'c1' at row 1
1064 Warning 1264 Out of range value for column 'c2' at row 1
1065 INSERT INTO t2 VALUES('10000000000','-10000000000','10000000000',6);
1066 Warnings:
1067 Warning 1264 Out of range value for column 'c1' at row 1
1068 Warning 1264 Out of range value for column 'c2' at row 1
1069 insert into t1 values ("0.0","0.0","0.0",7),("01.0","01.0","01.0",10);
1070 insert into t1 values ("-.1","-.1","-.1",13);
1071 Warnings:
1072 Warning 1264 Out of range value for column 'c1' at row 1
1073 insert into t1 values ("+111111111.11","+111111111.11","+111111111.11",19);
1074 Warnings:
1075 Warning 1264 Out of range value for column 'c1' at row 1
1076 Warning 1264 Out of range value for column 'c2' at row 1
1077 insert into t2 values ("0.0","0.0","0.0",7),("-0.0","-0.0","-0.0",8),("+0.0","+0.0","+0.0",9),("01.0","01.0","01.0",10),("+01.0","+01.0","+01.0",11),("-01.0","-01.0","-01.0",12);
1078 Warnings:
1079 Warning 1264 Out of range value for column 'c2' at row 6
1080 insert into t2 values ("-.1","-.1","-.1",13),("+.1","+.1","+.1",14),(".1",".1",".1",15);
1081 Warnings:
1082 Warning 1264 Out of range value for column 'c2' at row 1
1083 insert into t2 values ("00000000000001","00000000000001","00000000000001",16),("+0000000000001","+0000000000001","+0000000000001",17),("-0000000000001","-0000000000001","-0000000000001",18);
1084 Warnings:
1085 Warning 1264 Out of range value for column 'c2' at row 3
1086 insert into t2 values ("+111111111.11","+111111111.11","+111111111.11",19),("111111111.11","111111111.11","111111111.11",20),("-11111111.11","-11111111.11","-11111111.11",21);
1087 Warnings:
1088 Warning 1264 Out of range value for column 'c2' at row 3
1089 insert into t2 values ("-111111111.11","-111111111.11","-111111111.11",22),("+1111111111.11","+1111111111.11","+1111111111.11",23),("1111111111.11","1111111111.11","1111111111.11",24);
1090 Warnings:
1091 Warning 1264 Out of range value for column 'c2' at row 1
1092 insert into t2 values ("1e+1000","1e+1000","1e+1000",25),("1e-1000","1e-1000","1e-1000",26),("-1e+1000","-1e+1000","-1e+1000",27);
1093 Warnings:
1094 Warning 1264 Out of range value for column 'c1' at row 1
1095 Warning 1264 Out of range value for column 'c1' at row 1
1096 Warning 1264 Out of range value for column 'c2' at row 1
1097 Warning 1264 Out of range value for column 'c2' at row 1
1098 Warning 1264 Out of range value for column 'c3' at row 1
1099 Warning 1264 Out of range value for column 'c3' at row 1
1100 Warning 1264 Out of range value for column 'c1' at row 3
1101 Warning 1264 Out of range value for column 'c1' at row 3
1102 Warning 1264 Out of range value for column 'c2' at row 3
1103 Warning 1264 Out of range value for column 'c2' at row 3
1104 Warning 1264 Out of range value for column 'c3' at row 3
1105 Warning 1264 Out of range value for column 'c3' at row 3
1106 insert into t2 values ("1e+4294967296","1e+4294967296","1e+4294967296",28),("1e-4294967296","1e-4294967296","1e-4294967296",29);
1107 Warnings:
1108 Warning 1264 Out of range value for column 'c1' at row 1
1109 Warning 1264 Out of range value for column 'c1' at row 1
1110 Warning 1264 Out of range value for column 'c2' at row 1
1111 Warning 1264 Out of range value for column 'c2' at row 1
1112 Warning 1264 Out of range value for column 'c3' at row 1
1113 Warning 1264 Out of range value for column 'c3' at row 1
1114 Warning 1265 Data truncated for column 'c1' at row 2
1115 Warning 1265 Data truncated for column 'c2' at row 2
1116 Warning 1265 Data truncated for column 'c3' at row 2
1117 insert into t2 values ("1e+18446744073709551615","1e+18446744073709551615","1e+18446744073709551615",30),("1e+18446744073709551616","1e+18446744073709551616","1e+18446744073709551616",31),("1e-9223372036854775807","1e-9223372036854775807","1e-9223372036854775807",32),("1e-9223372036854775809","1e-9223372036854775809","1e-9223372036854775809",33);
1118 Warnings:
1119 Warning 1264 Out of range value for column 'c1' at row 1
1120 Warning 1264 Out of range value for column 'c1' at row 1
1121 Warning 1264 Out of range value for column 'c2' at row 1
1122 Warning 1264 Out of range value for column 'c2' at row 1
1123 Warning 1264 Out of range value for column 'c3' at row 1
1124 Warning 1264 Out of range value for column 'c3' at row 1
1125 Warning 1264 Out of range value for column 'c1' at row 2
1126 Warning 1264 Out of range value for column 'c1' at row 2
1127 Warning 1264 Out of range value for column 'c2' at row 2
1128 Warning 1264 Out of range value for column 'c2' at row 2
1129 Warning 1264 Out of range value for column 'c3' at row 2
1130 Warning 1264 Out of range value for column 'c3' at row 2
1131 Warning 1265 Data truncated for column 'c1' at row 3
1132 Warning 1265 Data truncated for column 'c2' at row 3
1133 Warning 1265 Data truncated for column 'c3' at row 3
1134 Warning 1265 Data truncated for column 'c1' at row 4
1135 Warning 1265 Data truncated for column 'c2' at row 4
1136 Warning 1265 Data truncated for column 'c3' at row 4
1137 SELECT * FROM t1;
1138 c1 c2 c3 c4
1139 0.00000 -0.10000 -0.1 13
1140 0.00000 0.00000 0 7
1141 1.00000 1.00000 1 10
1142 100.05000 -100.05000 100.05 1
1143 100000.00000 -100000.00000 100000 5
1144 100000.00000 100000.00000 111111000 19
1145 12345.00000 NULL NULL NULL
1146 SELECT * FROM t2;
1147 c1 c2 c3 c4
1148 -1 0 -1 12
1149 -1 0 -1 18
1150 -1000000000 1000000000 1000000000 2
1151 -10000000000 0 -3.40282e38 27
1152 -10000000000 0 10000000000 4
1153 -11111111 0 -11111100 21
1154 -111111112 0 -111111000 22
1155 0 0 -0 8
1156 0 0 -0.1 13
1157 0 0 0 26
1158 0 0 0 29
1159 0 0 0 32
1160 0 0 0 33
1161 0 0 0 7
1162 0 0 0 9
1163 0 0 0.1 14
1164 0 0 0.1 15
1165 1 1 1 10
1166 1 1 1 11
1167 1 1 1 16
1168 1 1 1 17
1169 10000000000 0 10000000000 6
1170 10000000000 10000000000 3.40282e38 25
1171 10000000000 10000000000 3.40282e38 28
1172 10000000000 10000000000 3.40282e38 30
1173 10000000000 10000000000 3.40282e38 31
1174 111111112 111111112 111111000 19
1175 111111112 111111112 111111000 20
1176 1111111168 1111111168 1111110000 23
1177 1111111168 1111111168 1111110000 24
1178 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) as max_value, sum(c1) as sum, avg(c1) as avg FROM t1;
1179 total_rows min_value max_value sum avg
1180 7 0.00000 100000.00000 212446.05000 30349.435714722
1181 SELECT count(*) as total_rows, min(c2) as min_value, max(c2) as max_value, sum(c2) as sum, avg(c2) as avg FROM t1;
1182 total_rows min_value max_value sum avg
1183 7 -100000.00000 100000.00000 -99.15000 -16.525000509
1184 SELECT count(*) as total_rows, min(c3) as min_value, max(c3) as max_value, sum(c3) as sum, avg(c3) as avg FROM t1;
1185 total_rows min_value max_value sum avg
1186 7 -0.1 111111000 111211212.95000306 18535202.15833384
1187 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) as max_value, sum(c1) as sum, avg(c1) as avg FROM t2;
1188 total_rows min_value max_value sum avg
1189 30 -10000000000 10000000000 31322222339 1044074077.9667
1190 SELECT count(*) as total_rows, min(c2) as min_value, max(c2) as max_value, sum(c2) as sum, avg(c2) as avg FROM t2;
1191 total_rows min_value max_value sum avg
1192 30 0 10000000000 43444444564 1448148152.1333
1193 SELECT count(*) as total_rows, min(c3) as min_value, max(c3) as max_value, sum(c3) as sum, avg(c3) as avg FROM t2;
1194 total_rows min_value max_value sum avg
1195 30 -3.40282e38 3.40282e38 1.0208470399155866e39 3.4028234663852886e37
1196 SELECT * FROM t1;
1197 c1 c2 c3 c4
1198 0.00000 -0.10000 -0.1 13
1199 0.00000 0.00000 0 7
1200 1.00000 1.00000 1 10
1201 100.05000 -100.05000 100.05 1
1202 100000.00000 -100000.00000 100000 5
1203 100000.00000 100000.00000 111111000 19
1204 12345.00000 NULL NULL NULL
1205 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) FROM t1;
1206 total_rows min_value max(c1)
1207 7 0.00000 100000.00000
1208 SELECT * FROM t1 WHERE c3 = '0.0';
1209 c1 c2 c3 c4
1210 0.00000 0.00000 0 7
1211 SELECT c1,c2 FROM t1;
1212 c1 c2
1213 0.00000 -0.10000
1214 0.00000 0.00000
1215 1.00000 1.00000
1216 100.05000 -100.05000
1217 100000.00000 -100000.00000
1218 100000.00000 100000.00000
1219 12345.00000 NULL
1220 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
1221 c1 c2
1222 0.00000 0.00000
1223 0.00000 -0.10000
1224 1.00000 1.00000
1225 100.05000 -100.05000
1226 12345.00000 NULL
1227 100000.00000 100000.00000
1228 100000.00000 -100000.00000
1229 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
1230 c1 c2 c3 c4
1231 0.00000 -0.10000 -0.1 13
1232 0.00000 0.00000 0 7
1233 SELECT * FROM t1 ORDER BY c1,c2 DESC LIMIT 2;
1234 c1 c2 c3 c4
1235 0.00000 0.00000 0 7
1236 0.00000 -0.10000 -0.1 13
1237 SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2;
1238 c1 c2 c3 c4
1239 0.00000 -0.10000 -0.1 13
1240 0.00000 0.00000 0 7
1241 SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2 LIMIT 2;
1242 c1 c2 c3 c4
1243 0.00000 -0.10000 -0.1 13
1244 0.00000 0.00000 0 7
1245 SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2 DESC;
1246 c1 c2 c3 c4
1247 0.00000 0.00000 0 7
1248 0.00000 -0.10000 -0.1 13
1249 SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2 DESC LIMIT 2;
1250 c1 c2 c3 c4
1251 0.00000 0.00000 0 7
1252 0.00000 -0.10000 -0.1 13
1253 SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2;
1254 c1 c2 c3 c4
1255 1.00000 1.00000 1 10
1256 100.05000 -100.05000 100.05 1
1257 12345.00000 NULL NULL NULL
1258 100000.00000 -100000.00000 100000 5
1259 100000.00000 100000.00000 111111000 19
1260 SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2 LIMIT 2;
1261 c1 c2 c3 c4
1262 1.00000 1.00000 1 10
1263 100.05000 -100.05000 100.05 1
1264 SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2;
1265 c1 c2 c3 c4
1266 1.00000 1.00000 1 10
1267 100.05000 -100.05000 100.05 1
1268 12345.00000 NULL NULL NULL
1269 100000.00000 -100000.00000 100000 5
1270 100000.00000 100000.00000 111111000 19
1271 SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2 LIMIT 2;
1272 c1 c2 c3 c4
1273 1.00000 1.00000 1 10
1274 100.05000 -100.05000 100.05 1
1275 SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2;
1276 c1 c2 c3 c4
1277 0.00000 -0.10000 -0.1 13
1278 0.00000 0.00000 0 7
1279 1.00000 1.00000 1 10
1280 100.05000 -100.05000 100.05 1
1281 12345.00000 NULL NULL NULL
1282 100000.00000 -100000.00000 100000 5
1283 100000.00000 100000.00000 111111000 19
1284 SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2 LIMIT 2;
1285 c1 c2 c3 c4
1286 0.00000 -0.10000 -0.1 13
1287 0.00000 0.00000 0 7
1288 SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2;
1289 c1 c2 c3 c4
1290 SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2 LIMIT 2;
1291 c1 c2 c3 c4
1292 SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2;
1293 c1 c2 c3 c4
1294 0.00000 -0.10000 -0.1 13
1295 0.00000 0.00000 0 7
1296 SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2 LIMIT 2;
1297 c1 c2 c3 c4
1298 0.00000 -0.10000 -0.1 13
1299 0.00000 0.00000 0 7
1300 SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2;
1301 c1 c2 c3 c4
1302 0.00000 -0.10000 -0.1 13
1303 0.00000 0.00000 0 7
1304 SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2 LIMIT 2;
1305 c1 c2 c3 c4
1306 0.00000 -0.10000 -0.1 13
1307 0.00000 0.00000 0 7
1308 SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2;
1309 c1 c2 c3 c4
1310 0.00000 -0.10000 -0.1 13
1311 0.00000 0.00000 0 7
1312 1.00000 1.00000 1 10
1313 100.05000 -100.05000 100.05 1
1314 12345.00000 NULL NULL NULL
1315 SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2 LIMIT 2;
1316 c1 c2 c3 c4
1317 0.00000 -0.10000 -0.1 13
1318 0.00000 0.00000 0 7
1319 SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2;
1320 c1 c2 c3 c4
1321 0.00000 -0.10000 -0.1 13
1322 0.00000 0.00000 0 7
1323 SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2 LIMIT 2;
1324 c1 c2 c3 c4
1325 0.00000 -0.10000 -0.1 13
1326 0.00000 0.00000 0 7
1327 SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2;
1328 c1 c2 c3 c4
1329 1.00000 1.00000 1 10
1330 SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2 LIMIT 2;
1331 c1 c2 c3 c4
1332 1.00000 1.00000 1 10
1333 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2;
1334 c1 c2 c3 c4
1335 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 LIMIT 2;
1336 c1 c2 c3 c4
1337 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2;
1338 c1 c2 c3 c4
1339 0.00000 -0.10000 -0.1 13
1340 0.00000 0.00000 0 7
1341 1.00000 1.00000 1 10
1342 100.05000 -100.05000 100.05 1
1343 12345.00000 NULL NULL NULL
1344 100000.00000 -100000.00000 100000 5
1345 100000.00000 100000.00000 111111000 19
1346 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 LIMIT 2;
1347 c1 c2 c3 c4
1348 0.00000 -0.10000 -0.1 13
1349 0.00000 0.00000 0 7
1350 SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2 DESC;
1351 c1 c2 c3 c4
1352 1.00000 1.00000 1 10
1353 100.05000 -100.05000 100.05 1
1354 12345.00000 NULL NULL NULL
1355 100000.00000 100000.00000 111111000 19
1356 100000.00000 -100000.00000 100000 5
1357 SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2 DESC LIMIT 2;
1358 c1 c2 c3 c4
1359 1.00000 1.00000 1 10
1360 100.05000 -100.05000 100.05 1
1361 SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2 DESC;
1362 c1 c2 c3 c4
1363 1.00000 1.00000 1 10
1364 100.05000 -100.05000 100.05 1
1365 12345.00000 NULL NULL NULL
1366 100000.00000 100000.00000 111111000 19
1367 100000.00000 -100000.00000 100000 5
1368 SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2 DESC LIMIT 2;
1369 c1 c2 c3 c4
1370 1.00000 1.00000 1 10
1371 100.05000 -100.05000 100.05 1
1372 SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2 DESC;
1373 c1 c2 c3 c4
1374 0.00000 0.00000 0 7
1375 0.00000 -0.10000 -0.1 13
1376 1.00000 1.00000 1 10
1377 100.05000 -100.05000 100.05 1
1378 12345.00000 NULL NULL NULL
1379 100000.00000 100000.00000 111111000 19
1380 100000.00000 -100000.00000 100000 5
1381 SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2 DESC LIMIT 2;
1382 c1 c2 c3 c4
1383 0.00000 0.00000 0 7
1384 0.00000 -0.10000 -0.1 13
1385 SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2 DESC;
1386 c1 c2 c3 c4
1387 SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2 DESC LIMIT 2;
1388 c1 c2 c3 c4
1389 SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2 DESC;
1390 c1 c2 c3 c4
1391 0.00000 0.00000 0 7
1392 0.00000 -0.10000 -0.1 13
1393 SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2 DESC LIMIT 2;
1394 c1 c2 c3 c4
1395 0.00000 0.00000 0 7
1396 0.00000 -0.10000 -0.1 13
1397 SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2 DESC;
1398 c1 c2 c3 c4
1399 0.00000 0.00000 0 7
1400 0.00000 -0.10000 -0.1 13
1401 SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2 DESC LIMIT 2;
1402 c1 c2 c3 c4
1403 0.00000 0.00000 0 7
1404 0.00000 -0.10000 -0.1 13
1405 SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2 DESC;
1406 c1 c2 c3 c4
1407 0.00000 0.00000 0 7
1408 0.00000 -0.10000 -0.1 13
1409 1.00000 1.00000 1 10
1410 100.05000 -100.05000 100.05 1
1411 12345.00000 NULL NULL NULL
1412 SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
1413 c1 c2 c3 c4
1414 0.00000 0.00000 0 7
1415 0.00000 -0.10000 -0.1 13
1416 SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2 DESC;
1417 c1 c2 c3 c4
1418 0.00000 0.00000 0 7
1419 0.00000 -0.10000 -0.1 13
1420 SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2 DESC LIMIT 2;
1421 c1 c2 c3 c4
1422 0.00000 0.00000 0 7
1423 0.00000 -0.10000 -0.1 13
1424 SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2 DESC;
1425 c1 c2 c3 c4
1426 1.00000 1.00000 1 10
1427 SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2 DESC LIMIT 2;
1428 c1 c2 c3 c4
1429 1.00000 1.00000 1 10
1430 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC;
1431 c1 c2 c3 c4
1432 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC LIMIT 2;
1433 c1 c2 c3 c4
1434 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC;
1435 c1 c2 c3 c4
1436 0.00000 0.00000 0 7
1437 0.00000 -0.10000 -0.1 13
1438 1.00000 1.00000 1 10
1439 100.05000 -100.05000 100.05 1
1440 12345.00000 NULL NULL NULL
1441 100000.00000 100000.00000 111111000 19
1442 100000.00000 -100000.00000 100000 5
1443 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC LIMIT 2;
1444 c1 c2 c3 c4
1445 0.00000 0.00000 0 7
1446 0.00000 -0.10000 -0.1 13
1447 SELECT * FROM t1;
1448 c1 c2 c3 c4
1449 0.00000 -0.10000 -0.1 13
1450 0.00000 0.00000 0 7
1451 1.00000 1.00000 1 10
1452 100.05000 -100.05000 100.05 1
1453 100000.00000 -100000.00000 100000 5
1454 100000.00000 100000.00000 111111000 19
1455 12345.00000 NULL NULL NULL
1456 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) FROM t1;
1457 total_rows min_value max(c1)
1458 7 0.00000 100000.00000
1459 SELECT * FROM t1 WHERE c3 = '-0.0';
1460 c1 c2 c3 c4
1461 0.00000 0.00000 0 7
1462 SELECT c1,c2 FROM t1;
1463 c1 c2
1464 0.00000 -0.10000
1465 0.00000 0.00000
1466 1.00000 1.00000
1467 100.05000 -100.05000
1468 100000.00000 -100000.00000
1469 100000.00000 100000.00000
1470 12345.00000 NULL
1471 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
1472 c1 c2
1473 0.00000 0.00000
1474 0.00000 -0.10000
1475 1.00000 1.00000
1476 100.05000 -100.05000
1477 12345.00000 NULL
1478 100000.00000 100000.00000
1479 100000.00000 -100000.00000
1480 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
1481 c1 c2 c3 c4
1482 0.00000 -0.10000 -0.1 13
1483 0.00000 0.00000 0 7
1484 SELECT * FROM t1 ORDER BY c1,c2 DESC LIMIT 2;
1485 c1 c2 c3 c4
1486 0.00000 0.00000 0 7
1487 0.00000 -0.10000 -0.1 13
1488 SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2;
1489 c1 c2 c3 c4
1490 SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2 LIMIT 2;
1491 c1 c2 c3 c4
1492 SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2 DESC;
1493 c1 c2 c3 c4
1494 SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
1495 c1 c2 c3 c4
1496 SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2;
1497 c1 c2 c3 c4
1498 0.00000 -0.10000 -0.1 13
1499 0.00000 0.00000 0 7
1500 1.00000 1.00000 1 10
1501 100.05000 -100.05000 100.05 1
1502 12345.00000 NULL NULL NULL
1503 SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2 LIMIT 2;
1504 c1 c2 c3 c4
1505 0.00000 -0.10000 -0.1 13
1506 0.00000 0.00000 0 7
1507 SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2;
1508 c1 c2 c3 c4
1509 SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2 LIMIT 2;
1510 c1 c2 c3 c4
1511 SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2;
1512 c1 c2 c3 c4
1513 SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2 LIMIT 2;
1514 c1 c2 c3 c4
1515 SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2;
1516 c1 c2 c3 c4
1517 0.00000 -0.10000 -0.1 13
1518 0.00000 0.00000 0 7
1519 1.00000 1.00000 1 10
1520 100.05000 -100.05000 100.05 1
1521 12345.00000 NULL NULL NULL
1522 SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2 LIMIT 2;
1523 c1 c2 c3 c4
1524 0.00000 -0.10000 -0.1 13
1525 0.00000 0.00000 0 7
1526 SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2;
1527 c1 c2 c3 c4
1528 0.00000 -0.10000 -0.1 13
1529 0.00000 0.00000 0 7
1530 1.00000 1.00000 1 10
1531 100.05000 -100.05000 100.05 1
1532 12345.00000 NULL NULL NULL
1533 100000.00000 -100000.00000 100000 5
1534 100000.00000 100000.00000 111111000 19
1535 SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2 LIMIT 2;
1536 c1 c2 c3 c4
1537 0.00000 -0.10000 -0.1 13
1538 0.00000 0.00000 0 7
1539 SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2;
1540 c1 c2 c3 c4
1541 SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2 LIMIT 2;
1542 c1 c2 c3 c4
1543 SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2;
1544 c1 c2 c3 c4
1545 100.05000 -100.05000 100.05 1
1546 12345.00000 NULL NULL NULL
1547 SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2 LIMIT 2;
1548 c1 c2 c3 c4
1549 100.05000 -100.05000 100.05 1
1550 12345.00000 NULL NULL NULL
1551 SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2;
1552 c1 c2 c3 c4
1553 SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2 LIMIT 2;
1554 c1 c2 c3 c4
1555 SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2;
1556 c1 c2 c3 c4
1557 SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2 LIMIT 2;
1558 c1 c2 c3 c4
1559 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2;
1560 c1 c2 c3 c4
1561 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 LIMIT 2;
1562 c1 c2 c3 c4
1563 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2;
1564 c1 c2 c3 c4
1565 0.00000 -0.10000 -0.1 13
1566 0.00000 0.00000 0 7
1567 1.00000 1.00000 1 10
1568 100.05000 -100.05000 100.05 1
1569 12345.00000 NULL NULL NULL
1570 100000.00000 -100000.00000 100000 5
1571 100000.00000 100000.00000 111111000 19
1572 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 LIMIT 2;
1573 c1 c2 c3 c4
1574 0.00000 -0.10000 -0.1 13
1575 0.00000 0.00000 0 7
1576 SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2 DESC;
1577 c1 c2 c3 c4
1578 0.00000 0.00000 0 7
1579 0.00000 -0.10000 -0.1 13
1580 1.00000 1.00000 1 10
1581 100.05000 -100.05000 100.05 1
1582 12345.00000 NULL NULL NULL
1583 SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
1584 c1 c2 c3 c4
1585 0.00000 0.00000 0 7
1586 0.00000 -0.10000 -0.1 13
1587 SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2 DESC;
1588 c1 c2 c3 c4
1589 SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
1590 c1 c2 c3 c4
1591 SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2 DESC;
1592 c1 c2 c3 c4
1593 SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
1594 c1 c2 c3 c4
1595 SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2 DESC;
1596 c1 c2 c3 c4
1597 0.00000 0.00000 0 7
1598 0.00000 -0.10000 -0.1 13
1599 1.00000 1.00000 1 10
1600 100.05000 -100.05000 100.05 1
1601 12345.00000 NULL NULL NULL
1602 SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
1603 c1 c2 c3 c4
1604 0.00000 0.00000 0 7
1605 0.00000 -0.10000 -0.1 13
1606 SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2 DESC;
1607 c1 c2 c3 c4
1608 0.00000 0.00000 0 7
1609 0.00000 -0.10000 -0.1 13
1610 1.00000 1.00000 1 10
1611 100.05000 -100.05000 100.05 1
1612 12345.00000 NULL NULL NULL
1613 100000.00000 100000.00000 111111000 19
1614 100000.00000 -100000.00000 100000 5
1615 SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
1616 c1 c2 c3 c4
1617 0.00000 0.00000 0 7
1618 0.00000 -0.10000 -0.1 13
1619 SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2 DESC;
1620 c1 c2 c3 c4
1621 SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
1622 c1 c2 c3 c4
1623 SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2 DESC;
1624 c1 c2 c3 c4
1625 100.05000 -100.05000 100.05 1
1626 12345.00000 NULL NULL NULL
1627 SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
1628 c1 c2 c3 c4
1629 100.05000 -100.05000 100.05 1
1630 12345.00000 NULL NULL NULL
1631 SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2 DESC;
1632 c1 c2 c3 c4
1633 SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2 DESC LIMIT 2;
1634 c1 c2 c3 c4
1635 SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2 DESC;
1636 c1 c2 c3 c4
1637 SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
1638 c1 c2 c3 c4
1639 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC;
1640 c1 c2 c3 c4
1641 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC LIMIT 2;
1642 c1 c2 c3 c4
1643 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC;
1644 c1 c2 c3 c4
1645 0.00000 0.00000 0 7
1646 0.00000 -0.10000 -0.1 13
1647 1.00000 1.00000 1 10
1648 100.05000 -100.05000 100.05 1
1649 12345.00000 NULL NULL NULL
1650 100000.00000 100000.00000 111111000 19
1651 100000.00000 -100000.00000 100000 5
1652 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC LIMIT 2;
1653 c1 c2 c3 c4
1654 0.00000 0.00000 0 7
1655 0.00000 -0.10000 -0.1 13
1656 SELECT * FROM t1;
1657 c1 c2 c3 c4
1658 0.00000 -0.10000 -0.1 13
1659 0.00000 0.00000 0 7
1660 1.00000 1.00000 1 10
1661 100.05000 -100.05000 100.05 1
1662 100000.00000 -100000.00000 100000 5
1663 100000.00000 100000.00000 111111000 19
1664 12345.00000 NULL NULL NULL
1665 SELECT count(*) as total_rows, min(c2) as min_value, max(c2) FROM t1;
1666 total_rows min_value max(c2)
1667 7 -100000.00000 100000.00000
1668 SELECT * FROM t1 WHERE c3 = '-0.0';
1669 c1 c2 c3 c4
1670 0.00000 0.00000 0 7
1671 SELECT c1,c2 FROM t1;
1672 c1 c2
1673 0.00000 -0.10000
1674 0.00000 0.00000
1675 1.00000 1.00000
1676 100.05000 -100.05000
1677 100000.00000 -100000.00000
1678 100000.00000 100000.00000
1679 12345.00000 NULL
1680 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
1681 c1 c2
1682 0.00000 0.00000
1683 0.00000 -0.10000
1684 1.00000 1.00000
1685 100.05000 -100.05000
1686 12345.00000 NULL
1687 100000.00000 100000.00000
1688 100000.00000 -100000.00000
1689 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
1690 c1 c2 c3 c4
1691 0.00000 -0.10000 -0.1 13
1692 0.00000 0.00000 0 7
1693 SELECT * FROM t1 ORDER BY c1,c2 DESC LIMIT 2;
1694 c1 c2 c3 c4
1695 0.00000 0.00000 0 7
1696 0.00000 -0.10000 -0.1 13
1697 SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2;
1698 c1 c2 c3 c4
1699 SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2 LIMIT 2;
1700 c1 c2 c3 c4
1701 SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2 DESC;
1702 c1 c2 c3 c4
1703 SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
1704 c1 c2 c3 c4
1705 SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2;
1706 c1 c2 c3 c4
1707 0.00000 -0.10000 -0.1 13
1708 0.00000 0.00000 0 7
1709 1.00000 1.00000 1 10
1710 100.05000 -100.05000 100.05 1
1711 100000.00000 100000.00000 111111000 19
1712 SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2 LIMIT 2;
1713 c1 c2 c3 c4
1714 0.00000 -0.10000 -0.1 13
1715 0.00000 0.00000 0 7
1716 SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2;
1717 c1 c2 c3 c4
1718 0.00000 -0.10000 -0.1 13
1719 0.00000 0.00000 0 7
1720 1.00000 1.00000 1 10
1721 100.05000 -100.05000 100.05 1
1722 100000.00000 100000.00000 111111000 19
1723 SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2 LIMIT 2;
1724 c1 c2 c3 c4
1725 0.00000 -0.10000 -0.1 13
1726 0.00000 0.00000 0 7
1727 SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2;
1728 c1 c2 c3 c4
1729 0.00000 -0.10000 -0.1 13
1730 0.00000 0.00000 0 7
1731 1.00000 1.00000 1 10
1732 100.05000 -100.05000 100.05 1
1733 100000.00000 -100000.00000 100000 5
1734 100000.00000 100000.00000 111111000 19
1735 SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2 LIMIT 2;
1736 c1 c2 c3 c4
1737 0.00000 -0.10000 -0.1 13
1738 0.00000 0.00000 0 7
1739 SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2;
1740 c1 c2 c3 c4
1741 SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2 LIMIT 2;
1742 c1 c2 c3 c4
1743 SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2;
1744 c1 c2 c3 c4
1745 SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2 LIMIT 2;
1746 c1 c2 c3 c4
1747 SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2;
1748 c1 c2 c3 c4
1749 SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2 LIMIT 2;
1750 c1 c2 c3 c4
1751 SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2;
1752 c1 c2 c3 c4
1753 0.00000 -0.10000 -0.1 13
1754 0.00000 0.00000 0 7
1755 100.05000 -100.05000 100.05 1
1756 SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2 LIMIT 2;
1757 c1 c2 c3 c4
1758 0.00000 -0.10000 -0.1 13
1759 0.00000 0.00000 0 7
1760 SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2;
1761 c1 c2 c3 c4
1762 0.00000 0.00000 0 7
1763 SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2 LIMIT 2;
1764 c1 c2 c3 c4
1765 0.00000 0.00000 0 7
1766 SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2;
1767 c1 c2 c3 c4
1768 SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2 LIMIT 2;
1769 c1 c2 c3 c4
1770 SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2;
1771 c1 c2 c3 c4
1772 12345.00000 NULL NULL NULL
1773 SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2 LIMIT 2;
1774 c1 c2 c3 c4
1775 12345.00000 NULL NULL NULL
1776 SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2;
1777 c1 c2 c3 c4
1778 0.00000 -0.10000 -0.1 13
1779 0.00000 0.00000 0 7
1780 1.00000 1.00000 1 10
1781 100.05000 -100.05000 100.05 1
1782 100000.00000 -100000.00000 100000 5
1783 100000.00000 100000.00000 111111000 19
1784 SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2 LIMIT 2;
1785 c1 c2 c3 c4
1786 0.00000 -0.10000 -0.1 13
1787 0.00000 0.00000 0 7
1788 SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2 DESC;
1789 c1 c2 c3 c4
1790 0.00000 0.00000 0 7
1791 0.00000 -0.10000 -0.1 13
1792 1.00000 1.00000 1 10
1793 100.05000 -100.05000 100.05 1
1794 100000.00000 100000.00000 111111000 19
1795 SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
1796 c1 c2 c3 c4
1797 0.00000 0.00000 0 7
1798 0.00000 -0.10000 -0.1 13
1799 SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2 DESC;
1800 c1 c2 c3 c4
1801 0.00000 0.00000 0 7
1802 0.00000 -0.10000 -0.1 13
1803 1.00000 1.00000 1 10
1804 100.05000 -100.05000 100.05 1
1805 100000.00000 100000.00000 111111000 19
1806 SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
1807 c1 c2 c3 c4
1808 0.00000 0.00000 0 7
1809 0.00000 -0.10000 -0.1 13
1810 SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2 DESC;
1811 c1 c2 c3 c4
1812 0.00000 0.00000 0 7
1813 0.00000 -0.10000 -0.1 13
1814 1.00000 1.00000 1 10
1815 100.05000 -100.05000 100.05 1
1816 100000.00000 100000.00000 111111000 19
1817 100000.00000 -100000.00000 100000 5
1818 SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
1819 c1 c2 c3 c4
1820 0.00000 0.00000 0 7
1821 0.00000 -0.10000 -0.1 13
1822 SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2 DESC;
1823 c1 c2 c3 c4
1824 SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
1825 c1 c2 c3 c4
1826 SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2 DESC;
1827 c1 c2 c3 c4
1828 SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
1829 c1 c2 c3 c4
1830 SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2 DESC;
1831 c1 c2 c3 c4
1832 SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
1833 c1 c2 c3 c4
1834 SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2 DESC;
1835 c1 c2 c3 c4
1836 0.00000 0.00000 0 7
1837 0.00000 -0.10000 -0.1 13
1838 100.05000 -100.05000 100.05 1
1839 SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2 DESC LIMIT 2;
1840 c1 c2 c3 c4
1841 0.00000 0.00000 0 7
1842 0.00000 -0.10000 -0.1 13
1843 SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2 DESC;
1844 c1 c2 c3 c4
1845 0.00000 0.00000 0 7
1846 SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2 DESC LIMIT 2;
1847 c1 c2 c3 c4
1848 0.00000 0.00000 0 7
1849 SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2 DESC;
1850 c1 c2 c3 c4
1851 SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
1852 c1 c2 c3 c4
1853 SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2 DESC;
1854 c1 c2 c3 c4
1855 12345.00000 NULL NULL NULL
1856 SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2 DESC LIMIT 2;
1857 c1 c2 c3 c4
1858 12345.00000 NULL NULL NULL
1859 SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2 DESC;
1860 c1 c2 c3 c4
1861 0.00000 0.00000 0 7
1862 0.00000 -0.10000 -0.1 13
1863 1.00000 1.00000 1 10
1864 100.05000 -100.05000 100.05 1
1865 100000.00000 100000.00000 111111000 19
1866 100000.00000 -100000.00000 100000 5
1867 SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2 DESC LIMIT 2;
1868 c1 c2 c3 c4
1869 0.00000 0.00000 0 7
1870 0.00000 -0.10000 -0.1 13
1871 SELECT c1 FROM t1 GROUP BY c1;
1872 c1
1873 0.00000
1874 1.00000
1875 100.05000
1876 100000.00000
1877 12345.00000
1878 SELECT DISTINCT c1 FROM t1;
1879 c1
1880 0.00000
1881 1.00000
1882 100.05000
1883 100000.00000
1884 12345.00000
1885 SELECT c1,MIN(c2) FROM t1 GROUP BY c1;
1886 c1 MIN(c2)
1887 0.00000 -0.10000
1888 1.00000 1.00000
1889 100.05000 -100.05000
1890 100000.00000 -100000.00000
1891 12345.00000 NULL
1892 CREATE TABLE t5(c1 FLOAT(23,0) UNSIGNED NOT NULL, c2 FLOAT(23,0) SIGNED NULL, c3 FLOAT, c4 INT, INDEX idx(c1,c2));
1893 Warnings:
1894 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
1895 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1896 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
1897 INSERT INTO t5 VALUES('1e+22','-1e+22','1e+22',1),('1e-22','-1e-22','1e-22',2);
1898 SELECT * FROM t5;
1899 ALTER TABLE t5 CHANGE c1 c1 FLOAT(24,0) SIGNED NOT NULL, CHANGE c2 c2 FLOAT(24,0) UNSIGNED NULL;
1900 Warnings:
1901 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
1902 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
1903 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1904 Warning 1264 Out of range value for column 'c2' at row 1
1905 INSERT INTO t5 VALUES('-1e+23','1e+23','1e+23',3),('-1e-23','1e-23','1e-23',4);
1906 SELECT * FROM t5;
1907 ALTER TABLE t5 CHANGE c1 c1 FLOAT(53,0) UNSIGNED, CHANGE c2 c2 FLOAT(53,0) SIGNED;
1908 Warnings:
1909 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
1910 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1911 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
1912 Warning 1264 Out of range value for column 'c1' at row 3
1913 INSERT INTO t5 VALUES('1e+52','-1e+52','1e+52',5),('1e-52','-1e-52','1e-52',6);
1914 Warnings:
1915 Warning 1264 Out of range value for column 'c1' at row 1
1916 Warning 1264 Out of range value for column 'c2' at row 1
1917 Warning 1264 Out of range value for column 'c3' at row 1
1918 INSERT INTO t5 VALUES('1e+53','-1e+53','1e+53',7),('1e-53','-1e-53','1e-53',8);
1919 Warnings:
1920 Warning 1264 Out of range value for column 'c1' at row 1
1921 Warning 1264 Out of range value for column 'c2' at row 1
1922 Warning 1264 Out of range value for column 'c3' at row 1
1923 SELECT * FROM t5;
1924 c1 c2 c3 c4
1925 # # 0 6
1926 # # 0 8
1927 # # 1e-22 2
1928 # # 1e-23 4
1929 # # 1e22 1
1930 # # 1e23 3
1931 # # 3.40282e38 5
1932 # # 3.40282e38 7
1933 DROP TABLE t5;
1934 CREATE TABLE t5(c1 FLOAT(16,6), c2 tinyint);
1935 Warnings:
1936 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
1937 INSERT INTO t5 VALUES(1.1325,3);
1938 SELECT ROUND(c1,c2),TRUNCATE(c1,c2) FROM t5;
1939 ROUND(c1,c2) TRUNCATE(c1,c2)
1940 1.133 1.132
1941 DROP TABLE t5;
1942 CREATE TABLE t7(c1 FLOAT(5,10));
1943 ERROR 42000: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'c1').
1944 DROP TABLE t1,t2;
1945 CREATE TABLE t1(c1 DOUBLE(10,5) UNSIGNED NOT NULL, c2 DOUBLE(10,5) SIGNED NULL, c3 DOUBLE, c4 INT, UNIQUE INDEX idx(c1,c2));
1946 Warnings:
1947 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
1948 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1949 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
1950 CREATE TABLE t2(c1 DOUBLE(10,0) SIGNED NOT NULL, c2 DOUBLE(10,0) UNSIGNED NULL, c3 DOUBLE, c4 INT);
1951 Warnings:
1952 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
1953 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
1954 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
1955 INSERT INTO t1 VALUES('00100.05000','-00100.05000','00100.05000',1);
1956 INSERT INTO t2 VALUES('-1000000000','1000000000','1000000000',2);
1957 INSERT INTO t1(c1) VALUES('12345.000009');
1958 INSERT INTO t1 VALUES('99999.99999','-99999.99999','99999.99999',3);
1959 INSERT INTO t2 VALUES('-9999999999','-9999999999','9999999999',4);
1960 Warnings:
1961 Warning 1264 Out of range value for column 'c2' at row 1
1962 SELECT * FROM t1;
1963 c1 c2 c3 c4
1964 100.05000 -100.05000 100.05 1
1965 12345.00001 NULL NULL NULL
1966 99999.99999 -99999.99999 99999.99999 3
1967 INSERT INTO t1 VALUES('100000.000002','-100000.000002','100000.000002',5);
1968 ERROR 23000: Duplicate entry '99999.99999--99999.99999' for key 't1.idx'
1969 DELETE FROM t1 WHERE c1='99999.99999' AND c2='-99999.99999';
1970 INSERT INTO t1 VALUES('100000.000002','-100000.000002','100000.000002',5);
1971 Warnings:
1972 Warning 1264 Out of range value for column 'c1' at row 1
1973 Warning 1264 Out of range value for column 'c2' at row 1
1974 INSERT INTO t2 VALUES('10000000000','-10000000000','10000000000',6);
1975 Warnings:
1976 Warning 1264 Out of range value for column 'c1' at row 1
1977 Warning 1264 Out of range value for column 'c2' at row 1
1978 insert into t1 values ("0.0","0.0","0.0",7),("01.0","01.0","01.0",10);
1979 insert into t1 values ("-.1","-.1","-.1",13);
1980 Warnings:
1981 Warning 1264 Out of range value for column 'c1' at row 1
1982 insert into t1 values ("+111111111.11","+111111111.11","+111111111.11",19);
1983 Warnings:
1984 Warning 1264 Out of range value for column 'c1' at row 1
1985 Warning 1264 Out of range value for column 'c2' at row 1
1986 insert into t2 values ("0.0","0.0","0.0",7),("-0.0","-0.0","-0.0",8),("+0.0","+0.0","+0.0",9),("01.0","01.0","01.0",10),("+01.0","+01.0","+01.0",11),("-01.0","-01.0","-01.0",12);
1987 Warnings:
1988 Warning 1264 Out of range value for column 'c2' at row 6
1989 insert into t2 values ("-.1","-.1","-.1",13),("+.1","+.1","+.1",14),(".1",".1",".1",15);
1990 Warnings:
1991 Warning 1264 Out of range value for column 'c2' at row 1
1992 insert into t2 values ("00000000000001","00000000000001","00000000000001",16),("+0000000000001","+0000000000001","+0000000000001",17),("-0000000000001","-0000000000001","-0000000000001",18);
1993 Warnings:
1994 Warning 1264 Out of range value for column 'c2' at row 3
1995 insert into t2 values ("+111111111.11","+111111111.11","+111111111.11",19),("111111111.11","111111111.11","111111111.11",20),("-11111111.11","-11111111.11","-11111111.11",21);
1996 Warnings:
1997 Warning 1264 Out of range value for column 'c2' at row 3
1998 insert into t2 values ("-111111111.11","-111111111.11","-111111111.11",22),("+1111111111.11","+1111111111.11","+1111111111.11",23),("1111111111.11","1111111111.11","1111111111.11",24);
1999 Warnings:
2000 Warning 1264 Out of range value for column 'c2' at row 1
2001 insert into t2 values ("1e+1000","1e+1000","1e+1000",25),("1e-1000","1e-1000","1e-1000",26),("-1e+1000","-1e+1000","-1e+1000",27);
2002 Warnings:
2003 Warning 1264 Out of range value for column 'c1' at row 1
2004 Warning 1264 Out of range value for column 'c1' at row 1
2005 Warning 1264 Out of range value for column 'c2' at row 1
2006 Warning 1264 Out of range value for column 'c2' at row 1
2007 Warning 1264 Out of range value for column 'c3' at row 1
2008 Warning 1264 Out of range value for column 'c1' at row 3
2009 Warning 1264 Out of range value for column 'c1' at row 3
2010 Warning 1264 Out of range value for column 'c2' at row 3
2011 Warning 1264 Out of range value for column 'c2' at row 3
2012 Warning 1264 Out of range value for column 'c3' at row 3
2013 insert into t2 values ("1e+4294967296","1e+4294967296","1e+4294967296",28),("1e-4294967296","1e-4294967296","1e-4294967296",29);
2014 Warnings:
2015 Warning 1264 Out of range value for column 'c1' at row 1
2016 Warning 1264 Out of range value for column 'c1' at row 1
2017 Warning 1264 Out of range value for column 'c2' at row 1
2018 Warning 1264 Out of range value for column 'c2' at row 1
2019 Warning 1264 Out of range value for column 'c3' at row 1
2020 Warning 1265 Data truncated for column 'c1' at row 2
2021 Warning 1265 Data truncated for column 'c2' at row 2
2022 Warning 1265 Data truncated for column 'c3' at row 2
2023 insert into t2 values ("1e+18446744073709551615","1e+18446744073709551615","1e+18446744073709551615",30),("1e+18446744073709551616","1e+18446744073709551616","1e+18446744073709551616",31),("1e-9223372036854775807","1e-9223372036854775807","1e-9223372036854775807",32),("1e-9223372036854775809","1e-9223372036854775809","1e-9223372036854775809",33);
2024 Warnings:
2025 Warning 1264 Out of range value for column 'c1' at row 1
2026 Warning 1264 Out of range value for column 'c1' at row 1
2027 Warning 1264 Out of range value for column 'c2' at row 1
2028 Warning 1264 Out of range value for column 'c2' at row 1
2029 Warning 1264 Out of range value for column 'c3' at row 1
2030 Warning 1264 Out of range value for column 'c1' at row 2
2031 Warning 1264 Out of range value for column 'c1' at row 2
2032 Warning 1264 Out of range value for column 'c2' at row 2
2033 Warning 1264 Out of range value for column 'c2' at row 2
2034 Warning 1264 Out of range value for column 'c3' at row 2
2035 Warning 1265 Data truncated for column 'c1' at row 3
2036 Warning 1265 Data truncated for column 'c2' at row 3
2037 Warning 1265 Data truncated for column 'c3' at row 3
2038 Warning 1265 Data truncated for column 'c1' at row 4
2039 Warning 1265 Data truncated for column 'c2' at row 4
2040 Warning 1265 Data truncated for column 'c3' at row 4
2041 SELECT * FROM t1;
2042 c1 c2 c3 c4
2043 0.00000 -0.10000 -0.1 13
2044 0.00000 0.00000 0 7
2045 1.00000 1.00000 1 10
2046 100.05000 -100.05000 100.05 1
2047 12345.00001 NULL NULL NULL
2048 99999.99999 -99999.99999 100000.000002 5
2049 99999.99999 99999.99999 111111111.11 19
2050 SELECT * FROM t2;
2051 c1 c2 c3 c4
2052 -1 0 -1 12
2053 -1 0 -1 18
2054 -1000000000 1000000000 1000000000 2
2055 -11111111 0 -11111111.11 21
2056 -111111111 0 -111111111.11 22
2057 -9999999999 0 -1.7976931348623157e308 27
2058 -9999999999 0 9999999999 4
2059 0 0 -0 8
2060 0 0 -0.1 13
2061 0 0 0 26
2062 0 0 0 29
2063 0 0 0 32
2064 0 0 0 33
2065 0 0 0 7
2066 0 0 0 9
2067 0 0 0.1 14
2068 0 0 0.1 15
2069 1 1 1 10
2070 1 1 1 11
2071 1 1 1 16
2072 1 1 1 17
2073 111111111 111111111 111111111.11 19
2074 111111111 111111111 111111111.11 20
2075 1111111111 1111111111 1111111111.11 23
2076 1111111111 1111111111 1111111111.11 24
2077 9999999999 0 10000000000 6
2078 9999999999 9999999999 1.7976931348623157e308 25
2079 9999999999 9999999999 1.7976931348623157e308 28
2080 9999999999 9999999999 1.7976931348623157e308 30
2081 9999999999 9999999999 1.7976931348623157e308 31
2082 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) as max_value, sum(c1) as sum, avg(c1) as avg FROM t1;
2083 total_rows min_value max_value sum avg
2084 7 0.00000 99999.99999 212446.04999 30349.435712857
2085 SELECT count(*) as total_rows, min(c2) as min_value, max(c2) as max_value, sum(c2) as sum, avg(c2) as avg FROM t1;
2086 total_rows min_value max_value sum avg
2087 7 -99999.99999 99999.99999 -99.15000 -16.525000000
2088 SELECT count(*) as total_rows, min(c3) as min_value, max(c3) as max_value, sum(c3) as sum, avg(c3) as avg FROM t1;
2089 total_rows min_value max_value sum avg
2090 7 -0.1 111111111.11 111211212.060002 18535202.010000333
2091 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) as max_value, sum(c1) as sum, avg(c1) as avg FROM t2;
2092 total_rows min_value max_value sum avg
2093 30 -9999999999 9999999999 31322222221 1044074074.0333
2094 SELECT count(*) as total_rows, min(c2) as min_value, max(c2) as max_value, sum(c2) as sum, avg(c2) as avg FROM t2;
2095 total_rows min_value max_value sum avg
2096 30 0 9999999999 43444444444 1448148148.1333
2097 SELECT count(*) as total_rows, min(c3) as min_value, max(c3) as max_value, sum(c3) as sum, avg(c3) as avg FROM t2;
2098 total_rows min_value max_value sum avg
2099 30 -1.7976931348623157e308 1.7976931348623157e308 inf inf
2100 SELECT * FROM t1;
2101 c1 c2 c3 c4
2102 0.00000 -0.10000 -0.1 13
2103 0.00000 0.00000 0 7
2104 1.00000 1.00000 1 10
2105 100.05000 -100.05000 100.05 1
2106 12345.00001 NULL NULL NULL
2107 99999.99999 -99999.99999 100000.000002 5
2108 99999.99999 99999.99999 111111111.11 19
2109 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) FROM t1;
2110 total_rows min_value max(c1)
2111 7 0.00000 99999.99999
2112 SELECT * FROM t1 WHERE c3 = '0.0';
2113 c1 c2 c3 c4
2114 0.00000 0.00000 0 7
2115 SELECT c1,c2 FROM t1;
2116 c1 c2
2117 0.00000 -0.10000
2118 0.00000 0.00000
2119 1.00000 1.00000
2120 100.05000 -100.05000
2121 12345.00001 NULL
2122 99999.99999 -99999.99999
2123 99999.99999 99999.99999
2124 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
2125 c1 c2
2126 0.00000 0.00000
2127 0.00000 -0.10000
2128 1.00000 1.00000
2129 100.05000 -100.05000
2130 12345.00001 NULL
2131 99999.99999 99999.99999
2132 99999.99999 -99999.99999
2133 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
2134 c1 c2 c3 c4
2135 0.00000 -0.10000 -0.1 13
2136 0.00000 0.00000 0 7
2137 SELECT * FROM t1 ORDER BY c1,c2 DESC LIMIT 2;
2138 c1 c2 c3 c4
2139 0.00000 0.00000 0 7
2140 0.00000 -0.10000 -0.1 13
2141 SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2;
2142 c1 c2 c3 c4
2143 0.00000 -0.10000 -0.1 13
2144 0.00000 0.00000 0 7
2145 SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2 LIMIT 2;
2146 c1 c2 c3 c4
2147 0.00000 -0.10000 -0.1 13
2148 0.00000 0.00000 0 7
2149 SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2 DESC;
2150 c1 c2 c3 c4
2151 0.00000 0.00000 0 7
2152 0.00000 -0.10000 -0.1 13
2153 SELECT * FROM t1 WHERE c1 = '0.0' ORDER BY c1,c2 DESC LIMIT 2;
2154 c1 c2 c3 c4
2155 0.00000 0.00000 0 7
2156 0.00000 -0.10000 -0.1 13
2157 SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2;
2158 c1 c2 c3 c4
2159 1.00000 1.00000 1 10
2160 100.05000 -100.05000 100.05 1
2161 12345.00001 NULL NULL NULL
2162 99999.99999 -99999.99999 100000.000002 5
2163 99999.99999 99999.99999 111111111.11 19
2164 SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2 LIMIT 2;
2165 c1 c2 c3 c4
2166 1.00000 1.00000 1 10
2167 100.05000 -100.05000 100.05 1
2168 SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2;
2169 c1 c2 c3 c4
2170 1.00000 1.00000 1 10
2171 100.05000 -100.05000 100.05 1
2172 12345.00001 NULL NULL NULL
2173 99999.99999 -99999.99999 100000.000002 5
2174 99999.99999 99999.99999 111111111.11 19
2175 SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2 LIMIT 2;
2176 c1 c2 c3 c4
2177 1.00000 1.00000 1 10
2178 100.05000 -100.05000 100.05 1
2179 SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2;
2180 c1 c2 c3 c4
2181 0.00000 -0.10000 -0.1 13
2182 0.00000 0.00000 0 7
2183 1.00000 1.00000 1 10
2184 100.05000 -100.05000 100.05 1
2185 12345.00001 NULL NULL NULL
2186 99999.99999 -99999.99999 100000.000002 5
2187 99999.99999 99999.99999 111111111.11 19
2188 SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2 LIMIT 2;
2189 c1 c2 c3 c4
2190 0.00000 -0.10000 -0.1 13
2191 0.00000 0.00000 0 7
2192 SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2;
2193 c1 c2 c3 c4
2194 SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2 LIMIT 2;
2195 c1 c2 c3 c4
2196 SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2;
2197 c1 c2 c3 c4
2198 0.00000 -0.10000 -0.1 13
2199 0.00000 0.00000 0 7
2200 SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2 LIMIT 2;
2201 c1 c2 c3 c4
2202 0.00000 -0.10000 -0.1 13
2203 0.00000 0.00000 0 7
2204 SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2;
2205 c1 c2 c3 c4
2206 0.00000 -0.10000 -0.1 13
2207 0.00000 0.00000 0 7
2208 SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2 LIMIT 2;
2209 c1 c2 c3 c4
2210 0.00000 -0.10000 -0.1 13
2211 0.00000 0.00000 0 7
2212 SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2;
2213 c1 c2 c3 c4
2214 0.00000 -0.10000 -0.1 13
2215 0.00000 0.00000 0 7
2216 1.00000 1.00000 1 10
2217 100.05000 -100.05000 100.05 1
2218 12345.00001 NULL NULL NULL
2219 99999.99999 -99999.99999 100000.000002 5
2220 99999.99999 99999.99999 111111111.11 19
2221 SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2 LIMIT 2;
2222 c1 c2 c3 c4
2223 0.00000 -0.10000 -0.1 13
2224 0.00000 0.00000 0 7
2225 SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2;
2226 c1 c2 c3 c4
2227 0.00000 -0.10000 -0.1 13
2228 0.00000 0.00000 0 7
2229 99999.99999 -99999.99999 100000.000002 5
2230 99999.99999 99999.99999 111111111.11 19
2231 SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2 LIMIT 2;
2232 c1 c2 c3 c4
2233 0.00000 -0.10000 -0.1 13
2234 0.00000 0.00000 0 7
2235 SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2;
2236 c1 c2 c3 c4
2237 1.00000 1.00000 1 10
2238 SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2 LIMIT 2;
2239 c1 c2 c3 c4
2240 1.00000 1.00000 1 10
2241 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2;
2242 c1 c2 c3 c4
2243 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 LIMIT 2;
2244 c1 c2 c3 c4
2245 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2;
2246 c1 c2 c3 c4
2247 0.00000 -0.10000 -0.1 13
2248 0.00000 0.00000 0 7
2249 1.00000 1.00000 1 10
2250 100.05000 -100.05000 100.05 1
2251 12345.00001 NULL NULL NULL
2252 99999.99999 -99999.99999 100000.000002 5
2253 99999.99999 99999.99999 111111111.11 19
2254 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 LIMIT 2;
2255 c1 c2 c3 c4
2256 0.00000 -0.10000 -0.1 13
2257 0.00000 0.00000 0 7
2258 SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2 DESC;
2259 c1 c2 c3 c4
2260 1.00000 1.00000 1 10
2261 100.05000 -100.05000 100.05 1
2262 12345.00001 NULL NULL NULL
2263 99999.99999 99999.99999 111111111.11 19
2264 99999.99999 -99999.99999 100000.000002 5
2265 SELECT * FROM t1 WHERE c1 <> '0.0' ORDER BY c1,c2 DESC LIMIT 2;
2266 c1 c2 c3 c4
2267 1.00000 1.00000 1 10
2268 100.05000 -100.05000 100.05 1
2269 SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2 DESC;
2270 c1 c2 c3 c4
2271 1.00000 1.00000 1 10
2272 100.05000 -100.05000 100.05 1
2273 12345.00001 NULL NULL NULL
2274 99999.99999 99999.99999 111111111.11 19
2275 99999.99999 -99999.99999 100000.000002 5
2276 SELECT * FROM t1 WHERE c1 > '0.0' ORDER BY c1,c2 DESC LIMIT 2;
2277 c1 c2 c3 c4
2278 1.00000 1.00000 1 10
2279 100.05000 -100.05000 100.05 1
2280 SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2 DESC;
2281 c1 c2 c3 c4
2282 0.00000 0.00000 0 7
2283 0.00000 -0.10000 -0.1 13
2284 1.00000 1.00000 1 10
2285 100.05000 -100.05000 100.05 1
2286 12345.00001 NULL NULL NULL
2287 99999.99999 99999.99999 111111111.11 19
2288 99999.99999 -99999.99999 100000.000002 5
2289 SELECT * FROM t1 WHERE c1 >= '0.0' ORDER BY c1,c2 DESC LIMIT 2;
2290 c1 c2 c3 c4
2291 0.00000 0.00000 0 7
2292 0.00000 -0.10000 -0.1 13
2293 SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2 DESC;
2294 c1 c2 c3 c4
2295 SELECT * FROM t1 WHERE c1 < '0.0' ORDER BY c1,c2 DESC LIMIT 2;
2296 c1 c2 c3 c4
2297 SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2 DESC;
2298 c1 c2 c3 c4
2299 0.00000 0.00000 0 7
2300 0.00000 -0.10000 -0.1 13
2301 SELECT * FROM t1 WHERE c1 <= '0.0' ORDER BY c1,c2 DESC LIMIT 2;
2302 c1 c2 c3 c4
2303 0.00000 0.00000 0 7
2304 0.00000 -0.10000 -0.1 13
2305 SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2 DESC;
2306 c1 c2 c3 c4
2307 0.00000 0.00000 0 7
2308 0.00000 -0.10000 -0.1 13
2309 SELECT * FROM t1 WHERE c1 <=> '0.0' ORDER BY c1,c2 DESC LIMIT 2;
2310 c1 c2 c3 c4
2311 0.00000 0.00000 0 7
2312 0.00000 -0.10000 -0.1 13
2313 SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2 DESC;
2314 c1 c2 c3 c4
2315 0.00000 0.00000 0 7
2316 0.00000 -0.10000 -0.1 13
2317 1.00000 1.00000 1 10
2318 100.05000 -100.05000 100.05 1
2319 12345.00001 NULL NULL NULL
2320 99999.99999 99999.99999 111111111.11 19
2321 99999.99999 -99999.99999 100000.000002 5
2322 SELECT * FROM t1 WHERE c1 BETWEEN '0.0' AND '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
2323 c1 c2 c3 c4
2324 0.00000 0.00000 0 7
2325 0.00000 -0.10000 -0.1 13
2326 SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2 DESC;
2327 c1 c2 c3 c4
2328 0.00000 0.00000 0 7
2329 0.00000 -0.10000 -0.1 13
2330 99999.99999 99999.99999 111111111.11 19
2331 99999.99999 -99999.99999 100000.000002 5
2332 SELECT * FROM t1 WHERE c1 IN ('0.0','99999.99999') ORDER BY c1,c2 DESC LIMIT 2;
2333 c1 c2 c3 c4
2334 0.00000 0.00000 0 7
2335 0.00000 -0.10000 -0.1 13
2336 SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2 DESC;
2337 c1 c2 c3 c4
2338 1.00000 1.00000 1 10
2339 SELECT * FROM t1 WHERE c1 >= '0.0' AND c1 < '99999.99999' AND c2 = '1.0' ORDER BY c1,c2 DESC LIMIT 2;
2340 c1 c2 c3 c4
2341 1.00000 1.00000 1 10
2342 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC;
2343 c1 c2 c3 c4
2344 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC LIMIT 2;
2345 c1 c2 c3 c4
2346 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC;
2347 c1 c2 c3 c4
2348 0.00000 0.00000 0 7
2349 0.00000 -0.10000 -0.1 13
2350 1.00000 1.00000 1 10
2351 100.05000 -100.05000 100.05 1
2352 12345.00001 NULL NULL NULL
2353 99999.99999 99999.99999 111111111.11 19
2354 99999.99999 -99999.99999 100000.000002 5
2355 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC LIMIT 2;
2356 c1 c2 c3 c4
2357 0.00000 0.00000 0 7
2358 0.00000 -0.10000 -0.1 13
2359 SELECT * FROM t1;
2360 c1 c2 c3 c4
2361 0.00000 -0.10000 -0.1 13
2362 0.00000 0.00000 0 7
2363 1.00000 1.00000 1 10
2364 100.05000 -100.05000 100.05 1
2365 12345.00001 NULL NULL NULL
2366 99999.99999 -99999.99999 100000.000002 5
2367 99999.99999 99999.99999 111111111.11 19
2368 SELECT count(*) as total_rows, min(c1) as min_value, max(c1) FROM t1;
2369 total_rows min_value max(c1)
2370 7 0.00000 99999.99999
2371 SELECT * FROM t1 WHERE c3 = '-0.0';
2372 c1 c2 c3 c4
2373 0.00000 0.00000 0 7
2374 SELECT c1,c2 FROM t1;
2375 c1 c2
2376 0.00000 -0.10000
2377 0.00000 0.00000
2378 1.00000 1.00000
2379 100.05000 -100.05000
2380 12345.00001 NULL
2381 99999.99999 -99999.99999
2382 99999.99999 99999.99999
2383 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
2384 c1 c2
2385 0.00000 0.00000
2386 0.00000 -0.10000
2387 1.00000 1.00000
2388 100.05000 -100.05000
2389 12345.00001 NULL
2390 99999.99999 99999.99999
2391 99999.99999 -99999.99999
2392 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
2393 c1 c2 c3 c4
2394 0.00000 -0.10000 -0.1 13
2395 0.00000 0.00000 0 7
2396 SELECT * FROM t1 ORDER BY c1,c2 DESC LIMIT 2;
2397 c1 c2 c3 c4
2398 0.00000 0.00000 0 7
2399 0.00000 -0.10000 -0.1 13
2400 SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2;
2401 c1 c2 c3 c4
2402 99999.99999 -99999.99999 100000.000002 5
2403 99999.99999 99999.99999 111111111.11 19
2404 SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2 LIMIT 2;
2405 c1 c2 c3 c4
2406 99999.99999 -99999.99999 100000.000002 5
2407 99999.99999 99999.99999 111111111.11 19
2408 SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2 DESC;
2409 c1 c2 c3 c4
2410 99999.99999 99999.99999 111111111.11 19
2411 99999.99999 -99999.99999 100000.000002 5
2412 SELECT * FROM t1 WHERE c1 = '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
2413 c1 c2 c3 c4
2414 99999.99999 99999.99999 111111111.11 19
2415 99999.99999 -99999.99999 100000.000002 5
2416 SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2;
2417 c1 c2 c3 c4
2418 0.00000 -0.10000 -0.1 13
2419 0.00000 0.00000 0 7
2420 1.00000 1.00000 1 10
2421 100.05000 -100.05000 100.05 1
2422 12345.00001 NULL NULL NULL
2423 SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2 LIMIT 2;
2424 c1 c2 c3 c4
2425 0.00000 -0.10000 -0.1 13
2426 0.00000 0.00000 0 7
2427 SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2;
2428 c1 c2 c3 c4
2429 SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2 LIMIT 2;
2430 c1 c2 c3 c4
2431 SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2;
2432 c1 c2 c3 c4
2433 99999.99999 -99999.99999 100000.000002 5
2434 99999.99999 99999.99999 111111111.11 19
2435 SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2 LIMIT 2;
2436 c1 c2 c3 c4
2437 99999.99999 -99999.99999 100000.000002 5
2438 99999.99999 99999.99999 111111111.11 19
2439 SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2;
2440 c1 c2 c3 c4
2441 0.00000 -0.10000 -0.1 13
2442 0.00000 0.00000 0 7
2443 1.00000 1.00000 1 10
2444 100.05000 -100.05000 100.05 1
2445 12345.00001 NULL NULL NULL
2446 SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2 LIMIT 2;
2447 c1 c2 c3 c4
2448 0.00000 -0.10000 -0.1 13
2449 0.00000 0.00000 0 7
2450 SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2;
2451 c1 c2 c3 c4
2452 0.00000 -0.10000 -0.1 13
2453 0.00000 0.00000 0 7
2454 1.00000 1.00000 1 10
2455 100.05000 -100.05000 100.05 1
2456 12345.00001 NULL NULL NULL
2457 99999.99999 -99999.99999 100000.000002 5
2458 99999.99999 99999.99999 111111111.11 19
2459 SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2 LIMIT 2;
2460 c1 c2 c3 c4
2461 0.00000 -0.10000 -0.1 13
2462 0.00000 0.00000 0 7
2463 SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2;
2464 c1 c2 c3 c4
2465 99999.99999 -99999.99999 100000.000002 5
2466 99999.99999 99999.99999 111111111.11 19
2467 SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2 LIMIT 2;
2468 c1 c2 c3 c4
2469 99999.99999 -99999.99999 100000.000002 5
2470 99999.99999 99999.99999 111111111.11 19
2471 SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2;
2472 c1 c2 c3 c4
2473 100.05000 -100.05000 100.05 1
2474 12345.00001 NULL NULL NULL
2475 99999.99999 -99999.99999 100000.000002 5
2476 99999.99999 99999.99999 111111111.11 19
2477 SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2 LIMIT 2;
2478 c1 c2 c3 c4
2479 100.05000 -100.05000 100.05 1
2480 12345.00001 NULL NULL NULL
2481 SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2;
2482 c1 c2 c3 c4
2483 100.05000 -100.05000 100.05 1
2484 99999.99999 -99999.99999 100000.000002 5
2485 99999.99999 99999.99999 111111111.11 19
2486 SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2 LIMIT 2;
2487 c1 c2 c3 c4
2488 100.05000 -100.05000 100.05 1
2489 99999.99999 -99999.99999 100000.000002 5
2490 SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2;
2491 c1 c2 c3 c4
2492 SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2 LIMIT 2;
2493 c1 c2 c3 c4
2494 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2;
2495 c1 c2 c3 c4
2496 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 LIMIT 2;
2497 c1 c2 c3 c4
2498 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2;
2499 c1 c2 c3 c4
2500 0.00000 -0.10000 -0.1 13
2501 0.00000 0.00000 0 7
2502 1.00000 1.00000 1 10
2503 100.05000 -100.05000 100.05 1
2504 12345.00001 NULL NULL NULL
2505 99999.99999 -99999.99999 100000.000002 5
2506 99999.99999 99999.99999 111111111.11 19
2507 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 LIMIT 2;
2508 c1 c2 c3 c4
2509 0.00000 -0.10000 -0.1 13
2510 0.00000 0.00000 0 7
2511 SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2 DESC;
2512 c1 c2 c3 c4
2513 0.00000 0.00000 0 7
2514 0.00000 -0.10000 -0.1 13
2515 1.00000 1.00000 1 10
2516 100.05000 -100.05000 100.05 1
2517 12345.00001 NULL NULL NULL
2518 SELECT * FROM t1 WHERE c1 <> '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
2519 c1 c2 c3 c4
2520 0.00000 0.00000 0 7
2521 0.00000 -0.10000 -0.1 13
2522 SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2 DESC;
2523 c1 c2 c3 c4
2524 SELECT * FROM t1 WHERE c1 > '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
2525 c1 c2 c3 c4
2526 SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2 DESC;
2527 c1 c2 c3 c4
2528 99999.99999 99999.99999 111111111.11 19
2529 99999.99999 -99999.99999 100000.000002 5
2530 SELECT * FROM t1 WHERE c1 >= '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
2531 c1 c2 c3 c4
2532 99999.99999 99999.99999 111111111.11 19
2533 99999.99999 -99999.99999 100000.000002 5
2534 SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2 DESC;
2535 c1 c2 c3 c4
2536 0.00000 0.00000 0 7
2537 0.00000 -0.10000 -0.1 13
2538 1.00000 1.00000 1 10
2539 100.05000 -100.05000 100.05 1
2540 12345.00001 NULL NULL NULL
2541 SELECT * FROM t1 WHERE c1 < '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
2542 c1 c2 c3 c4
2543 0.00000 0.00000 0 7
2544 0.00000 -0.10000 -0.1 13
2545 SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2 DESC;
2546 c1 c2 c3 c4
2547 0.00000 0.00000 0 7
2548 0.00000 -0.10000 -0.1 13
2549 1.00000 1.00000 1 10
2550 100.05000 -100.05000 100.05 1
2551 12345.00001 NULL NULL NULL
2552 99999.99999 99999.99999 111111111.11 19
2553 99999.99999 -99999.99999 100000.000002 5
2554 SELECT * FROM t1 WHERE c1 <= '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
2555 c1 c2 c3 c4
2556 0.00000 0.00000 0 7
2557 0.00000 -0.10000 -0.1 13
2558 SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2 DESC;
2559 c1 c2 c3 c4
2560 99999.99999 99999.99999 111111111.11 19
2561 99999.99999 -99999.99999 100000.000002 5
2562 SELECT * FROM t1 WHERE c1 <=> '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
2563 c1 c2 c3 c4
2564 99999.99999 99999.99999 111111111.11 19
2565 99999.99999 -99999.99999 100000.000002 5
2566 SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2 DESC;
2567 c1 c2 c3 c4
2568 100.05000 -100.05000 100.05 1
2569 12345.00001 NULL NULL NULL
2570 99999.99999 99999.99999 111111111.11 19
2571 99999.99999 -99999.99999 100000.000002 5
2572 SELECT * FROM t1 WHERE c1 BETWEEN '100.05' AND '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
2573 c1 c2 c3 c4
2574 100.05000 -100.05000 100.05 1
2575 12345.00001 NULL NULL NULL
2576 SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2 DESC;
2577 c1 c2 c3 c4
2578 100.05000 -100.05000 100.05 1
2579 99999.99999 99999.99999 111111111.11 19
2580 99999.99999 -99999.99999 100000.000002 5
2581 SELECT * FROM t1 WHERE c1 IN ('100.05','99999.99999') ORDER BY c1,c2 DESC LIMIT 2;
2582 c1 c2 c3 c4
2583 100.05000 -100.05000 100.05 1
2584 99999.99999 99999.99999 111111111.11 19
2585 SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2 DESC;
2586 c1 c2 c3 c4
2587 SELECT * FROM t1 WHERE c1 >= '100.05' AND c1 < '99999.99999' AND c2 = '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
2588 c1 c2 c3 c4
2589 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC;
2590 c1 c2 c3 c4
2591 SELECT * FROM t1 WHERE c1 IS NULL ORDER BY c1,c2 DESC LIMIT 2;
2592 c1 c2 c3 c4
2593 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC;
2594 c1 c2 c3 c4
2595 0.00000 0.00000 0 7
2596 0.00000 -0.10000 -0.1 13
2597 1.00000 1.00000 1 10
2598 100.05000 -100.05000 100.05 1
2599 12345.00001 NULL NULL NULL
2600 99999.99999 99999.99999 111111111.11 19
2601 99999.99999 -99999.99999 100000.000002 5
2602 SELECT * FROM t1 WHERE c1 IS NOT NULL ORDER BY c1,c2 DESC LIMIT 2;
2603 c1 c2 c3 c4
2604 0.00000 0.00000 0 7
2605 0.00000 -0.10000 -0.1 13
2606 SELECT * FROM t1;
2607 c1 c2 c3 c4
2608 0.00000 -0.10000 -0.1 13
2609 0.00000 0.00000 0 7
2610 1.00000 1.00000 1 10
2611 100.05000 -100.05000 100.05 1
2612 12345.00001 NULL NULL NULL
2613 99999.99999 -99999.99999 100000.000002 5
2614 99999.99999 99999.99999 111111111.11 19
2615 SELECT count(*) as total_rows, min(c2) as min_value, max(c2) FROM t1;
2616 total_rows min_value max(c2)
2617 7 -99999.99999 99999.99999
2618 SELECT * FROM t1 WHERE c3 = '-0.0';
2619 c1 c2 c3 c4
2620 0.00000 0.00000 0 7
2621 SELECT c1,c2 FROM t1;
2622 c1 c2
2623 0.00000 -0.10000
2624 0.00000 0.00000
2625 1.00000 1.00000
2626 100.05000 -100.05000
2627 12345.00001 NULL
2628 99999.99999 -99999.99999
2629 99999.99999 99999.99999
2630 SELECT c1,c2 FROM t1 ORDER BY c1,c2 DESC;
2631 c1 c2
2632 0.00000 0.00000
2633 0.00000 -0.10000
2634 1.00000 1.00000
2635 100.05000 -100.05000
2636 12345.00001 NULL
2637 99999.99999 99999.99999
2638 99999.99999 -99999.99999
2639 SELECT * FROM t1 ORDER BY c1,c2 LIMIT 2;
2640 c1 c2 c3 c4
2641 0.00000 -0.10000 -0.1 13
2642 0.00000 0.00000 0 7
2643 SELECT * FROM t1 ORDER BY c1,c2 DESC LIMIT 2;
2644 c1 c2 c3 c4
2645 0.00000 0.00000 0 7
2646 0.00000 -0.10000 -0.1 13
2647 SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2;
2648 c1 c2 c3 c4
2649 99999.99999 -99999.99999 100000.000002 5
2650 SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2 LIMIT 2;
2651 c1 c2 c3 c4
2652 99999.99999 -99999.99999 100000.000002 5
2653 SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2 DESC;
2654 c1 c2 c3 c4
2655 99999.99999 -99999.99999 100000.000002 5
2656 SELECT * FROM t1 WHERE c2 = '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
2657 c1 c2 c3 c4
2658 99999.99999 -99999.99999 100000.000002 5
2659 SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2;
2660 c1 c2 c3 c4
2661 0.00000 -0.10000 -0.1 13
2662 0.00000 0.00000 0 7
2663 1.00000 1.00000 1 10
2664 100.05000 -100.05000 100.05 1
2665 99999.99999 99999.99999 111111111.11 19
2666 SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2 LIMIT 2;
2667 c1 c2 c3 c4
2668 0.00000 -0.10000 -0.1 13
2669 0.00000 0.00000 0 7
2670 SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2;
2671 c1 c2 c3 c4
2672 0.00000 -0.10000 -0.1 13
2673 0.00000 0.00000 0 7
2674 1.00000 1.00000 1 10
2675 100.05000 -100.05000 100.05 1
2676 99999.99999 99999.99999 111111111.11 19
2677 SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2 LIMIT 2;
2678 c1 c2 c3 c4
2679 0.00000 -0.10000 -0.1 13
2680 0.00000 0.00000 0 7
2681 SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2;
2682 c1 c2 c3 c4
2683 0.00000 -0.10000 -0.1 13
2684 0.00000 0.00000 0 7
2685 1.00000 1.00000 1 10
2686 100.05000 -100.05000 100.05 1
2687 99999.99999 -99999.99999 100000.000002 5
2688 99999.99999 99999.99999 111111111.11 19
2689 SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2 LIMIT 2;
2690 c1 c2 c3 c4
2691 0.00000 -0.10000 -0.1 13
2692 0.00000 0.00000 0 7
2693 SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2;
2694 c1 c2 c3 c4
2695 SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2 LIMIT 2;
2696 c1 c2 c3 c4
2697 SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2;
2698 c1 c2 c3 c4
2699 99999.99999 -99999.99999 100000.000002 5
2700 SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2 LIMIT 2;
2701 c1 c2 c3 c4
2702 99999.99999 -99999.99999 100000.000002 5
2703 SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2;
2704 c1 c2 c3 c4
2705 99999.99999 -99999.99999 100000.000002 5
2706 SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2 LIMIT 2;
2707 c1 c2 c3 c4
2708 99999.99999 -99999.99999 100000.000002 5
2709 SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2;
2710 c1 c2 c3 c4
2711 0.00000 -0.10000 -0.1 13
2712 0.00000 0.00000 0 7
2713 100.05000 -100.05000 100.05 1
2714 99999.99999 -99999.99999 100000.000002 5
2715 SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2 LIMIT 2;
2716 c1 c2 c3 c4
2717 0.00000 -0.10000 -0.1 13
2718 0.00000 0.00000 0 7
2719 SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2;
2720 c1 c2 c3 c4
2721 0.00000 0.00000 0 7
2722 99999.99999 -99999.99999 100000.000002 5
2723 SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2 LIMIT 2;
2724 c1 c2 c3 c4
2725 0.00000 0.00000 0 7
2726 99999.99999 -99999.99999 100000.000002 5
2727 SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2;
2728 c1 c2 c3 c4
2729 99999.99999 -99999.99999 100000.000002 5
2730 SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2 LIMIT 2;
2731 c1 c2 c3 c4
2732 99999.99999 -99999.99999 100000.000002 5
2733 SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2;
2734 c1 c2 c3 c4
2735 12345.00001 NULL NULL NULL
2736 SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2 LIMIT 2;
2737 c1 c2 c3 c4
2738 12345.00001 NULL NULL NULL
2739 SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2;
2740 c1 c2 c3 c4
2741 0.00000 -0.10000 -0.1 13
2742 0.00000 0.00000 0 7
2743 1.00000 1.00000 1 10
2744 100.05000 -100.05000 100.05 1
2745 99999.99999 -99999.99999 100000.000002 5
2746 99999.99999 99999.99999 111111111.11 19
2747 SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2 LIMIT 2;
2748 c1 c2 c3 c4
2749 0.00000 -0.10000 -0.1 13
2750 0.00000 0.00000 0 7
2751 SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2 DESC;
2752 c1 c2 c3 c4
2753 0.00000 0.00000 0 7
2754 0.00000 -0.10000 -0.1 13
2755 1.00000 1.00000 1 10
2756 100.05000 -100.05000 100.05 1
2757 99999.99999 99999.99999 111111111.11 19
2758 SELECT * FROM t1 WHERE c2 <> '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
2759 c1 c2 c3 c4
2760 0.00000 0.00000 0 7
2761 0.00000 -0.10000 -0.1 13
2762 SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2 DESC;
2763 c1 c2 c3 c4
2764 0.00000 0.00000 0 7
2765 0.00000 -0.10000 -0.1 13
2766 1.00000 1.00000 1 10
2767 100.05000 -100.05000 100.05 1
2768 99999.99999 99999.99999 111111111.11 19
2769 SELECT * FROM t1 WHERE c2 > '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
2770 c1 c2 c3 c4
2771 0.00000 0.00000 0 7
2772 0.00000 -0.10000 -0.1 13
2773 SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2 DESC;
2774 c1 c2 c3 c4
2775 0.00000 0.00000 0 7
2776 0.00000 -0.10000 -0.1 13
2777 1.00000 1.00000 1 10
2778 100.05000 -100.05000 100.05 1
2779 99999.99999 99999.99999 111111111.11 19
2780 99999.99999 -99999.99999 100000.000002 5
2781 SELECT * FROM t1 WHERE c2 >= '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
2782 c1 c2 c3 c4
2783 0.00000 0.00000 0 7
2784 0.00000 -0.10000 -0.1 13
2785 SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2 DESC;
2786 c1 c2 c3 c4
2787 SELECT * FROM t1 WHERE c2 < '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
2788 c1 c2 c3 c4
2789 SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2 DESC;
2790 c1 c2 c3 c4
2791 99999.99999 -99999.99999 100000.000002 5
2792 SELECT * FROM t1 WHERE c2 <= '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
2793 c1 c2 c3 c4
2794 99999.99999 -99999.99999 100000.000002 5
2795 SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2 DESC;
2796 c1 c2 c3 c4
2797 99999.99999 -99999.99999 100000.000002 5
2798 SELECT * FROM t1 WHERE c2 <=> '-99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
2799 c1 c2 c3 c4
2800 99999.99999 -99999.99999 100000.000002 5
2801 SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2 DESC;
2802 c1 c2 c3 c4
2803 0.00000 0.00000 0 7
2804 0.00000 -0.10000 -0.1 13
2805 100.05000 -100.05000 100.05 1
2806 99999.99999 -99999.99999 100000.000002 5
2807 SELECT * FROM t1 WHERE c2 BETWEEN '-99999.99999' AND '0.0' ORDER BY c1,c2 DESC LIMIT 2;
2808 c1 c2 c3 c4
2809 0.00000 0.00000 0 7
2810 0.00000 -0.10000 -0.1 13
2811 SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2 DESC;
2812 c1 c2 c3 c4
2813 0.00000 0.00000 0 7
2814 99999.99999 -99999.99999 100000.000002 5
2815 SELECT * FROM t1 WHERE c2 IN ('-99999.99999','0.0') ORDER BY c1,c2 DESC LIMIT 2;
2816 c1 c2 c3 c4
2817 0.00000 0.00000 0 7
2818 99999.99999 -99999.99999 100000.000002 5
2819 SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2 DESC;
2820 c1 c2 c3 c4
2821 99999.99999 -99999.99999 100000.000002 5
2822 SELECT * FROM t1 WHERE c2 >= '-99999.99999' AND c2 < '0.0' AND c1 = '99999.99999' ORDER BY c1,c2 DESC LIMIT 2;
2823 c1 c2 c3 c4
2824 99999.99999 -99999.99999 100000.000002 5
2825 SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2 DESC;
2826 c1 c2 c3 c4
2827 12345.00001 NULL NULL NULL
2828 SELECT * FROM t1 WHERE c2 IS NULL ORDER BY c1,c2 DESC LIMIT 2;
2829 c1 c2 c3 c4
2830 12345.00001 NULL NULL NULL
2831 SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2 DESC;
2832 c1 c2 c3 c4
2833 0.00000 0.00000 0 7
2834 0.00000 -0.10000 -0.1 13
2835 1.00000 1.00000 1 10
2836 100.05000 -100.05000 100.05 1
2837 99999.99999 99999.99999 111111111.11 19
2838 99999.99999 -99999.99999 100000.000002 5
2839 SELECT * FROM t1 WHERE c2 IS NOT NULL ORDER BY c1,c2 DESC LIMIT 2;
2840 c1 c2 c3 c4
2841 0.00000 0.00000 0 7
2842 0.00000 -0.10000 -0.1 13
2843 SELECT c1 FROM t1 GROUP BY c1;
2844 c1
2845 0.00000
2846 1.00000
2847 100.05000
2848 12345.00001
2849 99999.99999
2850 SELECT DISTINCT c1 FROM t1;
2851 c1
2852 0.00000
2853 1.00000
2854 100.05000
2855 12345.00001
2856 99999.99999
2857 SELECT c1,MIN(c2) FROM t1 GROUP BY c1;
2858 c1 MIN(c2)
2859 0.00000 -0.10000
2860 1.00000 1.00000
2861 100.05000 -100.05000
2862 12345.00001 NULL
2863 99999.99999 -99999.99999
2864 CREATE TABLE t5(c1 DOUBLE(23,0) UNSIGNED NOT NULL, c2 DOUBLE(23,0) SIGNED NULL, c3 DOUBLE, c4 INT, INDEX idx(c1,c2));
2865 Warnings:
2866 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
2867 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
2868 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
2869 INSERT INTO t5 VALUES('1e+22','-1e+22','1e+22',1),('1e-22','-1e-22','1e-22',2);
2870 SELECT * FROM t5;
2871 c1 c2 c3 c4
2872 0 0 1e-22 2
2873 10000000000000000000000 -10000000000000000000000 1e22 1
2874 ALTER TABLE t5 CHANGE c1 c1 DOUBLE(24,0) SIGNED NOT NULL, CHANGE c2 c2 DOUBLE(24,0) UNSIGNED NULL;
2875 Warnings:
2876 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
2877 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
2878 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
2879 Warning 1264 Out of range value for column 'c2' at row 1
2880 INSERT INTO t5 VALUES('-1e+23','1e+23','1e+23',3),('-1e-23','1e-23','1e-23',4);
2881 SELECT * FROM t5;
2882 ALTER TABLE t5 CHANGE c1 c1 DOUBLE(53,0) UNSIGNED, CHANGE c2 c2 DOUBLE(53,0) SIGNED;
2883 Warnings:
2884 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
2885 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
2886 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
2887 Warning 1264 Out of range value for column 'c1' at row 3
2888 INSERT INTO t5 VALUES('1e+52','-1e+52','1e+52',5),('1e-52','-1e-52','1e-52',6);
2889 INSERT INTO t5 VALUES('1e+53','-1e+53','1e+53',7),('1e-53','-1e-53','1e-53',8);
2890 SELECT * FROM t5;
2891 DROP TABLE t5;
2892 CREATE TABLE t5(c1 DOUBLE(16,6), c2 tinyint);
2893 Warnings:
2894 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
2895 INSERT INTO t5 VALUES(1.1325,3);
2896 SELECT ROUND(c1,c2),TRUNCATE(c1,c2) FROM t5;
2897 ROUND(c1,c2) TRUNCATE(c1,c2)
2898 1.132 1.132
2899 DROP TABLE t5;
2900 CREATE TABLE t7(c1 DOUBLE(5,10));
2901 ERROR 42000: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'c1').
2902 DROP TABLE t1,t2;
2903 SET sql_mode=default;