Debian Codegraph @

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

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