Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(391)

Side by Side Diff: third_party/sqlite/sqlite-src-3100200/test/misc5.test

Issue 2846743003: [sql] Remove SQLite 3.10.2 reference directory. (Closed)
Patch Set: Created 3 years, 7 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View unified diff | Download patch
OLDNEW
(Empty)
1 # 2005 Mar 16
2 #
3 # The author disclaims copyright to this source code. In place of
4 # a legal notice, here is a blessing:
5 #
6 # May you do good and not evil.
7 # May you find forgiveness for yourself and forgive others.
8 # May you share freely, never taking more than you give.
9 #
10 #***********************************************************************
11 # This file implements regression tests for SQLite library.
12 #
13 # This file implements tests for miscellanous features that were
14 # left out of other test files.
15 #
16 # $Id: misc5.test,v 1.22 2008/07/29 10:26:45 danielk1977 Exp $
17
18 set testdir [file dirname $argv0]
19 source $testdir/tester.tcl
20
21 # Build records using the MakeRecord opcode such that the size of the
22 # header is at the transition point in the size of a varint.
23 #
24 # This test causes an assertion failure or a buffer overrun in version
25 # 3.1.5 and earlier.
26 #
27 for {set i 120} {$i<140} {incr i} {
28 do_test misc5-1.$i {
29 catchsql {DROP TABLE t1}
30 set sql1 {CREATE TABLE t1}
31 set sql2 {INSERT INTO t1 VALUES}
32 set sep (
33 for {set j 0} {$j<$i} {incr j} {
34 append sql1 ${sep}a$j
35 append sql2 ${sep}$j
36 set sep ,
37 }
38 append sql1 {);}
39 append sql2 {);}
40 execsql $sql1$sql2
41 } {}
42 }
43
44 # Make sure large integers are stored correctly.
45 #
46 ifcapable conflict {
47 do_test misc5-2.1 {
48 execsql {
49 create table t2(x unique);
50 insert into t2 values(1);
51 insert or ignore into t2 select x*2 from t2;
52 insert or ignore into t2 select x*4 from t2;
53 insert or ignore into t2 select x*16 from t2;
54 insert or ignore into t2 select x*256 from t2;
55 insert or ignore into t2 select x*65536 from t2;
56 insert or ignore into t2 select x*2147483648 from t2;
57 insert or ignore into t2 select x-1 from t2;
58 insert or ignore into t2 select x+1 from t2;
59 insert or ignore into t2 select -x from t2;
60 select count(*) from t2;
61 }
62 } 371
63 } else {
64 do_test misc5-2.1 {
65 execsql {
66 BEGIN;
67 create table t2(x unique);
68 create table t2_temp(x);
69 insert into t2_temp values(1);
70 insert into t2_temp select x*2 from t2_temp;
71 insert into t2_temp select x*4 from t2_temp;
72 insert into t2_temp select x*16 from t2_temp;
73 insert into t2_temp select x*256 from t2_temp;
74 insert into t2_temp select x*65536 from t2_temp;
75 insert into t2_temp select x*2147483648 from t2_temp;
76 insert into t2_temp select x-1 from t2_temp;
77 insert into t2_temp select x+1 from t2_temp;
78 insert into t2_temp select -x from t2_temp;
79 INSERT INTO t2 SELECT DISTINCT(x) FROM t2_temp;
80 DROP TABLE t2_temp;
81 COMMIT;
82 select count(*) from t2;
83 }
84 } 371
85 }
86 do_test misc5-2.2 {
87 execsql {
88 select x from t2 order by x;
89 }
90 } \
91 "-4611686018427387905\
92 -4611686018427387904\
93 -4611686018427387903\
94 -2305843009213693953\
95 -2305843009213693952\
96 -2305843009213693951\
97 -1152921504606846977\
98 -1152921504606846976\
99 -1152921504606846975\
100 -576460752303423489\
101 -576460752303423488\
102 -576460752303423487\
103 -288230376151711745\
104 -288230376151711744\
105 -288230376151711743\
106 -144115188075855873\
107 -144115188075855872\
108 -144115188075855871\
109 -72057594037927937\
110 -72057594037927936\
111 -72057594037927935\
112 -36028797018963969\
113 -36028797018963968\
114 -36028797018963967\
115 -18014398509481985\
116 -18014398509481984\
117 -18014398509481983\
118 -9007199254740993\
119 -9007199254740992\
120 -9007199254740991\
121 -4503599627370497\
122 -4503599627370496\
123 -4503599627370495\
124 -2251799813685249\
125 -2251799813685248\
126 -2251799813685247\
127 -1125899906842625\
128 -1125899906842624\
129 -1125899906842623\
130 -562949953421313\
131 -562949953421312\
132 -562949953421311\
133 -281474976710657\
134 -281474976710656\
135 -281474976710655\
136 -140737488355329\
137 -140737488355328\
138 -140737488355327\
139 -70368744177665\
140 -70368744177664\
141 -70368744177663\
142 -35184372088833\
143 -35184372088832\
144 -35184372088831\
145 -17592186044417\
146 -17592186044416\
147 -17592186044415\
148 -8796093022209\
149 -8796093022208\
150 -8796093022207\
151 -4398046511105\
152 -4398046511104\
153 -4398046511103\
154 -2199023255553\
155 -2199023255552\
156 -2199023255551\
157 -1099511627777\
158 -1099511627776\
159 -1099511627775\
160 -549755813889\
161 -549755813888\
162 -549755813887\
163 -274877906945\
164 -274877906944\
165 -274877906943\
166 -137438953473\
167 -137438953472\
168 -137438953471\
169 -68719476737\
170 -68719476736\
171 -68719476735\
172 -34359738369\
173 -34359738368\
174 -34359738367\
175 -17179869185\
176 -17179869184\
177 -17179869183\
178 -8589934593\
179 -8589934592\
180 -8589934591\
181 -4294967297\
182 -4294967296\
183 -4294967295\
184 -2147483649\
185 -2147483648\
186 -2147483647\
187 -1073741825\
188 -1073741824\
189 -1073741823\
190 -536870913\
191 -536870912\
192 -536870911\
193 -268435457\
194 -268435456\
195 -268435455\
196 -134217729\
197 -134217728\
198 -134217727\
199 -67108865\
200 -67108864\
201 -67108863\
202 -33554433\
203 -33554432\
204 -33554431\
205 -16777217\
206 -16777216\
207 -16777215\
208 -8388609\
209 -8388608\
210 -8388607\
211 -4194305\
212 -4194304\
213 -4194303\
214 -2097153\
215 -2097152\
216 -2097151\
217 -1048577\
218 -1048576\
219 -1048575\
220 -524289\
221 -524288\
222 -524287\
223 -262145\
224 -262144\
225 -262143\
226 -131073\
227 -131072\
228 -131071\
229 -65537\
230 -65536\
231 -65535\
232 -32769\
233 -32768\
234 -32767\
235 -16385\
236 -16384\
237 -16383\
238 -8193\
239 -8192\
240 -8191\
241 -4097\
242 -4096\
243 -4095\
244 -2049\
245 -2048\
246 -2047\
247 -1025\
248 -1024\
249 -1023\
250 -513\
251 -512\
252 -511\
253 -257\
254 -256\
255 -255\
256 -129\
257 -128\
258 -127\
259 -65\
260 -64\
261 -63\
262 -33\
263 -32\
264 -31\
265 -17\
266 -16\
267 -15\
268 -9\
269 -8\
270 -7\
271 -5\
272 -4\
273 -3\
274 -2\
275 -1\
276 0\
277 1\
278 2\
279 3\
280 4\
281 5\
282 7\
283 8\
284 9\
285 15\
286 16\
287 17\
288 31\
289 32\
290 33\
291 63\
292 64\
293 65\
294 127\
295 128\
296 129\
297 255\
298 256\
299 257\
300 511\
301 512\
302 513\
303 1023\
304 1024\
305 1025\
306 2047\
307 2048\
308 2049\
309 4095\
310 4096\
311 4097\
312 8191\
313 8192\
314 8193\
315 16383\
316 16384\
317 16385\
318 32767\
319 32768\
320 32769\
321 65535\
322 65536\
323 65537\
324 131071\
325 131072\
326 131073\
327 262143\
328 262144\
329 262145\
330 524287\
331 524288\
332 524289\
333 1048575\
334 1048576\
335 1048577\
336 2097151\
337 2097152\
338 2097153\
339 4194303\
340 4194304\
341 4194305\
342 8388607\
343 8388608\
344 8388609\
345 16777215\
346 16777216\
347 16777217\
348 33554431\
349 33554432\
350 33554433\
351 67108863\
352 67108864\
353 67108865\
354 134217727\
355 134217728\
356 134217729\
357 268435455\
358 268435456\
359 268435457\
360 536870911\
361 536870912\
362 536870913\
363 1073741823\
364 1073741824\
365 1073741825\
366 2147483647\
367 2147483648\
368 2147483649\
369 4294967295\
370 4294967296\
371 4294967297\
372 8589934591\
373 8589934592\
374 8589934593\
375 17179869183\
376 17179869184\
377 17179869185\
378 34359738367\
379 34359738368\
380 34359738369\
381 68719476735\
382 68719476736\
383 68719476737\
384 137438953471\
385 137438953472\
386 137438953473\
387 274877906943\
388 274877906944\
389 274877906945\
390 549755813887\
391 549755813888\
392 549755813889\
393 1099511627775\
394 1099511627776\
395 1099511627777\
396 2199023255551\
397 2199023255552\
398 2199023255553\
399 4398046511103\
400 4398046511104\
401 4398046511105\
402 8796093022207\
403 8796093022208\
404 8796093022209\
405 17592186044415\
406 17592186044416\
407 17592186044417\
408 35184372088831\
409 35184372088832\
410 35184372088833\
411 70368744177663\
412 70368744177664\
413 70368744177665\
414 140737488355327\
415 140737488355328\
416 140737488355329\
417 281474976710655\
418 281474976710656\
419 281474976710657\
420 562949953421311\
421 562949953421312\
422 562949953421313\
423 1125899906842623\
424 1125899906842624\
425 1125899906842625\
426 2251799813685247\
427 2251799813685248\
428 2251799813685249\
429 4503599627370495\
430 4503599627370496\
431 4503599627370497\
432 9007199254740991\
433 9007199254740992\
434 9007199254740993\
435 18014398509481983\
436 18014398509481984\
437 18014398509481985\
438 36028797018963967\
439 36028797018963968\
440 36028797018963969\
441 72057594037927935\
442 72057594037927936\
443 72057594037927937\
444 144115188075855871\
445 144115188075855872\
446 144115188075855873\
447 288230376151711743\
448 288230376151711744\
449 288230376151711745\
450 576460752303423487\
451 576460752303423488\
452 576460752303423489\
453 1152921504606846975\
454 1152921504606846976\
455 1152921504606846977\
456 2305843009213693951\
457 2305843009213693952\
458 2305843009213693953\
459 4611686018427387903\
460 4611686018427387904\
461 4611686018427387905"
462
463 # Ticket #1210. Do proper reference counting of Table structures
464 # so that deeply nested SELECT statements can be flattened correctly.
465 #
466 ifcapable subquery {
467 do_test misc5-3.1 {
468 execsql {
469 CREATE TABLE songs(songid, artist, timesplayed);
470 INSERT INTO songs VALUES(1,'one',1);
471 INSERT INTO songs VALUES(2,'one',2);
472 INSERT INTO songs VALUES(3,'two',3);
473 INSERT INTO songs VALUES(4,'three',5);
474 INSERT INTO songs VALUES(5,'one',7);
475 INSERT INTO songs VALUES(6,'two',11);
476 SELECT DISTINCT artist
477 FROM (
478 SELECT DISTINCT artist
479 FROM songs
480 WHERE songid IN (
481 SELECT songid
482 FROM songs
483 WHERE LOWER(artist) = (
484 -- This sub-query is indeterminate. Because there is no ORDER BY,
485 -- it may return 'one', 'two' or 'three'. Because of this, the
486 -- outermost parent query may correctly return any of 'one', 'two'
487 -- or 'three' as well.
488 SELECT DISTINCT LOWER(artist)
489 FROM (
490 -- This sub-query returns the table:
491 --
492 -- two 14
493 -- one 10
494 -- three 5
495 --
496 SELECT DISTINCT artist,sum(timesplayed) AS total
497 FROM songs
498 GROUP BY LOWER(artist)
499 ORDER BY total DESC
500 LIMIT 10
501 )
502 WHERE artist <> ''
503 )
504 )
505 )
506 ORDER BY LOWER(artist) ASC;
507 }
508 } {two}
509 }
510
511 # Ticket #1370. Do not overwrite small files (less than 1024 bytes)
512 # when trying to open them as a database.
513 #
514 if {[permutation] == ""} {
515 do_test misc5-4.1 {
516 db close
517 forcedelete test.db
518 set fd [open test.db w]
519 puts $fd "This is not really a database"
520 close $fd
521 sqlite3 db test.db
522 catchsql {
523 CREATE TABLE t1(a,b,c);
524 }
525 } {1 {file is encrypted or is not a database}}
526 }
527
528 # Ticket #1371. Allow floating point numbers of the form .N or N.
529 #
530 do_test misc5-5.1 {
531 execsql {SELECT .1 }
532 } 0.1
533 do_test misc5-5.2 {
534 execsql {SELECT 2. }
535 } 2.0
536 do_test misc5-5.3 {
537 execsql {SELECT 3.e0 }
538 } 3.0
539 do_test misc5-5.4 {
540 execsql {SELECT .4e+1}
541 } 4.0
542
543 # Ticket #1582. Ensure that an unknown table in a LIMIT clause applied to
544 # a UNION ALL query causes an error, not a crash.
545 #
546 db close
547 forcedelete test.db
548 sqlite3 db test.db
549 ifcapable subquery&&compound {
550 do_test misc5-6.1 {
551 catchsql {
552 SELECT * FROM sqlite_master
553 UNION ALL
554 SELECT * FROM sqlite_master
555 LIMIT (SELECT count(*) FROM blah);
556 }
557 } {1 {no such table: blah}}
558 do_test misc5-6.2 {
559 execsql {
560 CREATE TABLE logs(msg TEXT, timestamp INTEGER, dbtime TEXT);
561 }
562 catchsql {
563 SELECT * FROM logs WHERE logs.oid >= (SELECT head FROM logs_base)
564 UNION ALL
565 SELECT * FROM logs
566 LIMIT (SELECT lmt FROM logs_base) ;
567 }
568 } {1 {no such table: logs_base}}
569 }
570
571 # Overflow the lemon parser stack by providing an overly complex
572 # expression. Make sure that the overflow is detected and reported.
573 #
574 do_test misc5-7.1 {
575 execsql {CREATE TABLE t1(x)}
576 set sql "INSERT INTO t1 VALUES("
577 set tail ""
578 for {set i 0} {$i<200} {incr i} {
579 append sql "(1+"
580 append tail ")"
581 }
582 append sql 2$tail
583 catchsql $sql
584 } {1 {parser stack overflow}}
585
586 # Parser stack overflow is silently ignored when it occurs while parsing the
587 # schema and PRAGMA writable_schema is turned on.
588 #
589 do_test misc5-7.2 {
590 sqlite3 db2 :memory:
591 catchsql {
592 CREATE TABLE t1(x UNIQUE);
593 PRAGMA writable_schema=ON;
594 UPDATE sqlite_master SET sql='CREATE table t(o CHECK(((((((((((((((((((((((( (((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((;VALUES(o)' ;
595 BEGIN;
596 CREATE TABLE t2(y);
597 ROLLBACK;
598 DROP TABLE IF EXISTS D;
599 } db2
600 } {0 {}}
601 db2 close
602
603
604 # Ticket #1911
605 #
606 ifcapable compound {
607 do_test misc5-9.1 {
608 execsql {
609 SELECT name, type FROM sqlite_master WHERE name IS NULL
610 UNION
611 SELECT type, name FROM sqlite_master WHERE type IS NULL
612 ORDER BY 1, 2, 1, 2, 1, 2
613 }
614 } {}
615 do_test misc5-9.2 {
616 execsql {
617 SELECT name, type FROM sqlite_master WHERE name IS NULL
618 UNION
619 SELECT type, name FROM sqlite_master WHERE type IS NULL
620 ORDER BY 1, 2, 1, 2, 1, 2, 1, 2, 1, 2, 1, 2, 1, 2, 1, 2, 1, 2
621 }
622 } {}
623 }
624
625 # Ticket #1912. Make the tokenizer require a space after a numeric
626 # literal.
627 #
628 do_test misc5-10.1 {
629 catchsql {
630 SELECT 123abc
631 }
632 } {1 {unrecognized token: "123abc"}}
633 do_test misc5-10.2 {
634 catchsql {
635 SELECT 1*123.4e5ghi;
636 }
637 } {1 {unrecognized token: "123.4e5ghi"}}
638
639
640 # Additional integer encoding tests.
641 #
642 do_test misc5-11.1 {
643 db eval {
644 CREATE TABLE t3(x);
645 INSERT INTO t3 VALUES(-18);
646 INSERT INTO t3 VALUES(-17);
647 INSERT INTO t3 VALUES(-16);
648 INSERT INTO t3 VALUES(-15);
649 INSERT INTO t3 VALUES(-14);
650 INSERT INTO t3 VALUES(-13);
651 INSERT INTO t3 VALUES(-12);
652 INSERT INTO t3 VALUES(-11);
653 INSERT INTO t3 VALUES(-10);
654 INSERT INTO t3 VALUES(-9);
655 INSERT INTO t3 VALUES(-8);
656 INSERT INTO t3 VALUES(-7);
657 INSERT INTO t3 VALUES(-6);
658 INSERT INTO t3 VALUES(-5);
659 INSERT INTO t3 VALUES(-4);
660 INSERT INTO t3 VALUES(-3);
661 INSERT INTO t3 VALUES(-2);
662 INSERT INTO t3 VALUES(-1);
663 INSERT INTO t3 VALUES(0);
664 INSERT INTO t3 VALUES(1);
665 INSERT INTO t3 VALUES(2);
666 INSERT INTO t3 VALUES(3);
667 INSERT INTO t3 VALUES(4);
668 INSERT INTO t3 VALUES(5);
669 INSERT INTO t3 VALUES(6);
670 INSERT INTO t3 VALUES(7);
671 INSERT INTO t3 VALUES(8);
672 INSERT INTO t3 VALUES(9);
673 INSERT INTO t3 VALUES(10);
674 INSERT INTO t3 VALUES(11);
675 INSERT INTO t3 VALUES(12);
676 INSERT INTO t3 VALUES(13);
677 INSERT INTO t3 VALUES(14);
678 INSERT INTO t3 VALUES(15);
679 INSERT INTO t3 VALUES(16);
680 INSERT INTO t3 VALUES(17);
681 INSERT INTO t3 VALUES(18);
682 INSERT INTO t3 VALUES(30);
683 INSERT INTO t3 VALUES(31);
684 INSERT INTO t3 VALUES(32);
685 INSERT INTO t3 VALUES(33);
686 INSERT INTO t3 VALUES(34);
687 INSERT INTO t3 VALUES(-30);
688 INSERT INTO t3 VALUES(-31);
689 INSERT INTO t3 VALUES(-32);
690 INSERT INTO t3 VALUES(-33);
691 INSERT INTO t3 VALUES(-34);
692 INSERT INTO t3 VALUES(62);
693 INSERT INTO t3 VALUES(63);
694 INSERT INTO t3 VALUES(64);
695 INSERT INTO t3 VALUES(65);
696 INSERT INTO t3 VALUES(66);
697 INSERT INTO t3 VALUES(-62);
698 INSERT INTO t3 VALUES(-63);
699 INSERT INTO t3 VALUES(-64);
700 INSERT INTO t3 VALUES(-65);
701 INSERT INTO t3 VALUES(-66);
702 INSERT INTO t3 VALUES(126);
703 INSERT INTO t3 VALUES(127);
704 INSERT INTO t3 VALUES(128);
705 INSERT INTO t3 VALUES(129);
706 INSERT INTO t3 VALUES(130);
707 INSERT INTO t3 VALUES(-126);
708 INSERT INTO t3 VALUES(-127);
709 INSERT INTO t3 VALUES(-128);
710 INSERT INTO t3 VALUES(-129);
711 INSERT INTO t3 VALUES(-130);
712 INSERT INTO t3 VALUES(254);
713 INSERT INTO t3 VALUES(255);
714 INSERT INTO t3 VALUES(256);
715 INSERT INTO t3 VALUES(257);
716 INSERT INTO t3 VALUES(258);
717 INSERT INTO t3 VALUES(-254);
718 INSERT INTO t3 VALUES(-255);
719 INSERT INTO t3 VALUES(-256);
720 INSERT INTO t3 VALUES(-257);
721 INSERT INTO t3 VALUES(-258);
722 INSERT INTO t3 VALUES(510);
723 INSERT INTO t3 VALUES(511);
724 INSERT INTO t3 VALUES(512);
725 INSERT INTO t3 VALUES(513);
726 INSERT INTO t3 VALUES(514);
727 INSERT INTO t3 VALUES(-510);
728 INSERT INTO t3 VALUES(-511);
729 INSERT INTO t3 VALUES(-512);
730 INSERT INTO t3 VALUES(-513);
731 INSERT INTO t3 VALUES(-514);
732 INSERT INTO t3 VALUES(1022);
733 INSERT INTO t3 VALUES(1023);
734 INSERT INTO t3 VALUES(1024);
735 INSERT INTO t3 VALUES(1025);
736 INSERT INTO t3 VALUES(1026);
737 INSERT INTO t3 VALUES(-1022);
738 INSERT INTO t3 VALUES(-1023);
739 INSERT INTO t3 VALUES(-1024);
740 INSERT INTO t3 VALUES(-1025);
741 INSERT INTO t3 VALUES(-1026);
742 INSERT INTO t3 VALUES(2046);
743 INSERT INTO t3 VALUES(2047);
744 INSERT INTO t3 VALUES(2048);
745 INSERT INTO t3 VALUES(2049);
746 INSERT INTO t3 VALUES(2050);
747 INSERT INTO t3 VALUES(-2046);
748 INSERT INTO t3 VALUES(-2047);
749 INSERT INTO t3 VALUES(-2048);
750 INSERT INTO t3 VALUES(-2049);
751 INSERT INTO t3 VALUES(-2050);
752 INSERT INTO t3 VALUES(4094);
753 INSERT INTO t3 VALUES(4095);
754 INSERT INTO t3 VALUES(4096);
755 INSERT INTO t3 VALUES(4097);
756 INSERT INTO t3 VALUES(4098);
757 INSERT INTO t3 VALUES(-4094);
758 INSERT INTO t3 VALUES(-4095);
759 INSERT INTO t3 VALUES(-4096);
760 INSERT INTO t3 VALUES(-4097);
761 INSERT INTO t3 VALUES(-4098);
762 INSERT INTO t3 VALUES(8190);
763 INSERT INTO t3 VALUES(8191);
764 INSERT INTO t3 VALUES(8192);
765 INSERT INTO t3 VALUES(8193);
766 INSERT INTO t3 VALUES(8194);
767 INSERT INTO t3 VALUES(-8190);
768 INSERT INTO t3 VALUES(-8191);
769 INSERT INTO t3 VALUES(-8192);
770 INSERT INTO t3 VALUES(-8193);
771 INSERT INTO t3 VALUES(-8194);
772 INSERT INTO t3 VALUES(16382);
773 INSERT INTO t3 VALUES(16383);
774 INSERT INTO t3 VALUES(16384);
775 INSERT INTO t3 VALUES(16385);
776 INSERT INTO t3 VALUES(16386);
777 INSERT INTO t3 VALUES(-16382);
778 INSERT INTO t3 VALUES(-16383);
779 INSERT INTO t3 VALUES(-16384);
780 INSERT INTO t3 VALUES(-16385);
781 INSERT INTO t3 VALUES(-16386);
782 INSERT INTO t3 VALUES(32766);
783 INSERT INTO t3 VALUES(32767);
784 INSERT INTO t3 VALUES(32768);
785 INSERT INTO t3 VALUES(32769);
786 INSERT INTO t3 VALUES(32770);
787 INSERT INTO t3 VALUES(-32766);
788 INSERT INTO t3 VALUES(-32767);
789 INSERT INTO t3 VALUES(-32768);
790 INSERT INTO t3 VALUES(-32769);
791 INSERT INTO t3 VALUES(-32770);
792 INSERT INTO t3 VALUES(65534);
793 INSERT INTO t3 VALUES(65535);
794 INSERT INTO t3 VALUES(65536);
795 INSERT INTO t3 VALUES(65537);
796 INSERT INTO t3 VALUES(65538);
797 INSERT INTO t3 VALUES(-65534);
798 INSERT INTO t3 VALUES(-65535);
799 INSERT INTO t3 VALUES(-65536);
800 INSERT INTO t3 VALUES(-65537);
801 INSERT INTO t3 VALUES(-65538);
802 INSERT INTO t3 VALUES(131070);
803 INSERT INTO t3 VALUES(131071);
804 INSERT INTO t3 VALUES(131072);
805 INSERT INTO t3 VALUES(131073);
806 INSERT INTO t3 VALUES(131074);
807 INSERT INTO t3 VALUES(-131070);
808 INSERT INTO t3 VALUES(-131071);
809 INSERT INTO t3 VALUES(-131072);
810 INSERT INTO t3 VALUES(-131073);
811 INSERT INTO t3 VALUES(-131074);
812 INSERT INTO t3 VALUES(262142);
813 INSERT INTO t3 VALUES(262143);
814 INSERT INTO t3 VALUES(262144);
815 INSERT INTO t3 VALUES(262145);
816 INSERT INTO t3 VALUES(262146);
817 INSERT INTO t3 VALUES(-262142);
818 INSERT INTO t3 VALUES(-262143);
819 INSERT INTO t3 VALUES(-262144);
820 INSERT INTO t3 VALUES(-262145);
821 INSERT INTO t3 VALUES(-262146);
822 INSERT INTO t3 VALUES(524286);
823 INSERT INTO t3 VALUES(524287);
824 INSERT INTO t3 VALUES(524288);
825 INSERT INTO t3 VALUES(524289);
826 INSERT INTO t3 VALUES(524290);
827 INSERT INTO t3 VALUES(-524286);
828 INSERT INTO t3 VALUES(-524287);
829 INSERT INTO t3 VALUES(-524288);
830 INSERT INTO t3 VALUES(-524289);
831 INSERT INTO t3 VALUES(-524290);
832 INSERT INTO t3 VALUES(1048574);
833 INSERT INTO t3 VALUES(1048575);
834 INSERT INTO t3 VALUES(1048576);
835 INSERT INTO t3 VALUES(1048577);
836 INSERT INTO t3 VALUES(1048578);
837 INSERT INTO t3 VALUES(-1048574);
838 INSERT INTO t3 VALUES(-1048575);
839 INSERT INTO t3 VALUES(-1048576);
840 INSERT INTO t3 VALUES(-1048577);
841 INSERT INTO t3 VALUES(-1048578);
842 INSERT INTO t3 VALUES(2097150);
843 INSERT INTO t3 VALUES(2097151);
844 INSERT INTO t3 VALUES(2097152);
845 INSERT INTO t3 VALUES(2097153);
846 INSERT INTO t3 VALUES(2097154);
847 INSERT INTO t3 VALUES(-2097150);
848 INSERT INTO t3 VALUES(-2097151);
849 INSERT INTO t3 VALUES(-2097152);
850 INSERT INTO t3 VALUES(-2097153);
851 INSERT INTO t3 VALUES(-2097154);
852 INSERT INTO t3 VALUES(4194302);
853 INSERT INTO t3 VALUES(4194303);
854 INSERT INTO t3 VALUES(4194304);
855 INSERT INTO t3 VALUES(4194305);
856 INSERT INTO t3 VALUES(4194306);
857 INSERT INTO t3 VALUES(-4194302);
858 INSERT INTO t3 VALUES(-4194303);
859 INSERT INTO t3 VALUES(-4194304);
860 INSERT INTO t3 VALUES(-4194305);
861 INSERT INTO t3 VALUES(-4194306);
862 INSERT INTO t3 VALUES(8388606);
863 INSERT INTO t3 VALUES(8388607);
864 INSERT INTO t3 VALUES(8388608);
865 INSERT INTO t3 VALUES(8388609);
866 INSERT INTO t3 VALUES(8388610);
867 INSERT INTO t3 VALUES(-8388606);
868 INSERT INTO t3 VALUES(-8388607);
869 INSERT INTO t3 VALUES(-8388608);
870 INSERT INTO t3 VALUES(-8388609);
871 INSERT INTO t3 VALUES(-8388610);
872 INSERT INTO t3 VALUES(16777214);
873 INSERT INTO t3 VALUES(16777215);
874 INSERT INTO t3 VALUES(16777216);
875 INSERT INTO t3 VALUES(16777217);
876 INSERT INTO t3 VALUES(16777218);
877 INSERT INTO t3 VALUES(-16777214);
878 INSERT INTO t3 VALUES(-16777215);
879 INSERT INTO t3 VALUES(-16777216);
880 INSERT INTO t3 VALUES(-16777217);
881 INSERT INTO t3 VALUES(-16777218);
882 INSERT INTO t3 VALUES(33554430);
883 INSERT INTO t3 VALUES(33554431);
884 INSERT INTO t3 VALUES(33554432);
885 INSERT INTO t3 VALUES(33554433);
886 INSERT INTO t3 VALUES(33554434);
887 INSERT INTO t3 VALUES(-33554430);
888 INSERT INTO t3 VALUES(-33554431);
889 INSERT INTO t3 VALUES(-33554432);
890 INSERT INTO t3 VALUES(-33554433);
891 INSERT INTO t3 VALUES(-33554434);
892 INSERT INTO t3 VALUES(67108862);
893 INSERT INTO t3 VALUES(67108863);
894 INSERT INTO t3 VALUES(67108864);
895 INSERT INTO t3 VALUES(67108865);
896 INSERT INTO t3 VALUES(67108866);
897 INSERT INTO t3 VALUES(-67108862);
898 INSERT INTO t3 VALUES(-67108863);
899 INSERT INTO t3 VALUES(-67108864);
900 INSERT INTO t3 VALUES(-67108865);
901 INSERT INTO t3 VALUES(-67108866);
902 INSERT INTO t3 VALUES(134217726);
903 INSERT INTO t3 VALUES(134217727);
904 INSERT INTO t3 VALUES(134217728);
905 INSERT INTO t3 VALUES(134217729);
906 INSERT INTO t3 VALUES(134217730);
907 INSERT INTO t3 VALUES(-134217726);
908 INSERT INTO t3 VALUES(-134217727);
909 INSERT INTO t3 VALUES(-134217728);
910 INSERT INTO t3 VALUES(-134217729);
911 INSERT INTO t3 VALUES(-134217730);
912 INSERT INTO t3 VALUES(268435454);
913 INSERT INTO t3 VALUES(268435455);
914 INSERT INTO t3 VALUES(268435456);
915 INSERT INTO t3 VALUES(268435457);
916 INSERT INTO t3 VALUES(268435458);
917 INSERT INTO t3 VALUES(-268435454);
918 INSERT INTO t3 VALUES(-268435455);
919 INSERT INTO t3 VALUES(-268435456);
920 INSERT INTO t3 VALUES(-268435457);
921 INSERT INTO t3 VALUES(-268435458);
922 INSERT INTO t3 VALUES(536870910);
923 INSERT INTO t3 VALUES(536870911);
924 INSERT INTO t3 VALUES(536870912);
925 INSERT INTO t3 VALUES(536870913);
926 INSERT INTO t3 VALUES(536870914);
927 INSERT INTO t3 VALUES(-536870910);
928 INSERT INTO t3 VALUES(-536870911);
929 INSERT INTO t3 VALUES(-536870912);
930 INSERT INTO t3 VALUES(-536870913);
931 INSERT INTO t3 VALUES(-536870914);
932 INSERT INTO t3 VALUES(1073741822);
933 INSERT INTO t3 VALUES(1073741823);
934 INSERT INTO t3 VALUES(1073741824);
935 INSERT INTO t3 VALUES(1073741825);
936 INSERT INTO t3 VALUES(1073741826);
937 INSERT INTO t3 VALUES(-1073741822);
938 INSERT INTO t3 VALUES(-1073741823);
939 INSERT INTO t3 VALUES(-1073741824);
940 INSERT INTO t3 VALUES(-1073741825);
941 INSERT INTO t3 VALUES(-1073741826);
942 INSERT INTO t3 VALUES(2147483646);
943 INSERT INTO t3 VALUES(2147483647);
944 INSERT INTO t3 VALUES(2147483648);
945 INSERT INTO t3 VALUES(2147483649);
946 INSERT INTO t3 VALUES(2147483650);
947 INSERT INTO t3 VALUES(-2147483646);
948 INSERT INTO t3 VALUES(-2147483647);
949 INSERT INTO t3 VALUES(-2147483648);
950 INSERT INTO t3 VALUES(-2147483649);
951 INSERT INTO t3 VALUES(-2147483650);
952 INSERT INTO t3 VALUES(4294967294);
953 INSERT INTO t3 VALUES(4294967295);
954 INSERT INTO t3 VALUES(4294967296);
955 INSERT INTO t3 VALUES(4294967297);
956 INSERT INTO t3 VALUES(4294967298);
957 INSERT INTO t3 VALUES(-4294967294);
958 INSERT INTO t3 VALUES(-4294967295);
959 INSERT INTO t3 VALUES(-4294967296);
960 INSERT INTO t3 VALUES(-4294967297);
961 INSERT INTO t3 VALUES(-4294967298);
962 INSERT INTO t3 VALUES(8589934590);
963 INSERT INTO t3 VALUES(8589934591);
964 INSERT INTO t3 VALUES(8589934592);
965 INSERT INTO t3 VALUES(8589934593);
966 INSERT INTO t3 VALUES(8589934594);
967 INSERT INTO t3 VALUES(-8589934590);
968 INSERT INTO t3 VALUES(-8589934591);
969 INSERT INTO t3 VALUES(-8589934592);
970 INSERT INTO t3 VALUES(-8589934593);
971 INSERT INTO t3 VALUES(-8589934594);
972 INSERT INTO t3 VALUES(17179869182);
973 INSERT INTO t3 VALUES(17179869183);
974 INSERT INTO t3 VALUES(17179869184);
975 INSERT INTO t3 VALUES(17179869185);
976 INSERT INTO t3 VALUES(17179869186);
977 INSERT INTO t3 VALUES(-17179869182);
978 INSERT INTO t3 VALUES(-17179869183);
979 INSERT INTO t3 VALUES(-17179869184);
980 INSERT INTO t3 VALUES(-17179869185);
981 INSERT INTO t3 VALUES(-17179869186);
982 INSERT INTO t3 VALUES(34359738366);
983 INSERT INTO t3 VALUES(34359738367);
984 INSERT INTO t3 VALUES(34359738368);
985 INSERT INTO t3 VALUES(34359738369);
986 INSERT INTO t3 VALUES(34359738370);
987 INSERT INTO t3 VALUES(-34359738366);
988 INSERT INTO t3 VALUES(-34359738367);
989 INSERT INTO t3 VALUES(-34359738368);
990 INSERT INTO t3 VALUES(-34359738369);
991 INSERT INTO t3 VALUES(-34359738370);
992 INSERT INTO t3 VALUES(68719476734);
993 INSERT INTO t3 VALUES(68719476735);
994 INSERT INTO t3 VALUES(68719476736);
995 INSERT INTO t3 VALUES(68719476737);
996 INSERT INTO t3 VALUES(68719476738);
997 INSERT INTO t3 VALUES(-68719476734);
998 INSERT INTO t3 VALUES(-68719476735);
999 INSERT INTO t3 VALUES(-68719476736);
1000 INSERT INTO t3 VALUES(-68719476737);
1001 INSERT INTO t3 VALUES(-68719476738);
1002 INSERT INTO t3 VALUES(137438953470);
1003 INSERT INTO t3 VALUES(137438953471);
1004 INSERT INTO t3 VALUES(137438953472);
1005 INSERT INTO t3 VALUES(137438953473);
1006 INSERT INTO t3 VALUES(137438953474);
1007 INSERT INTO t3 VALUES(-137438953470);
1008 INSERT INTO t3 VALUES(-137438953471);
1009 INSERT INTO t3 VALUES(-137438953472);
1010 INSERT INTO t3 VALUES(-137438953473);
1011 INSERT INTO t3 VALUES(-137438953474);
1012 INSERT INTO t3 VALUES(274877906942);
1013 INSERT INTO t3 VALUES(274877906943);
1014 INSERT INTO t3 VALUES(274877906944);
1015 INSERT INTO t3 VALUES(274877906945);
1016 INSERT INTO t3 VALUES(274877906946);
1017 INSERT INTO t3 VALUES(-274877906942);
1018 INSERT INTO t3 VALUES(-274877906943);
1019 INSERT INTO t3 VALUES(-274877906944);
1020 INSERT INTO t3 VALUES(-274877906945);
1021 INSERT INTO t3 VALUES(-274877906946);
1022 INSERT INTO t3 VALUES(549755813886);
1023 INSERT INTO t3 VALUES(549755813887);
1024 INSERT INTO t3 VALUES(549755813888);
1025 INSERT INTO t3 VALUES(549755813889);
1026 INSERT INTO t3 VALUES(549755813890);
1027 INSERT INTO t3 VALUES(-549755813886);
1028 INSERT INTO t3 VALUES(-549755813887);
1029 INSERT INTO t3 VALUES(-549755813888);
1030 INSERT INTO t3 VALUES(-549755813889);
1031 INSERT INTO t3 VALUES(-549755813890);
1032 INSERT INTO t3 VALUES(1099511627774);
1033 INSERT INTO t3 VALUES(1099511627775);
1034 INSERT INTO t3 VALUES(1099511627776);
1035 INSERT INTO t3 VALUES(1099511627777);
1036 INSERT INTO t3 VALUES(1099511627778);
1037 INSERT INTO t3 VALUES(-1099511627774);
1038 INSERT INTO t3 VALUES(-1099511627775);
1039 INSERT INTO t3 VALUES(-1099511627776);
1040 INSERT INTO t3 VALUES(-1099511627777);
1041 INSERT INTO t3 VALUES(-1099511627778);
1042 INSERT INTO t3 VALUES(2199023255550);
1043 INSERT INTO t3 VALUES(2199023255551);
1044 INSERT INTO t3 VALUES(2199023255552);
1045 INSERT INTO t3 VALUES(2199023255553);
1046 INSERT INTO t3 VALUES(2199023255554);
1047 INSERT INTO t3 VALUES(-2199023255550);
1048 INSERT INTO t3 VALUES(-2199023255551);
1049 INSERT INTO t3 VALUES(-2199023255552);
1050 INSERT INTO t3 VALUES(-2199023255553);
1051 INSERT INTO t3 VALUES(-2199023255554);
1052 INSERT INTO t3 VALUES(4398046511102);
1053 INSERT INTO t3 VALUES(4398046511103);
1054 INSERT INTO t3 VALUES(4398046511104);
1055 INSERT INTO t3 VALUES(4398046511105);
1056 INSERT INTO t3 VALUES(4398046511106);
1057 INSERT INTO t3 VALUES(-4398046511102);
1058 INSERT INTO t3 VALUES(-4398046511103);
1059 INSERT INTO t3 VALUES(-4398046511104);
1060 INSERT INTO t3 VALUES(-4398046511105);
1061 INSERT INTO t3 VALUES(-4398046511106);
1062 INSERT INTO t3 VALUES(8796093022206);
1063 INSERT INTO t3 VALUES(8796093022207);
1064 INSERT INTO t3 VALUES(8796093022208);
1065 INSERT INTO t3 VALUES(8796093022209);
1066 INSERT INTO t3 VALUES(8796093022210);
1067 INSERT INTO t3 VALUES(-8796093022206);
1068 INSERT INTO t3 VALUES(-8796093022207);
1069 INSERT INTO t3 VALUES(-8796093022208);
1070 INSERT INTO t3 VALUES(-8796093022209);
1071 INSERT INTO t3 VALUES(-8796093022210);
1072 INSERT INTO t3 VALUES(17592186044414);
1073 INSERT INTO t3 VALUES(17592186044415);
1074 INSERT INTO t3 VALUES(17592186044416);
1075 INSERT INTO t3 VALUES(17592186044417);
1076 INSERT INTO t3 VALUES(17592186044418);
1077 INSERT INTO t3 VALUES(-17592186044414);
1078 INSERT INTO t3 VALUES(-17592186044415);
1079 INSERT INTO t3 VALUES(-17592186044416);
1080 INSERT INTO t3 VALUES(-17592186044417);
1081 INSERT INTO t3 VALUES(-17592186044418);
1082 INSERT INTO t3 VALUES(35184372088830);
1083 INSERT INTO t3 VALUES(35184372088831);
1084 INSERT INTO t3 VALUES(35184372088832);
1085 INSERT INTO t3 VALUES(35184372088833);
1086 INSERT INTO t3 VALUES(35184372088834);
1087 INSERT INTO t3 VALUES(-35184372088830);
1088 INSERT INTO t3 VALUES(-35184372088831);
1089 INSERT INTO t3 VALUES(-35184372088832);
1090 INSERT INTO t3 VALUES(-35184372088833);
1091 INSERT INTO t3 VALUES(-35184372088834);
1092 INSERT INTO t3 VALUES(70368744177662);
1093 INSERT INTO t3 VALUES(70368744177663);
1094 INSERT INTO t3 VALUES(70368744177664);
1095 INSERT INTO t3 VALUES(70368744177665);
1096 INSERT INTO t3 VALUES(70368744177666);
1097 INSERT INTO t3 VALUES(-70368744177662);
1098 INSERT INTO t3 VALUES(-70368744177663);
1099 INSERT INTO t3 VALUES(-70368744177664);
1100 INSERT INTO t3 VALUES(-70368744177665);
1101 INSERT INTO t3 VALUES(-70368744177666);
1102 INSERT INTO t3 VALUES(140737488355326);
1103 INSERT INTO t3 VALUES(140737488355327);
1104 INSERT INTO t3 VALUES(140737488355328);
1105 INSERT INTO t3 VALUES(140737488355329);
1106 INSERT INTO t3 VALUES(140737488355330);
1107 INSERT INTO t3 VALUES(-140737488355326);
1108 INSERT INTO t3 VALUES(-140737488355327);
1109 INSERT INTO t3 VALUES(-140737488355328);
1110 INSERT INTO t3 VALUES(-140737488355329);
1111 INSERT INTO t3 VALUES(-140737488355330);
1112 INSERT INTO t3 VALUES(281474976710654);
1113 INSERT INTO t3 VALUES(281474976710655);
1114 INSERT INTO t3 VALUES(281474976710656);
1115 INSERT INTO t3 VALUES(281474976710657);
1116 INSERT INTO t3 VALUES(281474976710658);
1117 INSERT INTO t3 VALUES(-281474976710654);
1118 INSERT INTO t3 VALUES(-281474976710655);
1119 INSERT INTO t3 VALUES(-281474976710656);
1120 INSERT INTO t3 VALUES(-281474976710657);
1121 INSERT INTO t3 VALUES(-281474976710658);
1122 INSERT INTO t3 VALUES(562949953421310);
1123 INSERT INTO t3 VALUES(562949953421311);
1124 INSERT INTO t3 VALUES(562949953421312);
1125 INSERT INTO t3 VALUES(562949953421313);
1126 INSERT INTO t3 VALUES(562949953421314);
1127 INSERT INTO t3 VALUES(-562949953421310);
1128 INSERT INTO t3 VALUES(-562949953421311);
1129 INSERT INTO t3 VALUES(-562949953421312);
1130 INSERT INTO t3 VALUES(-562949953421313);
1131 INSERT INTO t3 VALUES(-562949953421314);
1132 INSERT INTO t3 VALUES(1125899906842622);
1133 INSERT INTO t3 VALUES(1125899906842623);
1134 INSERT INTO t3 VALUES(1125899906842624);
1135 INSERT INTO t3 VALUES(1125899906842625);
1136 INSERT INTO t3 VALUES(1125899906842626);
1137 INSERT INTO t3 VALUES(-1125899906842622);
1138 INSERT INTO t3 VALUES(-1125899906842623);
1139 INSERT INTO t3 VALUES(-1125899906842624);
1140 INSERT INTO t3 VALUES(-1125899906842625);
1141 INSERT INTO t3 VALUES(-1125899906842626);
1142 INSERT INTO t3 VALUES(2251799813685246);
1143 INSERT INTO t3 VALUES(2251799813685247);
1144 INSERT INTO t3 VALUES(2251799813685248);
1145 INSERT INTO t3 VALUES(2251799813685249);
1146 INSERT INTO t3 VALUES(2251799813685250);
1147 INSERT INTO t3 VALUES(-2251799813685246);
1148 INSERT INTO t3 VALUES(-2251799813685247);
1149 INSERT INTO t3 VALUES(-2251799813685248);
1150 INSERT INTO t3 VALUES(-2251799813685249);
1151 INSERT INTO t3 VALUES(-2251799813685250);
1152 INSERT INTO t3 VALUES(4503599627370494);
1153 INSERT INTO t3 VALUES(4503599627370495);
1154 INSERT INTO t3 VALUES(4503599627370496);
1155 INSERT INTO t3 VALUES(4503599627370497);
1156 INSERT INTO t3 VALUES(4503599627370498);
1157 INSERT INTO t3 VALUES(-4503599627370494);
1158 INSERT INTO t3 VALUES(-4503599627370495);
1159 INSERT INTO t3 VALUES(-4503599627370496);
1160 INSERT INTO t3 VALUES(-4503599627370497);
1161 INSERT INTO t3 VALUES(-4503599627370498);
1162 INSERT INTO t3 VALUES(9007199254740990);
1163 INSERT INTO t3 VALUES(9007199254740991);
1164 INSERT INTO t3 VALUES(9007199254740992);
1165 INSERT INTO t3 VALUES(9007199254740993);
1166 INSERT INTO t3 VALUES(9007199254740994);
1167 INSERT INTO t3 VALUES(-9007199254740990);
1168 INSERT INTO t3 VALUES(-9007199254740991);
1169 INSERT INTO t3 VALUES(-9007199254740992);
1170 INSERT INTO t3 VALUES(-9007199254740993);
1171 INSERT INTO t3 VALUES(-9007199254740994);
1172 INSERT INTO t3 VALUES(18014398509481982);
1173 INSERT INTO t3 VALUES(18014398509481983);
1174 INSERT INTO t3 VALUES(18014398509481984);
1175 INSERT INTO t3 VALUES(18014398509481985);
1176 INSERT INTO t3 VALUES(18014398509481986);
1177 INSERT INTO t3 VALUES(-18014398509481982);
1178 INSERT INTO t3 VALUES(-18014398509481983);
1179 INSERT INTO t3 VALUES(-18014398509481984);
1180 INSERT INTO t3 VALUES(-18014398509481985);
1181 INSERT INTO t3 VALUES(-18014398509481986);
1182 INSERT INTO t3 VALUES(36028797018963966);
1183 INSERT INTO t3 VALUES(36028797018963967);
1184 INSERT INTO t3 VALUES(36028797018963968);
1185 INSERT INTO t3 VALUES(36028797018963969);
1186 INSERT INTO t3 VALUES(36028797018963970);
1187 INSERT INTO t3 VALUES(-36028797018963966);
1188 INSERT INTO t3 VALUES(-36028797018963967);
1189 INSERT INTO t3 VALUES(-36028797018963968);
1190 INSERT INTO t3 VALUES(-36028797018963969);
1191 INSERT INTO t3 VALUES(-36028797018963970);
1192 INSERT INTO t3 VALUES(72057594037927934);
1193 INSERT INTO t3 VALUES(72057594037927935);
1194 INSERT INTO t3 VALUES(72057594037927936);
1195 INSERT INTO t3 VALUES(72057594037927937);
1196 INSERT INTO t3 VALUES(72057594037927938);
1197 INSERT INTO t3 VALUES(-72057594037927934);
1198 INSERT INTO t3 VALUES(-72057594037927935);
1199 INSERT INTO t3 VALUES(-72057594037927936);
1200 INSERT INTO t3 VALUES(-72057594037927937);
1201 INSERT INTO t3 VALUES(-72057594037927938);
1202 INSERT INTO t3 VALUES(144115188075855870);
1203 INSERT INTO t3 VALUES(144115188075855871);
1204 INSERT INTO t3 VALUES(144115188075855872);
1205 INSERT INTO t3 VALUES(144115188075855873);
1206 INSERT INTO t3 VALUES(144115188075855874);
1207 INSERT INTO t3 VALUES(-144115188075855870);
1208 INSERT INTO t3 VALUES(-144115188075855871);
1209 INSERT INTO t3 VALUES(-144115188075855872);
1210 INSERT INTO t3 VALUES(-144115188075855873);
1211 INSERT INTO t3 VALUES(-144115188075855874);
1212 INSERT INTO t3 VALUES(288230376151711742);
1213 INSERT INTO t3 VALUES(288230376151711743);
1214 INSERT INTO t3 VALUES(288230376151711744);
1215 INSERT INTO t3 VALUES(288230376151711745);
1216 INSERT INTO t3 VALUES(288230376151711746);
1217 INSERT INTO t3 VALUES(-288230376151711742);
1218 INSERT INTO t3 VALUES(-288230376151711743);
1219 INSERT INTO t3 VALUES(-288230376151711744);
1220 INSERT INTO t3 VALUES(-288230376151711745);
1221 INSERT INTO t3 VALUES(-288230376151711746);
1222 INSERT INTO t3 VALUES(576460752303423486);
1223 INSERT INTO t3 VALUES(576460752303423487);
1224 INSERT INTO t3 VALUES(576460752303423488);
1225 INSERT INTO t3 VALUES(576460752303423489);
1226 INSERT INTO t3 VALUES(576460752303423490);
1227 INSERT INTO t3 VALUES(-576460752303423486);
1228 INSERT INTO t3 VALUES(-576460752303423487);
1229 INSERT INTO t3 VALUES(-576460752303423488);
1230 INSERT INTO t3 VALUES(-576460752303423489);
1231 INSERT INTO t3 VALUES(-576460752303423490);
1232 INSERT INTO t3 VALUES(1152921504606846974);
1233 INSERT INTO t3 VALUES(1152921504606846975);
1234 INSERT INTO t3 VALUES(1152921504606846976);
1235 INSERT INTO t3 VALUES(1152921504606846977);
1236 INSERT INTO t3 VALUES(1152921504606846978);
1237 INSERT INTO t3 VALUES(-1152921504606846974);
1238 INSERT INTO t3 VALUES(-1152921504606846975);
1239 INSERT INTO t3 VALUES(-1152921504606846976);
1240 INSERT INTO t3 VALUES(-1152921504606846977);
1241 INSERT INTO t3 VALUES(-1152921504606846978);
1242 INSERT INTO t3 VALUES(2305843009213693950);
1243 INSERT INTO t3 VALUES(2305843009213693951);
1244 INSERT INTO t3 VALUES(2305843009213693952);
1245 INSERT INTO t3 VALUES(2305843009213693953);
1246 INSERT INTO t3 VALUES(2305843009213693954);
1247 INSERT INTO t3 VALUES(-2305843009213693950);
1248 INSERT INTO t3 VALUES(-2305843009213693951);
1249 INSERT INTO t3 VALUES(-2305843009213693952);
1250 INSERT INTO t3 VALUES(-2305843009213693953);
1251 INSERT INTO t3 VALUES(-2305843009213693954);
1252 INSERT INTO t3 VALUES(4611686018427387902);
1253 INSERT INTO t3 VALUES(4611686018427387903);
1254 INSERT INTO t3 VALUES(4611686018427387904);
1255 INSERT INTO t3 VALUES(4611686018427387905);
1256 INSERT INTO t3 VALUES(4611686018427387906);
1257 INSERT INTO t3 VALUES(-4611686018427387902);
1258 INSERT INTO t3 VALUES(-4611686018427387903);
1259 INSERT INTO t3 VALUES(-4611686018427387904);
1260 INSERT INTO t3 VALUES(-4611686018427387905);
1261 INSERT INTO t3 VALUES(-4611686018427387906);
1262 INSERT INTO t3 VALUES(9223372036854775806);
1263 INSERT INTO t3 VALUES(9223372036854775807);
1264 INSERT INTO t3 VALUES(-9223372036854775806);
1265 INSERT INTO t3 VALUES(-9223372036854775807);
1266 INSERT INTO t3 VALUES(-9223372036854775808);
1267 SELECT x FROM t3 ORDER BY x;
1268 }
1269 } {-9223372036854775808\
1270 -9223372036854775807\
1271 -9223372036854775806\
1272 -4611686018427387906\
1273 -4611686018427387905\
1274 -4611686018427387904\
1275 -4611686018427387903\
1276 -4611686018427387902\
1277 -2305843009213693954\
1278 -2305843009213693953\
1279 -2305843009213693952\
1280 -2305843009213693951\
1281 -2305843009213693950\
1282 -1152921504606846978\
1283 -1152921504606846977\
1284 -1152921504606846976\
1285 -1152921504606846975\
1286 -1152921504606846974\
1287 -576460752303423490\
1288 -576460752303423489\
1289 -576460752303423488\
1290 -576460752303423487\
1291 -576460752303423486\
1292 -288230376151711746\
1293 -288230376151711745\
1294 -288230376151711744\
1295 -288230376151711743\
1296 -288230376151711742\
1297 -144115188075855874\
1298 -144115188075855873\
1299 -144115188075855872\
1300 -144115188075855871\
1301 -144115188075855870\
1302 -72057594037927938\
1303 -72057594037927937\
1304 -72057594037927936\
1305 -72057594037927935\
1306 -72057594037927934\
1307 -36028797018963970\
1308 -36028797018963969\
1309 -36028797018963968\
1310 -36028797018963967\
1311 -36028797018963966\
1312 -18014398509481986\
1313 -18014398509481985\
1314 -18014398509481984\
1315 -18014398509481983\
1316 -18014398509481982\
1317 -9007199254740994\
1318 -9007199254740993\
1319 -9007199254740992\
1320 -9007199254740991\
1321 -9007199254740990\
1322 -4503599627370498\
1323 -4503599627370497\
1324 -4503599627370496\
1325 -4503599627370495\
1326 -4503599627370494\
1327 -2251799813685250\
1328 -2251799813685249\
1329 -2251799813685248\
1330 -2251799813685247\
1331 -2251799813685246\
1332 -1125899906842626\
1333 -1125899906842625\
1334 -1125899906842624\
1335 -1125899906842623\
1336 -1125899906842622\
1337 -562949953421314\
1338 -562949953421313\
1339 -562949953421312\
1340 -562949953421311\
1341 -562949953421310\
1342 -281474976710658\
1343 -281474976710657\
1344 -281474976710656\
1345 -281474976710655\
1346 -281474976710654\
1347 -140737488355330\
1348 -140737488355329\
1349 -140737488355328\
1350 -140737488355327\
1351 -140737488355326\
1352 -70368744177666\
1353 -70368744177665\
1354 -70368744177664\
1355 -70368744177663\
1356 -70368744177662\
1357 -35184372088834\
1358 -35184372088833\
1359 -35184372088832\
1360 -35184372088831\
1361 -35184372088830\
1362 -17592186044418\
1363 -17592186044417\
1364 -17592186044416\
1365 -17592186044415\
1366 -17592186044414\
1367 -8796093022210\
1368 -8796093022209\
1369 -8796093022208\
1370 -8796093022207\
1371 -8796093022206\
1372 -4398046511106\
1373 -4398046511105\
1374 -4398046511104\
1375 -4398046511103\
1376 -4398046511102\
1377 -2199023255554\
1378 -2199023255553\
1379 -2199023255552\
1380 -2199023255551\
1381 -2199023255550\
1382 -1099511627778\
1383 -1099511627777\
1384 -1099511627776\
1385 -1099511627775\
1386 -1099511627774\
1387 -549755813890\
1388 -549755813889\
1389 -549755813888\
1390 -549755813887\
1391 -549755813886\
1392 -274877906946\
1393 -274877906945\
1394 -274877906944\
1395 -274877906943\
1396 -274877906942\
1397 -137438953474\
1398 -137438953473\
1399 -137438953472\
1400 -137438953471\
1401 -137438953470\
1402 -68719476738\
1403 -68719476737\
1404 -68719476736\
1405 -68719476735\
1406 -68719476734\
1407 -34359738370\
1408 -34359738369\
1409 -34359738368\
1410 -34359738367\
1411 -34359738366\
1412 -17179869186\
1413 -17179869185\
1414 -17179869184\
1415 -17179869183\
1416 -17179869182\
1417 -8589934594\
1418 -8589934593\
1419 -8589934592\
1420 -8589934591\
1421 -8589934590\
1422 -4294967298\
1423 -4294967297\
1424 -4294967296\
1425 -4294967295\
1426 -4294967294\
1427 -2147483650\
1428 -2147483649\
1429 -2147483648\
1430 -2147483647\
1431 -2147483646\
1432 -1073741826\
1433 -1073741825\
1434 -1073741824\
1435 -1073741823\
1436 -1073741822\
1437 -536870914\
1438 -536870913\
1439 -536870912\
1440 -536870911\
1441 -536870910\
1442 -268435458\
1443 -268435457\
1444 -268435456\
1445 -268435455\
1446 -268435454\
1447 -134217730\
1448 -134217729\
1449 -134217728\
1450 -134217727\
1451 -134217726\
1452 -67108866\
1453 -67108865\
1454 -67108864\
1455 -67108863\
1456 -67108862\
1457 -33554434\
1458 -33554433\
1459 -33554432\
1460 -33554431\
1461 -33554430\
1462 -16777218\
1463 -16777217\
1464 -16777216\
1465 -16777215\
1466 -16777214\
1467 -8388610\
1468 -8388609\
1469 -8388608\
1470 -8388607\
1471 -8388606\
1472 -4194306\
1473 -4194305\
1474 -4194304\
1475 -4194303\
1476 -4194302\
1477 -2097154\
1478 -2097153\
1479 -2097152\
1480 -2097151\
1481 -2097150\
1482 -1048578\
1483 -1048577\
1484 -1048576\
1485 -1048575\
1486 -1048574\
1487 -524290\
1488 -524289\
1489 -524288\
1490 -524287\
1491 -524286\
1492 -262146\
1493 -262145\
1494 -262144\
1495 -262143\
1496 -262142\
1497 -131074\
1498 -131073\
1499 -131072\
1500 -131071\
1501 -131070\
1502 -65538\
1503 -65537\
1504 -65536\
1505 -65535\
1506 -65534\
1507 -32770\
1508 -32769\
1509 -32768\
1510 -32767\
1511 -32766\
1512 -16386\
1513 -16385\
1514 -16384\
1515 -16383\
1516 -16382\
1517 -8194\
1518 -8193\
1519 -8192\
1520 -8191\
1521 -8190\
1522 -4098\
1523 -4097\
1524 -4096\
1525 -4095\
1526 -4094\
1527 -2050\
1528 -2049\
1529 -2048\
1530 -2047\
1531 -2046\
1532 -1026\
1533 -1025\
1534 -1024\
1535 -1023\
1536 -1022\
1537 -514\
1538 -513\
1539 -512\
1540 -511\
1541 -510\
1542 -258\
1543 -257\
1544 -256\
1545 -255\
1546 -254\
1547 -130\
1548 -129\
1549 -128\
1550 -127\
1551 -126\
1552 -66\
1553 -65\
1554 -64\
1555 -63\
1556 -62\
1557 -34\
1558 -33\
1559 -32\
1560 -31\
1561 -30\
1562 -18\
1563 -17\
1564 -16\
1565 -15\
1566 -14\
1567 -13\
1568 -12\
1569 -11\
1570 -10\
1571 -9\
1572 -8\
1573 -7\
1574 -6\
1575 -5\
1576 -4\
1577 -3\
1578 -2\
1579 -1\
1580 0\
1581 1\
1582 2\
1583 3\
1584 4\
1585 5\
1586 6\
1587 7\
1588 8\
1589 9\
1590 10\
1591 11\
1592 12\
1593 13\
1594 14\
1595 15\
1596 16\
1597 17\
1598 18\
1599 30\
1600 31\
1601 32\
1602 33\
1603 34\
1604 62\
1605 63\
1606 64\
1607 65\
1608 66\
1609 126\
1610 127\
1611 128\
1612 129\
1613 130\
1614 254\
1615 255\
1616 256\
1617 257\
1618 258\
1619 510\
1620 511\
1621 512\
1622 513\
1623 514\
1624 1022\
1625 1023\
1626 1024\
1627 1025\
1628 1026\
1629 2046\
1630 2047\
1631 2048\
1632 2049\
1633 2050\
1634 4094\
1635 4095\
1636 4096\
1637 4097\
1638 4098\
1639 8190\
1640 8191\
1641 8192\
1642 8193\
1643 8194\
1644 16382\
1645 16383\
1646 16384\
1647 16385\
1648 16386\
1649 32766\
1650 32767\
1651 32768\
1652 32769\
1653 32770\
1654 65534\
1655 65535\
1656 65536\
1657 65537\
1658 65538\
1659 131070\
1660 131071\
1661 131072\
1662 131073\
1663 131074\
1664 262142\
1665 262143\
1666 262144\
1667 262145\
1668 262146\
1669 524286\
1670 524287\
1671 524288\
1672 524289\
1673 524290\
1674 1048574\
1675 1048575\
1676 1048576\
1677 1048577\
1678 1048578\
1679 2097150\
1680 2097151\
1681 2097152\
1682 2097153\
1683 2097154\
1684 4194302\
1685 4194303\
1686 4194304\
1687 4194305\
1688 4194306\
1689 8388606\
1690 8388607\
1691 8388608\
1692 8388609\
1693 8388610\
1694 16777214\
1695 16777215\
1696 16777216\
1697 16777217\
1698 16777218\
1699 33554430\
1700 33554431\
1701 33554432\
1702 33554433\
1703 33554434\
1704 67108862\
1705 67108863\
1706 67108864\
1707 67108865\
1708 67108866\
1709 134217726\
1710 134217727\
1711 134217728\
1712 134217729\
1713 134217730\
1714 268435454\
1715 268435455\
1716 268435456\
1717 268435457\
1718 268435458\
1719 536870910\
1720 536870911\
1721 536870912\
1722 536870913\
1723 536870914\
1724 1073741822\
1725 1073741823\
1726 1073741824\
1727 1073741825\
1728 1073741826\
1729 2147483646\
1730 2147483647\
1731 2147483648\
1732 2147483649\
1733 2147483650\
1734 4294967294\
1735 4294967295\
1736 4294967296\
1737 4294967297\
1738 4294967298\
1739 8589934590\
1740 8589934591\
1741 8589934592\
1742 8589934593\
1743 8589934594\
1744 17179869182\
1745 17179869183\
1746 17179869184\
1747 17179869185\
1748 17179869186\
1749 34359738366\
1750 34359738367\
1751 34359738368\
1752 34359738369\
1753 34359738370\
1754 68719476734\
1755 68719476735\
1756 68719476736\
1757 68719476737\
1758 68719476738\
1759 137438953470\
1760 137438953471\
1761 137438953472\
1762 137438953473\
1763 137438953474\
1764 274877906942\
1765 274877906943\
1766 274877906944\
1767 274877906945\
1768 274877906946\
1769 549755813886\
1770 549755813887\
1771 549755813888\
1772 549755813889\
1773 549755813890\
1774 1099511627774\
1775 1099511627775\
1776 1099511627776\
1777 1099511627777\
1778 1099511627778\
1779 2199023255550\
1780 2199023255551\
1781 2199023255552\
1782 2199023255553\
1783 2199023255554\
1784 4398046511102\
1785 4398046511103\
1786 4398046511104\
1787 4398046511105\
1788 4398046511106\
1789 8796093022206\
1790 8796093022207\
1791 8796093022208\
1792 8796093022209\
1793 8796093022210\
1794 17592186044414\
1795 17592186044415\
1796 17592186044416\
1797 17592186044417\
1798 17592186044418\
1799 35184372088830\
1800 35184372088831\
1801 35184372088832\
1802 35184372088833\
1803 35184372088834\
1804 70368744177662\
1805 70368744177663\
1806 70368744177664\
1807 70368744177665\
1808 70368744177666\
1809 140737488355326\
1810 140737488355327\
1811 140737488355328\
1812 140737488355329\
1813 140737488355330\
1814 281474976710654\
1815 281474976710655\
1816 281474976710656\
1817 281474976710657\
1818 281474976710658\
1819 562949953421310\
1820 562949953421311\
1821 562949953421312\
1822 562949953421313\
1823 562949953421314\
1824 1125899906842622\
1825 1125899906842623\
1826 1125899906842624\
1827 1125899906842625\
1828 1125899906842626\
1829 2251799813685246\
1830 2251799813685247\
1831 2251799813685248\
1832 2251799813685249\
1833 2251799813685250\
1834 4503599627370494\
1835 4503599627370495\
1836 4503599627370496\
1837 4503599627370497\
1838 4503599627370498\
1839 9007199254740990\
1840 9007199254740991\
1841 9007199254740992\
1842 9007199254740993\
1843 9007199254740994\
1844 18014398509481982\
1845 18014398509481983\
1846 18014398509481984\
1847 18014398509481985\
1848 18014398509481986\
1849 36028797018963966\
1850 36028797018963967\
1851 36028797018963968\
1852 36028797018963969\
1853 36028797018963970\
1854 72057594037927934\
1855 72057594037927935\
1856 72057594037927936\
1857 72057594037927937\
1858 72057594037927938\
1859 144115188075855870\
1860 144115188075855871\
1861 144115188075855872\
1862 144115188075855873\
1863 144115188075855874\
1864 288230376151711742\
1865 288230376151711743\
1866 288230376151711744\
1867 288230376151711745\
1868 288230376151711746\
1869 576460752303423486\
1870 576460752303423487\
1871 576460752303423488\
1872 576460752303423489\
1873 576460752303423490\
1874 1152921504606846974\
1875 1152921504606846975\
1876 1152921504606846976\
1877 1152921504606846977\
1878 1152921504606846978\
1879 2305843009213693950\
1880 2305843009213693951\
1881 2305843009213693952\
1882 2305843009213693953\
1883 2305843009213693954\
1884 4611686018427387902\
1885 4611686018427387903\
1886 4611686018427387904\
1887 4611686018427387905\
1888 4611686018427387906\
1889 9223372036854775806\
1890 9223372036854775807}
1891
1892 finish_test
OLDNEW
« no previous file with comments | « third_party/sqlite/sqlite-src-3100200/test/misc4.test ('k') | third_party/sqlite/sqlite-src-3100200/test/misc6.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698