blob: 881aba1cd849f8c9888ba077c321296504899045 [file] [log] [blame]
drhcb9882a2005-03-17 03:15:40 +00001# 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#
danielk1977003c1ff2008-07-29 10:26:45 +000016# $Id: misc5.test,v 1.22 2008/07/29 10:26:45 danielk1977 Exp $
drhcb9882a2005-03-17 03:15:40 +000017
18set testdir [file dirname $argv0]
19source $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#
27for {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
drhb47d45c2005-04-15 12:04:34 +000044# Make sure large integers are stored correctly.
45#
danielk19773bdca9c2006-01-17 09:35:01 +000046ifcapable 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}
drhb47d45c2005-04-15 12:04:34 +000086do_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\
2760\
2771\
2782\
2793\
2804\
2815\
2827\
2838\
2849\
28515\
28616\
28717\
28831\
28932\
29033\
29163\
29264\
29365\
294127\
295128\
296129\
297255\
298256\
299257\
300511\
301512\
302513\
3031023\
3041024\
3051025\
3062047\
3072048\
3082049\
3094095\
3104096\
3114097\
3128191\
3138192\
3148193\
31516383\
31616384\
31716385\
31832767\
31932768\
32032769\
32165535\
32265536\
32365537\
324131071\
325131072\
326131073\
327262143\
328262144\
329262145\
330524287\
331524288\
332524289\
3331048575\
3341048576\
3351048577\
3362097151\
3372097152\
3382097153\
3394194303\
3404194304\
3414194305\
3428388607\
3438388608\
3448388609\
34516777215\
34616777216\
34716777217\
34833554431\
34933554432\
35033554433\
35167108863\
35267108864\
35367108865\
354134217727\
355134217728\
356134217729\
357268435455\
358268435456\
359268435457\
360536870911\
361536870912\
362536870913\
3631073741823\
3641073741824\
3651073741825\
3662147483647\
3672147483648\
3682147483649\
3694294967295\
3704294967296\
3714294967297\
3728589934591\
3738589934592\
3748589934593\
37517179869183\
37617179869184\
37717179869185\
37834359738367\
37934359738368\
38034359738369\
38168719476735\
38268719476736\
38368719476737\
384137438953471\
385137438953472\
386137438953473\
387274877906943\
388274877906944\
389274877906945\
390549755813887\
391549755813888\
392549755813889\
3931099511627775\
3941099511627776\
3951099511627777\
3962199023255551\
3972199023255552\
3982199023255553\
3994398046511103\
4004398046511104\
4014398046511105\
4028796093022207\
4038796093022208\
4048796093022209\
40517592186044415\
40617592186044416\
40717592186044417\
40835184372088831\
40935184372088832\
41035184372088833\
41170368744177663\
41270368744177664\
41370368744177665\
414140737488355327\
415140737488355328\
416140737488355329\
417281474976710655\
418281474976710656\
419281474976710657\
420562949953421311\
421562949953421312\
422562949953421313\
4231125899906842623\
4241125899906842624\
4251125899906842625\
4262251799813685247\
4272251799813685248\
4282251799813685249\
4294503599627370495\
4304503599627370496\
4314503599627370497\
4329007199254740991\
4339007199254740992\
4349007199254740993\
43518014398509481983\
43618014398509481984\
43718014398509481985\
43836028797018963967\
43936028797018963968\
44036028797018963969\
44172057594037927935\
44272057594037927936\
44372057594037927937\
444144115188075855871\
445144115188075855872\
446144115188075855873\
447288230376151711743\
448288230376151711744\
449288230376151711745\
450576460752303423487\
451576460752303423488\
452576460752303423489\
4531152921504606846975\
4541152921504606846976\
4551152921504606846977\
4562305843009213693951\
4572305843009213693952\
4582305843009213693953\
4594611686018427387903\
4604611686018427387904\
4614611686018427387905"
462
drhed8a3bb2005-06-06 21:19:56 +0000463# Ticket #1210. Do proper reference counting of Table structures
464# so that deeply nested SELECT statements can be flattened correctly.
465#
danielk19771576cd92006-01-14 08:02:28 +0000466ifcapable 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) = (
danielk19773c4809a2007-11-12 15:29:18 +0000484 -- 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.
danielk19771576cd92006-01-14 08:02:28 +0000488 SELECT DISTINCT LOWER(artist)
489 FROM (
danielk19773c4809a2007-11-12 15:29:18 +0000490 -- This sub-query returns the table:
491 --
492 -- two 14
493 -- one 10
494 -- three 5
495 --
danielk19771576cd92006-01-14 08:02:28 +0000496 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 )
drhed8a3bb2005-06-06 21:19:56 +0000505 )
danielk19771576cd92006-01-14 08:02:28 +0000506 ORDER BY LOWER(artist) ASC;
507 }
dan38cc40c2011-06-30 20:17:15 +0000508 } {two}
danielk19771576cd92006-01-14 08:02:28 +0000509}
drhb47d45c2005-04-15 12:04:34 +0000510
drh992f2d72005-08-21 16:54:25 +0000511# Ticket #1370. Do not overwrite small files (less than 1024 bytes)
512# when trying to open them as a database.
513#
dancb354602010-07-08 09:44:42 +0000514if {[permutation] == ""} {
515 do_test misc5-4.1 {
516 db close
mistachkinfda06be2011-08-02 00:57:34 +0000517 forcedelete test.db
dancb354602010-07-08 09:44:42 +0000518 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 }
drhff4fa772017-07-10 12:07:53 +0000525 } {1 {file is not a database}}
dancb354602010-07-08 09:44:42 +0000526}
drh992f2d72005-08-21 16:54:25 +0000527
drh76816182005-08-23 11:31:26 +0000528# Ticket #1371. Allow floating point numbers of the form .N or N.
529#
530do_test misc5-5.1 {
531 execsql {SELECT .1 }
532} 0.1
533do_test misc5-5.2 {
534 execsql {SELECT 2. }
drh8a512562005-11-14 22:29:05 +0000535} 2.0
drh76816182005-08-23 11:31:26 +0000536do_test misc5-5.3 {
537 execsql {SELECT 3.e0 }
drh8a512562005-11-14 22:29:05 +0000538} 3.0
drh76816182005-08-23 11:31:26 +0000539do_test misc5-5.4 {
540 execsql {SELECT .4e+1}
drh8a512562005-11-14 22:29:05 +0000541} 4.0
drh992f2d72005-08-21 16:54:25 +0000542
danielk1977ad68cb62006-01-05 14:22:33 +0000543# 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#
546db close
mistachkinfda06be2011-08-02 00:57:34 +0000547forcedelete test.db
danielk1977ad68cb62006-01-05 14:22:33 +0000548sqlite3 db test.db
danielk1977ff890792006-01-16 16:24:25 +0000549ifcapable subquery&&compound {
danielk1977ad68cb62006-01-05 14:22:33 +0000550 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 {
danielk197701874bf2007-12-13 07:58:50 +0000563 SELECT * FROM logs WHERE logs.oid >= (SELECT head FROM logs_base)
danielk1977ad68cb62006-01-05 14:22:33 +0000564 UNION ALL
565 SELECT * FROM logs
566 LIMIT (SELECT lmt FROM logs_base) ;
567 }
danielk197701874bf2007-12-13 07:58:50 +0000568 } {1 {no such table: logs_base}}
danielk1977ad68cb62006-01-05 14:22:33 +0000569}
drhb47d45c2005-04-15 12:04:34 +0000570
drh3e450ec2006-02-27 23:19:20 +0000571# Overflow the lemon parser stack by providing an overly complex
572# expression. Make sure that the overflow is detected and reported.
573#
drh8dc82472016-05-27 04:10:47 +0000574# This test fails when building with -DYYSTACKDEPTH=0
575#
drh3e450ec2006-02-27 23:19:20 +0000576do_test misc5-7.1 {
577 execsql {CREATE TABLE t1(x)}
578 set sql "INSERT INTO t1 VALUES("
579 set tail ""
580 for {set i 0} {$i<200} {incr i} {
581 append sql "(1+"
582 append tail ")"
583 }
584 append sql 2$tail
585 catchsql $sql
586} {1 {parser stack overflow}}
587
drh75209962015-04-19 22:31:45 +0000588# Parser stack overflow is silently ignored when it occurs while parsing the
589# schema and PRAGMA writable_schema is turned on.
590#
591do_test misc5-7.2 {
592 sqlite3 db2 :memory:
593 catchsql {
594 CREATE TABLE t1(x UNIQUE);
595 PRAGMA writable_schema=ON;
596 UPDATE sqlite_master SET sql='CREATE table t(o CHECK(((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((;VALUES(o)';
597 BEGIN;
598 CREATE TABLE t2(y);
599 ROLLBACK;
600 DROP TABLE IF EXISTS D;
601 } db2
602} {0 {}}
603db2 close
604
605
drh1e31e0b2006-08-11 19:08:27 +0000606# Ticket #1911
607#
danielk19774152e672007-09-12 17:01:45 +0000608ifcapable compound {
609 do_test misc5-9.1 {
610 execsql {
611 SELECT name, type FROM sqlite_master WHERE name IS NULL
612 UNION
613 SELECT type, name FROM sqlite_master WHERE type IS NULL
614 ORDER BY 1, 2, 1, 2, 1, 2
615 }
616 } {}
617 do_test misc5-9.2 {
618 execsql {
619 SELECT name, type FROM sqlite_master WHERE name IS NULL
620 UNION
621 SELECT type, name FROM sqlite_master WHERE type IS NULL
622 ORDER BY 1, 2, 1, 2, 1, 2, 1, 2, 1, 2, 1, 2, 1, 2, 1, 2, 1, 2
623 }
624 } {}
625}
drh1e31e0b2006-08-11 19:08:27 +0000626
drh67dd9012006-08-12 12:33:14 +0000627# Ticket #1912. Make the tokenizer require a space after a numeric
628# literal.
629#
630do_test misc5-10.1 {
631 catchsql {
632 SELECT 123abc
633 }
634} {1 {unrecognized token: "123abc"}}
635do_test misc5-10.2 {
636 catchsql {
637 SELECT 1*123.4e5ghi;
638 }
639} {1 {unrecognized token: "123.4e5ghi"}}
640
641
drh5284a052008-05-08 15:18:10 +0000642# Additional integer encoding tests.
643#
644do_test misc5-11.1 {
645 db eval {
646 CREATE TABLE t3(x);
647 INSERT INTO t3 VALUES(-18);
648 INSERT INTO t3 VALUES(-17);
649 INSERT INTO t3 VALUES(-16);
650 INSERT INTO t3 VALUES(-15);
651 INSERT INTO t3 VALUES(-14);
652 INSERT INTO t3 VALUES(-13);
653 INSERT INTO t3 VALUES(-12);
654 INSERT INTO t3 VALUES(-11);
655 INSERT INTO t3 VALUES(-10);
656 INSERT INTO t3 VALUES(-9);
657 INSERT INTO t3 VALUES(-8);
658 INSERT INTO t3 VALUES(-7);
659 INSERT INTO t3 VALUES(-6);
660 INSERT INTO t3 VALUES(-5);
661 INSERT INTO t3 VALUES(-4);
662 INSERT INTO t3 VALUES(-3);
663 INSERT INTO t3 VALUES(-2);
664 INSERT INTO t3 VALUES(-1);
665 INSERT INTO t3 VALUES(0);
666 INSERT INTO t3 VALUES(1);
667 INSERT INTO t3 VALUES(2);
668 INSERT INTO t3 VALUES(3);
669 INSERT INTO t3 VALUES(4);
670 INSERT INTO t3 VALUES(5);
671 INSERT INTO t3 VALUES(6);
672 INSERT INTO t3 VALUES(7);
673 INSERT INTO t3 VALUES(8);
674 INSERT INTO t3 VALUES(9);
675 INSERT INTO t3 VALUES(10);
676 INSERT INTO t3 VALUES(11);
677 INSERT INTO t3 VALUES(12);
678 INSERT INTO t3 VALUES(13);
679 INSERT INTO t3 VALUES(14);
680 INSERT INTO t3 VALUES(15);
681 INSERT INTO t3 VALUES(16);
682 INSERT INTO t3 VALUES(17);
683 INSERT INTO t3 VALUES(18);
684 INSERT INTO t3 VALUES(30);
685 INSERT INTO t3 VALUES(31);
686 INSERT INTO t3 VALUES(32);
687 INSERT INTO t3 VALUES(33);
688 INSERT INTO t3 VALUES(34);
689 INSERT INTO t3 VALUES(-30);
690 INSERT INTO t3 VALUES(-31);
691 INSERT INTO t3 VALUES(-32);
692 INSERT INTO t3 VALUES(-33);
693 INSERT INTO t3 VALUES(-34);
694 INSERT INTO t3 VALUES(62);
695 INSERT INTO t3 VALUES(63);
696 INSERT INTO t3 VALUES(64);
697 INSERT INTO t3 VALUES(65);
698 INSERT INTO t3 VALUES(66);
699 INSERT INTO t3 VALUES(-62);
700 INSERT INTO t3 VALUES(-63);
701 INSERT INTO t3 VALUES(-64);
702 INSERT INTO t3 VALUES(-65);
703 INSERT INTO t3 VALUES(-66);
704 INSERT INTO t3 VALUES(126);
705 INSERT INTO t3 VALUES(127);
706 INSERT INTO t3 VALUES(128);
707 INSERT INTO t3 VALUES(129);
708 INSERT INTO t3 VALUES(130);
709 INSERT INTO t3 VALUES(-126);
710 INSERT INTO t3 VALUES(-127);
711 INSERT INTO t3 VALUES(-128);
712 INSERT INTO t3 VALUES(-129);
713 INSERT INTO t3 VALUES(-130);
714 INSERT INTO t3 VALUES(254);
715 INSERT INTO t3 VALUES(255);
716 INSERT INTO t3 VALUES(256);
717 INSERT INTO t3 VALUES(257);
718 INSERT INTO t3 VALUES(258);
719 INSERT INTO t3 VALUES(-254);
720 INSERT INTO t3 VALUES(-255);
721 INSERT INTO t3 VALUES(-256);
722 INSERT INTO t3 VALUES(-257);
723 INSERT INTO t3 VALUES(-258);
724 INSERT INTO t3 VALUES(510);
725 INSERT INTO t3 VALUES(511);
726 INSERT INTO t3 VALUES(512);
727 INSERT INTO t3 VALUES(513);
728 INSERT INTO t3 VALUES(514);
729 INSERT INTO t3 VALUES(-510);
730 INSERT INTO t3 VALUES(-511);
731 INSERT INTO t3 VALUES(-512);
732 INSERT INTO t3 VALUES(-513);
733 INSERT INTO t3 VALUES(-514);
734 INSERT INTO t3 VALUES(1022);
735 INSERT INTO t3 VALUES(1023);
736 INSERT INTO t3 VALUES(1024);
737 INSERT INTO t3 VALUES(1025);
738 INSERT INTO t3 VALUES(1026);
739 INSERT INTO t3 VALUES(-1022);
740 INSERT INTO t3 VALUES(-1023);
741 INSERT INTO t3 VALUES(-1024);
742 INSERT INTO t3 VALUES(-1025);
743 INSERT INTO t3 VALUES(-1026);
744 INSERT INTO t3 VALUES(2046);
745 INSERT INTO t3 VALUES(2047);
746 INSERT INTO t3 VALUES(2048);
747 INSERT INTO t3 VALUES(2049);
748 INSERT INTO t3 VALUES(2050);
749 INSERT INTO t3 VALUES(-2046);
750 INSERT INTO t3 VALUES(-2047);
751 INSERT INTO t3 VALUES(-2048);
752 INSERT INTO t3 VALUES(-2049);
753 INSERT INTO t3 VALUES(-2050);
754 INSERT INTO t3 VALUES(4094);
755 INSERT INTO t3 VALUES(4095);
756 INSERT INTO t3 VALUES(4096);
757 INSERT INTO t3 VALUES(4097);
758 INSERT INTO t3 VALUES(4098);
759 INSERT INTO t3 VALUES(-4094);
760 INSERT INTO t3 VALUES(-4095);
761 INSERT INTO t3 VALUES(-4096);
762 INSERT INTO t3 VALUES(-4097);
763 INSERT INTO t3 VALUES(-4098);
764 INSERT INTO t3 VALUES(8190);
765 INSERT INTO t3 VALUES(8191);
766 INSERT INTO t3 VALUES(8192);
767 INSERT INTO t3 VALUES(8193);
768 INSERT INTO t3 VALUES(8194);
769 INSERT INTO t3 VALUES(-8190);
770 INSERT INTO t3 VALUES(-8191);
771 INSERT INTO t3 VALUES(-8192);
772 INSERT INTO t3 VALUES(-8193);
773 INSERT INTO t3 VALUES(-8194);
774 INSERT INTO t3 VALUES(16382);
775 INSERT INTO t3 VALUES(16383);
776 INSERT INTO t3 VALUES(16384);
777 INSERT INTO t3 VALUES(16385);
778 INSERT INTO t3 VALUES(16386);
779 INSERT INTO t3 VALUES(-16382);
780 INSERT INTO t3 VALUES(-16383);
781 INSERT INTO t3 VALUES(-16384);
782 INSERT INTO t3 VALUES(-16385);
783 INSERT INTO t3 VALUES(-16386);
784 INSERT INTO t3 VALUES(32766);
785 INSERT INTO t3 VALUES(32767);
786 INSERT INTO t3 VALUES(32768);
787 INSERT INTO t3 VALUES(32769);
788 INSERT INTO t3 VALUES(32770);
789 INSERT INTO t3 VALUES(-32766);
790 INSERT INTO t3 VALUES(-32767);
791 INSERT INTO t3 VALUES(-32768);
792 INSERT INTO t3 VALUES(-32769);
793 INSERT INTO t3 VALUES(-32770);
794 INSERT INTO t3 VALUES(65534);
795 INSERT INTO t3 VALUES(65535);
796 INSERT INTO t3 VALUES(65536);
797 INSERT INTO t3 VALUES(65537);
798 INSERT INTO t3 VALUES(65538);
799 INSERT INTO t3 VALUES(-65534);
800 INSERT INTO t3 VALUES(-65535);
801 INSERT INTO t3 VALUES(-65536);
802 INSERT INTO t3 VALUES(-65537);
803 INSERT INTO t3 VALUES(-65538);
804 INSERT INTO t3 VALUES(131070);
805 INSERT INTO t3 VALUES(131071);
806 INSERT INTO t3 VALUES(131072);
807 INSERT INTO t3 VALUES(131073);
808 INSERT INTO t3 VALUES(131074);
809 INSERT INTO t3 VALUES(-131070);
810 INSERT INTO t3 VALUES(-131071);
811 INSERT INTO t3 VALUES(-131072);
812 INSERT INTO t3 VALUES(-131073);
813 INSERT INTO t3 VALUES(-131074);
814 INSERT INTO t3 VALUES(262142);
815 INSERT INTO t3 VALUES(262143);
816 INSERT INTO t3 VALUES(262144);
817 INSERT INTO t3 VALUES(262145);
818 INSERT INTO t3 VALUES(262146);
819 INSERT INTO t3 VALUES(-262142);
820 INSERT INTO t3 VALUES(-262143);
821 INSERT INTO t3 VALUES(-262144);
822 INSERT INTO t3 VALUES(-262145);
823 INSERT INTO t3 VALUES(-262146);
824 INSERT INTO t3 VALUES(524286);
825 INSERT INTO t3 VALUES(524287);
826 INSERT INTO t3 VALUES(524288);
827 INSERT INTO t3 VALUES(524289);
828 INSERT INTO t3 VALUES(524290);
829 INSERT INTO t3 VALUES(-524286);
830 INSERT INTO t3 VALUES(-524287);
831 INSERT INTO t3 VALUES(-524288);
832 INSERT INTO t3 VALUES(-524289);
833 INSERT INTO t3 VALUES(-524290);
834 INSERT INTO t3 VALUES(1048574);
835 INSERT INTO t3 VALUES(1048575);
836 INSERT INTO t3 VALUES(1048576);
837 INSERT INTO t3 VALUES(1048577);
838 INSERT INTO t3 VALUES(1048578);
839 INSERT INTO t3 VALUES(-1048574);
840 INSERT INTO t3 VALUES(-1048575);
841 INSERT INTO t3 VALUES(-1048576);
842 INSERT INTO t3 VALUES(-1048577);
843 INSERT INTO t3 VALUES(-1048578);
844 INSERT INTO t3 VALUES(2097150);
845 INSERT INTO t3 VALUES(2097151);
846 INSERT INTO t3 VALUES(2097152);
847 INSERT INTO t3 VALUES(2097153);
848 INSERT INTO t3 VALUES(2097154);
849 INSERT INTO t3 VALUES(-2097150);
850 INSERT INTO t3 VALUES(-2097151);
851 INSERT INTO t3 VALUES(-2097152);
852 INSERT INTO t3 VALUES(-2097153);
853 INSERT INTO t3 VALUES(-2097154);
854 INSERT INTO t3 VALUES(4194302);
855 INSERT INTO t3 VALUES(4194303);
856 INSERT INTO t3 VALUES(4194304);
857 INSERT INTO t3 VALUES(4194305);
858 INSERT INTO t3 VALUES(4194306);
859 INSERT INTO t3 VALUES(-4194302);
860 INSERT INTO t3 VALUES(-4194303);
861 INSERT INTO t3 VALUES(-4194304);
862 INSERT INTO t3 VALUES(-4194305);
863 INSERT INTO t3 VALUES(-4194306);
864 INSERT INTO t3 VALUES(8388606);
865 INSERT INTO t3 VALUES(8388607);
866 INSERT INTO t3 VALUES(8388608);
867 INSERT INTO t3 VALUES(8388609);
868 INSERT INTO t3 VALUES(8388610);
869 INSERT INTO t3 VALUES(-8388606);
870 INSERT INTO t3 VALUES(-8388607);
871 INSERT INTO t3 VALUES(-8388608);
872 INSERT INTO t3 VALUES(-8388609);
873 INSERT INTO t3 VALUES(-8388610);
874 INSERT INTO t3 VALUES(16777214);
875 INSERT INTO t3 VALUES(16777215);
876 INSERT INTO t3 VALUES(16777216);
877 INSERT INTO t3 VALUES(16777217);
878 INSERT INTO t3 VALUES(16777218);
879 INSERT INTO t3 VALUES(-16777214);
880 INSERT INTO t3 VALUES(-16777215);
881 INSERT INTO t3 VALUES(-16777216);
882 INSERT INTO t3 VALUES(-16777217);
883 INSERT INTO t3 VALUES(-16777218);
884 INSERT INTO t3 VALUES(33554430);
885 INSERT INTO t3 VALUES(33554431);
886 INSERT INTO t3 VALUES(33554432);
887 INSERT INTO t3 VALUES(33554433);
888 INSERT INTO t3 VALUES(33554434);
889 INSERT INTO t3 VALUES(-33554430);
890 INSERT INTO t3 VALUES(-33554431);
891 INSERT INTO t3 VALUES(-33554432);
892 INSERT INTO t3 VALUES(-33554433);
893 INSERT INTO t3 VALUES(-33554434);
894 INSERT INTO t3 VALUES(67108862);
895 INSERT INTO t3 VALUES(67108863);
896 INSERT INTO t3 VALUES(67108864);
897 INSERT INTO t3 VALUES(67108865);
898 INSERT INTO t3 VALUES(67108866);
899 INSERT INTO t3 VALUES(-67108862);
900 INSERT INTO t3 VALUES(-67108863);
901 INSERT INTO t3 VALUES(-67108864);
902 INSERT INTO t3 VALUES(-67108865);
903 INSERT INTO t3 VALUES(-67108866);
904 INSERT INTO t3 VALUES(134217726);
905 INSERT INTO t3 VALUES(134217727);
906 INSERT INTO t3 VALUES(134217728);
907 INSERT INTO t3 VALUES(134217729);
908 INSERT INTO t3 VALUES(134217730);
909 INSERT INTO t3 VALUES(-134217726);
910 INSERT INTO t3 VALUES(-134217727);
911 INSERT INTO t3 VALUES(-134217728);
912 INSERT INTO t3 VALUES(-134217729);
913 INSERT INTO t3 VALUES(-134217730);
914 INSERT INTO t3 VALUES(268435454);
915 INSERT INTO t3 VALUES(268435455);
916 INSERT INTO t3 VALUES(268435456);
917 INSERT INTO t3 VALUES(268435457);
918 INSERT INTO t3 VALUES(268435458);
919 INSERT INTO t3 VALUES(-268435454);
920 INSERT INTO t3 VALUES(-268435455);
921 INSERT INTO t3 VALUES(-268435456);
922 INSERT INTO t3 VALUES(-268435457);
923 INSERT INTO t3 VALUES(-268435458);
924 INSERT INTO t3 VALUES(536870910);
925 INSERT INTO t3 VALUES(536870911);
926 INSERT INTO t3 VALUES(536870912);
927 INSERT INTO t3 VALUES(536870913);
928 INSERT INTO t3 VALUES(536870914);
929 INSERT INTO t3 VALUES(-536870910);
930 INSERT INTO t3 VALUES(-536870911);
931 INSERT INTO t3 VALUES(-536870912);
932 INSERT INTO t3 VALUES(-536870913);
933 INSERT INTO t3 VALUES(-536870914);
934 INSERT INTO t3 VALUES(1073741822);
935 INSERT INTO t3 VALUES(1073741823);
936 INSERT INTO t3 VALUES(1073741824);
937 INSERT INTO t3 VALUES(1073741825);
938 INSERT INTO t3 VALUES(1073741826);
939 INSERT INTO t3 VALUES(-1073741822);
940 INSERT INTO t3 VALUES(-1073741823);
941 INSERT INTO t3 VALUES(-1073741824);
942 INSERT INTO t3 VALUES(-1073741825);
943 INSERT INTO t3 VALUES(-1073741826);
944 INSERT INTO t3 VALUES(2147483646);
945 INSERT INTO t3 VALUES(2147483647);
946 INSERT INTO t3 VALUES(2147483648);
947 INSERT INTO t3 VALUES(2147483649);
948 INSERT INTO t3 VALUES(2147483650);
949 INSERT INTO t3 VALUES(-2147483646);
950 INSERT INTO t3 VALUES(-2147483647);
951 INSERT INTO t3 VALUES(-2147483648);
952 INSERT INTO t3 VALUES(-2147483649);
953 INSERT INTO t3 VALUES(-2147483650);
954 INSERT INTO t3 VALUES(4294967294);
955 INSERT INTO t3 VALUES(4294967295);
956 INSERT INTO t3 VALUES(4294967296);
957 INSERT INTO t3 VALUES(4294967297);
958 INSERT INTO t3 VALUES(4294967298);
959 INSERT INTO t3 VALUES(-4294967294);
960 INSERT INTO t3 VALUES(-4294967295);
961 INSERT INTO t3 VALUES(-4294967296);
962 INSERT INTO t3 VALUES(-4294967297);
963 INSERT INTO t3 VALUES(-4294967298);
964 INSERT INTO t3 VALUES(8589934590);
965 INSERT INTO t3 VALUES(8589934591);
966 INSERT INTO t3 VALUES(8589934592);
967 INSERT INTO t3 VALUES(8589934593);
968 INSERT INTO t3 VALUES(8589934594);
969 INSERT INTO t3 VALUES(-8589934590);
970 INSERT INTO t3 VALUES(-8589934591);
971 INSERT INTO t3 VALUES(-8589934592);
972 INSERT INTO t3 VALUES(-8589934593);
973 INSERT INTO t3 VALUES(-8589934594);
974 INSERT INTO t3 VALUES(17179869182);
975 INSERT INTO t3 VALUES(17179869183);
976 INSERT INTO t3 VALUES(17179869184);
977 INSERT INTO t3 VALUES(17179869185);
978 INSERT INTO t3 VALUES(17179869186);
979 INSERT INTO t3 VALUES(-17179869182);
980 INSERT INTO t3 VALUES(-17179869183);
981 INSERT INTO t3 VALUES(-17179869184);
982 INSERT INTO t3 VALUES(-17179869185);
983 INSERT INTO t3 VALUES(-17179869186);
984 INSERT INTO t3 VALUES(34359738366);
985 INSERT INTO t3 VALUES(34359738367);
986 INSERT INTO t3 VALUES(34359738368);
987 INSERT INTO t3 VALUES(34359738369);
988 INSERT INTO t3 VALUES(34359738370);
989 INSERT INTO t3 VALUES(-34359738366);
990 INSERT INTO t3 VALUES(-34359738367);
991 INSERT INTO t3 VALUES(-34359738368);
992 INSERT INTO t3 VALUES(-34359738369);
993 INSERT INTO t3 VALUES(-34359738370);
994 INSERT INTO t3 VALUES(68719476734);
995 INSERT INTO t3 VALUES(68719476735);
996 INSERT INTO t3 VALUES(68719476736);
997 INSERT INTO t3 VALUES(68719476737);
998 INSERT INTO t3 VALUES(68719476738);
999 INSERT INTO t3 VALUES(-68719476734);
1000 INSERT INTO t3 VALUES(-68719476735);
1001 INSERT INTO t3 VALUES(-68719476736);
1002 INSERT INTO t3 VALUES(-68719476737);
1003 INSERT INTO t3 VALUES(-68719476738);
1004 INSERT INTO t3 VALUES(137438953470);
1005 INSERT INTO t3 VALUES(137438953471);
1006 INSERT INTO t3 VALUES(137438953472);
1007 INSERT INTO t3 VALUES(137438953473);
1008 INSERT INTO t3 VALUES(137438953474);
1009 INSERT INTO t3 VALUES(-137438953470);
1010 INSERT INTO t3 VALUES(-137438953471);
1011 INSERT INTO t3 VALUES(-137438953472);
1012 INSERT INTO t3 VALUES(-137438953473);
1013 INSERT INTO t3 VALUES(-137438953474);
1014 INSERT INTO t3 VALUES(274877906942);
1015 INSERT INTO t3 VALUES(274877906943);
1016 INSERT INTO t3 VALUES(274877906944);
1017 INSERT INTO t3 VALUES(274877906945);
1018 INSERT INTO t3 VALUES(274877906946);
1019 INSERT INTO t3 VALUES(-274877906942);
1020 INSERT INTO t3 VALUES(-274877906943);
1021 INSERT INTO t3 VALUES(-274877906944);
1022 INSERT INTO t3 VALUES(-274877906945);
1023 INSERT INTO t3 VALUES(-274877906946);
1024 INSERT INTO t3 VALUES(549755813886);
1025 INSERT INTO t3 VALUES(549755813887);
1026 INSERT INTO t3 VALUES(549755813888);
1027 INSERT INTO t3 VALUES(549755813889);
1028 INSERT INTO t3 VALUES(549755813890);
1029 INSERT INTO t3 VALUES(-549755813886);
1030 INSERT INTO t3 VALUES(-549755813887);
1031 INSERT INTO t3 VALUES(-549755813888);
1032 INSERT INTO t3 VALUES(-549755813889);
1033 INSERT INTO t3 VALUES(-549755813890);
1034 INSERT INTO t3 VALUES(1099511627774);
1035 INSERT INTO t3 VALUES(1099511627775);
1036 INSERT INTO t3 VALUES(1099511627776);
1037 INSERT INTO t3 VALUES(1099511627777);
1038 INSERT INTO t3 VALUES(1099511627778);
1039 INSERT INTO t3 VALUES(-1099511627774);
1040 INSERT INTO t3 VALUES(-1099511627775);
1041 INSERT INTO t3 VALUES(-1099511627776);
1042 INSERT INTO t3 VALUES(-1099511627777);
1043 INSERT INTO t3 VALUES(-1099511627778);
1044 INSERT INTO t3 VALUES(2199023255550);
1045 INSERT INTO t3 VALUES(2199023255551);
1046 INSERT INTO t3 VALUES(2199023255552);
1047 INSERT INTO t3 VALUES(2199023255553);
1048 INSERT INTO t3 VALUES(2199023255554);
1049 INSERT INTO t3 VALUES(-2199023255550);
1050 INSERT INTO t3 VALUES(-2199023255551);
1051 INSERT INTO t3 VALUES(-2199023255552);
1052 INSERT INTO t3 VALUES(-2199023255553);
1053 INSERT INTO t3 VALUES(-2199023255554);
1054 INSERT INTO t3 VALUES(4398046511102);
1055 INSERT INTO t3 VALUES(4398046511103);
1056 INSERT INTO t3 VALUES(4398046511104);
1057 INSERT INTO t3 VALUES(4398046511105);
1058 INSERT INTO t3 VALUES(4398046511106);
1059 INSERT INTO t3 VALUES(-4398046511102);
1060 INSERT INTO t3 VALUES(-4398046511103);
1061 INSERT INTO t3 VALUES(-4398046511104);
1062 INSERT INTO t3 VALUES(-4398046511105);
1063 INSERT INTO t3 VALUES(-4398046511106);
1064 INSERT INTO t3 VALUES(8796093022206);
1065 INSERT INTO t3 VALUES(8796093022207);
1066 INSERT INTO t3 VALUES(8796093022208);
1067 INSERT INTO t3 VALUES(8796093022209);
1068 INSERT INTO t3 VALUES(8796093022210);
1069 INSERT INTO t3 VALUES(-8796093022206);
1070 INSERT INTO t3 VALUES(-8796093022207);
1071 INSERT INTO t3 VALUES(-8796093022208);
1072 INSERT INTO t3 VALUES(-8796093022209);
1073 INSERT INTO t3 VALUES(-8796093022210);
1074 INSERT INTO t3 VALUES(17592186044414);
1075 INSERT INTO t3 VALUES(17592186044415);
1076 INSERT INTO t3 VALUES(17592186044416);
1077 INSERT INTO t3 VALUES(17592186044417);
1078 INSERT INTO t3 VALUES(17592186044418);
1079 INSERT INTO t3 VALUES(-17592186044414);
1080 INSERT INTO t3 VALUES(-17592186044415);
1081 INSERT INTO t3 VALUES(-17592186044416);
1082 INSERT INTO t3 VALUES(-17592186044417);
1083 INSERT INTO t3 VALUES(-17592186044418);
1084 INSERT INTO t3 VALUES(35184372088830);
1085 INSERT INTO t3 VALUES(35184372088831);
1086 INSERT INTO t3 VALUES(35184372088832);
1087 INSERT INTO t3 VALUES(35184372088833);
1088 INSERT INTO t3 VALUES(35184372088834);
1089 INSERT INTO t3 VALUES(-35184372088830);
1090 INSERT INTO t3 VALUES(-35184372088831);
1091 INSERT INTO t3 VALUES(-35184372088832);
1092 INSERT INTO t3 VALUES(-35184372088833);
1093 INSERT INTO t3 VALUES(-35184372088834);
1094 INSERT INTO t3 VALUES(70368744177662);
1095 INSERT INTO t3 VALUES(70368744177663);
1096 INSERT INTO t3 VALUES(70368744177664);
1097 INSERT INTO t3 VALUES(70368744177665);
1098 INSERT INTO t3 VALUES(70368744177666);
1099 INSERT INTO t3 VALUES(-70368744177662);
1100 INSERT INTO t3 VALUES(-70368744177663);
1101 INSERT INTO t3 VALUES(-70368744177664);
1102 INSERT INTO t3 VALUES(-70368744177665);
1103 INSERT INTO t3 VALUES(-70368744177666);
1104 INSERT INTO t3 VALUES(140737488355326);
1105 INSERT INTO t3 VALUES(140737488355327);
1106 INSERT INTO t3 VALUES(140737488355328);
1107 INSERT INTO t3 VALUES(140737488355329);
1108 INSERT INTO t3 VALUES(140737488355330);
1109 INSERT INTO t3 VALUES(-140737488355326);
1110 INSERT INTO t3 VALUES(-140737488355327);
1111 INSERT INTO t3 VALUES(-140737488355328);
1112 INSERT INTO t3 VALUES(-140737488355329);
1113 INSERT INTO t3 VALUES(-140737488355330);
1114 INSERT INTO t3 VALUES(281474976710654);
1115 INSERT INTO t3 VALUES(281474976710655);
1116 INSERT INTO t3 VALUES(281474976710656);
1117 INSERT INTO t3 VALUES(281474976710657);
1118 INSERT INTO t3 VALUES(281474976710658);
1119 INSERT INTO t3 VALUES(-281474976710654);
1120 INSERT INTO t3 VALUES(-281474976710655);
1121 INSERT INTO t3 VALUES(-281474976710656);
1122 INSERT INTO t3 VALUES(-281474976710657);
1123 INSERT INTO t3 VALUES(-281474976710658);
1124 INSERT INTO t3 VALUES(562949953421310);
1125 INSERT INTO t3 VALUES(562949953421311);
1126 INSERT INTO t3 VALUES(562949953421312);
1127 INSERT INTO t3 VALUES(562949953421313);
1128 INSERT INTO t3 VALUES(562949953421314);
1129 INSERT INTO t3 VALUES(-562949953421310);
1130 INSERT INTO t3 VALUES(-562949953421311);
1131 INSERT INTO t3 VALUES(-562949953421312);
1132 INSERT INTO t3 VALUES(-562949953421313);
1133 INSERT INTO t3 VALUES(-562949953421314);
1134 INSERT INTO t3 VALUES(1125899906842622);
1135 INSERT INTO t3 VALUES(1125899906842623);
1136 INSERT INTO t3 VALUES(1125899906842624);
1137 INSERT INTO t3 VALUES(1125899906842625);
1138 INSERT INTO t3 VALUES(1125899906842626);
1139 INSERT INTO t3 VALUES(-1125899906842622);
1140 INSERT INTO t3 VALUES(-1125899906842623);
1141 INSERT INTO t3 VALUES(-1125899906842624);
1142 INSERT INTO t3 VALUES(-1125899906842625);
1143 INSERT INTO t3 VALUES(-1125899906842626);
1144 INSERT INTO t3 VALUES(2251799813685246);
1145 INSERT INTO t3 VALUES(2251799813685247);
1146 INSERT INTO t3 VALUES(2251799813685248);
1147 INSERT INTO t3 VALUES(2251799813685249);
1148 INSERT INTO t3 VALUES(2251799813685250);
1149 INSERT INTO t3 VALUES(-2251799813685246);
1150 INSERT INTO t3 VALUES(-2251799813685247);
1151 INSERT INTO t3 VALUES(-2251799813685248);
1152 INSERT INTO t3 VALUES(-2251799813685249);
1153 INSERT INTO t3 VALUES(-2251799813685250);
1154 INSERT INTO t3 VALUES(4503599627370494);
1155 INSERT INTO t3 VALUES(4503599627370495);
1156 INSERT INTO t3 VALUES(4503599627370496);
1157 INSERT INTO t3 VALUES(4503599627370497);
1158 INSERT INTO t3 VALUES(4503599627370498);
1159 INSERT INTO t3 VALUES(-4503599627370494);
1160 INSERT INTO t3 VALUES(-4503599627370495);
1161 INSERT INTO t3 VALUES(-4503599627370496);
1162 INSERT INTO t3 VALUES(-4503599627370497);
1163 INSERT INTO t3 VALUES(-4503599627370498);
1164 INSERT INTO t3 VALUES(9007199254740990);
1165 INSERT INTO t3 VALUES(9007199254740991);
1166 INSERT INTO t3 VALUES(9007199254740992);
1167 INSERT INTO t3 VALUES(9007199254740993);
1168 INSERT INTO t3 VALUES(9007199254740994);
1169 INSERT INTO t3 VALUES(-9007199254740990);
1170 INSERT INTO t3 VALUES(-9007199254740991);
1171 INSERT INTO t3 VALUES(-9007199254740992);
1172 INSERT INTO t3 VALUES(-9007199254740993);
1173 INSERT INTO t3 VALUES(-9007199254740994);
1174 INSERT INTO t3 VALUES(18014398509481982);
1175 INSERT INTO t3 VALUES(18014398509481983);
1176 INSERT INTO t3 VALUES(18014398509481984);
1177 INSERT INTO t3 VALUES(18014398509481985);
1178 INSERT INTO t3 VALUES(18014398509481986);
1179 INSERT INTO t3 VALUES(-18014398509481982);
1180 INSERT INTO t3 VALUES(-18014398509481983);
1181 INSERT INTO t3 VALUES(-18014398509481984);
1182 INSERT INTO t3 VALUES(-18014398509481985);
1183 INSERT INTO t3 VALUES(-18014398509481986);
1184 INSERT INTO t3 VALUES(36028797018963966);
1185 INSERT INTO t3 VALUES(36028797018963967);
1186 INSERT INTO t3 VALUES(36028797018963968);
1187 INSERT INTO t3 VALUES(36028797018963969);
1188 INSERT INTO t3 VALUES(36028797018963970);
1189 INSERT INTO t3 VALUES(-36028797018963966);
1190 INSERT INTO t3 VALUES(-36028797018963967);
1191 INSERT INTO t3 VALUES(-36028797018963968);
1192 INSERT INTO t3 VALUES(-36028797018963969);
1193 INSERT INTO t3 VALUES(-36028797018963970);
1194 INSERT INTO t3 VALUES(72057594037927934);
1195 INSERT INTO t3 VALUES(72057594037927935);
1196 INSERT INTO t3 VALUES(72057594037927936);
1197 INSERT INTO t3 VALUES(72057594037927937);
1198 INSERT INTO t3 VALUES(72057594037927938);
1199 INSERT INTO t3 VALUES(-72057594037927934);
1200 INSERT INTO t3 VALUES(-72057594037927935);
1201 INSERT INTO t3 VALUES(-72057594037927936);
1202 INSERT INTO t3 VALUES(-72057594037927937);
1203 INSERT INTO t3 VALUES(-72057594037927938);
1204 INSERT INTO t3 VALUES(144115188075855870);
1205 INSERT INTO t3 VALUES(144115188075855871);
1206 INSERT INTO t3 VALUES(144115188075855872);
1207 INSERT INTO t3 VALUES(144115188075855873);
1208 INSERT INTO t3 VALUES(144115188075855874);
1209 INSERT INTO t3 VALUES(-144115188075855870);
1210 INSERT INTO t3 VALUES(-144115188075855871);
1211 INSERT INTO t3 VALUES(-144115188075855872);
1212 INSERT INTO t3 VALUES(-144115188075855873);
1213 INSERT INTO t3 VALUES(-144115188075855874);
1214 INSERT INTO t3 VALUES(288230376151711742);
1215 INSERT INTO t3 VALUES(288230376151711743);
1216 INSERT INTO t3 VALUES(288230376151711744);
1217 INSERT INTO t3 VALUES(288230376151711745);
1218 INSERT INTO t3 VALUES(288230376151711746);
1219 INSERT INTO t3 VALUES(-288230376151711742);
1220 INSERT INTO t3 VALUES(-288230376151711743);
1221 INSERT INTO t3 VALUES(-288230376151711744);
1222 INSERT INTO t3 VALUES(-288230376151711745);
1223 INSERT INTO t3 VALUES(-288230376151711746);
1224 INSERT INTO t3 VALUES(576460752303423486);
1225 INSERT INTO t3 VALUES(576460752303423487);
1226 INSERT INTO t3 VALUES(576460752303423488);
1227 INSERT INTO t3 VALUES(576460752303423489);
1228 INSERT INTO t3 VALUES(576460752303423490);
1229 INSERT INTO t3 VALUES(-576460752303423486);
1230 INSERT INTO t3 VALUES(-576460752303423487);
1231 INSERT INTO t3 VALUES(-576460752303423488);
1232 INSERT INTO t3 VALUES(-576460752303423489);
1233 INSERT INTO t3 VALUES(-576460752303423490);
1234 INSERT INTO t3 VALUES(1152921504606846974);
1235 INSERT INTO t3 VALUES(1152921504606846975);
1236 INSERT INTO t3 VALUES(1152921504606846976);
1237 INSERT INTO t3 VALUES(1152921504606846977);
1238 INSERT INTO t3 VALUES(1152921504606846978);
1239 INSERT INTO t3 VALUES(-1152921504606846974);
1240 INSERT INTO t3 VALUES(-1152921504606846975);
1241 INSERT INTO t3 VALUES(-1152921504606846976);
1242 INSERT INTO t3 VALUES(-1152921504606846977);
1243 INSERT INTO t3 VALUES(-1152921504606846978);
1244 INSERT INTO t3 VALUES(2305843009213693950);
1245 INSERT INTO t3 VALUES(2305843009213693951);
1246 INSERT INTO t3 VALUES(2305843009213693952);
1247 INSERT INTO t3 VALUES(2305843009213693953);
1248 INSERT INTO t3 VALUES(2305843009213693954);
1249 INSERT INTO t3 VALUES(-2305843009213693950);
1250 INSERT INTO t3 VALUES(-2305843009213693951);
1251 INSERT INTO t3 VALUES(-2305843009213693952);
1252 INSERT INTO t3 VALUES(-2305843009213693953);
1253 INSERT INTO t3 VALUES(-2305843009213693954);
1254 INSERT INTO t3 VALUES(4611686018427387902);
1255 INSERT INTO t3 VALUES(4611686018427387903);
1256 INSERT INTO t3 VALUES(4611686018427387904);
1257 INSERT INTO t3 VALUES(4611686018427387905);
1258 INSERT INTO t3 VALUES(4611686018427387906);
1259 INSERT INTO t3 VALUES(-4611686018427387902);
1260 INSERT INTO t3 VALUES(-4611686018427387903);
1261 INSERT INTO t3 VALUES(-4611686018427387904);
1262 INSERT INTO t3 VALUES(-4611686018427387905);
1263 INSERT INTO t3 VALUES(-4611686018427387906);
1264 INSERT INTO t3 VALUES(9223372036854775806);
1265 INSERT INTO t3 VALUES(9223372036854775807);
1266 INSERT INTO t3 VALUES(-9223372036854775806);
1267 INSERT INTO t3 VALUES(-9223372036854775807);
1268 INSERT INTO t3 VALUES(-9223372036854775808);
1269 SELECT x FROM t3 ORDER BY x;
1270 }
1271} {-9223372036854775808\
1272-9223372036854775807\
1273-9223372036854775806\
1274-4611686018427387906\
1275-4611686018427387905\
1276-4611686018427387904\
1277-4611686018427387903\
1278-4611686018427387902\
1279-2305843009213693954\
1280-2305843009213693953\
1281-2305843009213693952\
1282-2305843009213693951\
1283-2305843009213693950\
1284-1152921504606846978\
1285-1152921504606846977\
1286-1152921504606846976\
1287-1152921504606846975\
1288-1152921504606846974\
1289-576460752303423490\
1290-576460752303423489\
1291-576460752303423488\
1292-576460752303423487\
1293-576460752303423486\
1294-288230376151711746\
1295-288230376151711745\
1296-288230376151711744\
1297-288230376151711743\
1298-288230376151711742\
1299-144115188075855874\
1300-144115188075855873\
1301-144115188075855872\
1302-144115188075855871\
1303-144115188075855870\
1304-72057594037927938\
1305-72057594037927937\
1306-72057594037927936\
1307-72057594037927935\
1308-72057594037927934\
1309-36028797018963970\
1310-36028797018963969\
1311-36028797018963968\
1312-36028797018963967\
1313-36028797018963966\
1314-18014398509481986\
1315-18014398509481985\
1316-18014398509481984\
1317-18014398509481983\
1318-18014398509481982\
1319-9007199254740994\
1320-9007199254740993\
1321-9007199254740992\
1322-9007199254740991\
1323-9007199254740990\
1324-4503599627370498\
1325-4503599627370497\
1326-4503599627370496\
1327-4503599627370495\
1328-4503599627370494\
1329-2251799813685250\
1330-2251799813685249\
1331-2251799813685248\
1332-2251799813685247\
1333-2251799813685246\
1334-1125899906842626\
1335-1125899906842625\
1336-1125899906842624\
1337-1125899906842623\
1338-1125899906842622\
1339-562949953421314\
1340-562949953421313\
1341-562949953421312\
1342-562949953421311\
1343-562949953421310\
1344-281474976710658\
1345-281474976710657\
1346-281474976710656\
1347-281474976710655\
1348-281474976710654\
1349-140737488355330\
1350-140737488355329\
1351-140737488355328\
1352-140737488355327\
1353-140737488355326\
1354-70368744177666\
1355-70368744177665\
1356-70368744177664\
1357-70368744177663\
1358-70368744177662\
1359-35184372088834\
1360-35184372088833\
1361-35184372088832\
1362-35184372088831\
1363-35184372088830\
1364-17592186044418\
1365-17592186044417\
1366-17592186044416\
1367-17592186044415\
1368-17592186044414\
1369-8796093022210\
1370-8796093022209\
1371-8796093022208\
1372-8796093022207\
1373-8796093022206\
1374-4398046511106\
1375-4398046511105\
1376-4398046511104\
1377-4398046511103\
1378-4398046511102\
1379-2199023255554\
1380-2199023255553\
1381-2199023255552\
1382-2199023255551\
1383-2199023255550\
1384-1099511627778\
1385-1099511627777\
1386-1099511627776\
1387-1099511627775\
1388-1099511627774\
1389-549755813890\
1390-549755813889\
1391-549755813888\
1392-549755813887\
1393-549755813886\
1394-274877906946\
1395-274877906945\
1396-274877906944\
1397-274877906943\
1398-274877906942\
1399-137438953474\
1400-137438953473\
1401-137438953472\
1402-137438953471\
1403-137438953470\
1404-68719476738\
1405-68719476737\
1406-68719476736\
1407-68719476735\
1408-68719476734\
1409-34359738370\
1410-34359738369\
1411-34359738368\
1412-34359738367\
1413-34359738366\
1414-17179869186\
1415-17179869185\
1416-17179869184\
1417-17179869183\
1418-17179869182\
1419-8589934594\
1420-8589934593\
1421-8589934592\
1422-8589934591\
1423-8589934590\
1424-4294967298\
1425-4294967297\
1426-4294967296\
1427-4294967295\
1428-4294967294\
1429-2147483650\
1430-2147483649\
1431-2147483648\
1432-2147483647\
1433-2147483646\
1434-1073741826\
1435-1073741825\
1436-1073741824\
1437-1073741823\
1438-1073741822\
1439-536870914\
1440-536870913\
1441-536870912\
1442-536870911\
1443-536870910\
1444-268435458\
1445-268435457\
1446-268435456\
1447-268435455\
1448-268435454\
1449-134217730\
1450-134217729\
1451-134217728\
1452-134217727\
1453-134217726\
1454-67108866\
1455-67108865\
1456-67108864\
1457-67108863\
1458-67108862\
1459-33554434\
1460-33554433\
1461-33554432\
1462-33554431\
1463-33554430\
1464-16777218\
1465-16777217\
1466-16777216\
1467-16777215\
1468-16777214\
1469-8388610\
1470-8388609\
1471-8388608\
1472-8388607\
1473-8388606\
1474-4194306\
1475-4194305\
1476-4194304\
1477-4194303\
1478-4194302\
1479-2097154\
1480-2097153\
1481-2097152\
1482-2097151\
1483-2097150\
1484-1048578\
1485-1048577\
1486-1048576\
1487-1048575\
1488-1048574\
1489-524290\
1490-524289\
1491-524288\
1492-524287\
1493-524286\
1494-262146\
1495-262145\
1496-262144\
1497-262143\
1498-262142\
1499-131074\
1500-131073\
1501-131072\
1502-131071\
1503-131070\
1504-65538\
1505-65537\
1506-65536\
1507-65535\
1508-65534\
1509-32770\
1510-32769\
1511-32768\
1512-32767\
1513-32766\
1514-16386\
1515-16385\
1516-16384\
1517-16383\
1518-16382\
1519-8194\
1520-8193\
1521-8192\
1522-8191\
1523-8190\
1524-4098\
1525-4097\
1526-4096\
1527-4095\
1528-4094\
1529-2050\
1530-2049\
1531-2048\
1532-2047\
1533-2046\
1534-1026\
1535-1025\
1536-1024\
1537-1023\
1538-1022\
1539-514\
1540-513\
1541-512\
1542-511\
1543-510\
1544-258\
1545-257\
1546-256\
1547-255\
1548-254\
1549-130\
1550-129\
1551-128\
1552-127\
1553-126\
1554-66\
1555-65\
1556-64\
1557-63\
1558-62\
1559-34\
1560-33\
1561-32\
1562-31\
1563-30\
1564-18\
1565-17\
1566-16\
1567-15\
1568-14\
1569-13\
1570-12\
1571-11\
1572-10\
1573-9\
1574-8\
1575-7\
1576-6\
1577-5\
1578-4\
1579-3\
1580-2\
1581-1\
15820\
15831\
15842\
15853\
15864\
15875\
15886\
15897\
15908\
15919\
159210\
159311\
159412\
159513\
159614\
159715\
159816\
159917\
160018\
160130\
160231\
160332\
160433\
160534\
160662\
160763\
160864\
160965\
161066\
1611126\
1612127\
1613128\
1614129\
1615130\
1616254\
1617255\
1618256\
1619257\
1620258\
1621510\
1622511\
1623512\
1624513\
1625514\
16261022\
16271023\
16281024\
16291025\
16301026\
16312046\
16322047\
16332048\
16342049\
16352050\
16364094\
16374095\
16384096\
16394097\
16404098\
16418190\
16428191\
16438192\
16448193\
16458194\
164616382\
164716383\
164816384\
164916385\
165016386\
165132766\
165232767\
165332768\
165432769\
165532770\
165665534\
165765535\
165865536\
165965537\
166065538\
1661131070\
1662131071\
1663131072\
1664131073\
1665131074\
1666262142\
1667262143\
1668262144\
1669262145\
1670262146\
1671524286\
1672524287\
1673524288\
1674524289\
1675524290\
16761048574\
16771048575\
16781048576\
16791048577\
16801048578\
16812097150\
16822097151\
16832097152\
16842097153\
16852097154\
16864194302\
16874194303\
16884194304\
16894194305\
16904194306\
16918388606\
16928388607\
16938388608\
16948388609\
16958388610\
169616777214\
169716777215\
169816777216\
169916777217\
170016777218\
170133554430\
170233554431\
170333554432\
170433554433\
170533554434\
170667108862\
170767108863\
170867108864\
170967108865\
171067108866\
1711134217726\
1712134217727\
1713134217728\
1714134217729\
1715134217730\
1716268435454\
1717268435455\
1718268435456\
1719268435457\
1720268435458\
1721536870910\
1722536870911\
1723536870912\
1724536870913\
1725536870914\
17261073741822\
17271073741823\
17281073741824\
17291073741825\
17301073741826\
17312147483646\
17322147483647\
17332147483648\
17342147483649\
17352147483650\
17364294967294\
17374294967295\
17384294967296\
17394294967297\
17404294967298\
17418589934590\
17428589934591\
17438589934592\
17448589934593\
17458589934594\
174617179869182\
174717179869183\
174817179869184\
174917179869185\
175017179869186\
175134359738366\
175234359738367\
175334359738368\
175434359738369\
175534359738370\
175668719476734\
175768719476735\
175868719476736\
175968719476737\
176068719476738\
1761137438953470\
1762137438953471\
1763137438953472\
1764137438953473\
1765137438953474\
1766274877906942\
1767274877906943\
1768274877906944\
1769274877906945\
1770274877906946\
1771549755813886\
1772549755813887\
1773549755813888\
1774549755813889\
1775549755813890\
17761099511627774\
17771099511627775\
17781099511627776\
17791099511627777\
17801099511627778\
17812199023255550\
17822199023255551\
17832199023255552\
17842199023255553\
17852199023255554\
17864398046511102\
17874398046511103\
17884398046511104\
17894398046511105\
17904398046511106\
17918796093022206\
17928796093022207\
17938796093022208\
17948796093022209\
17958796093022210\
179617592186044414\
179717592186044415\
179817592186044416\
179917592186044417\
180017592186044418\
180135184372088830\
180235184372088831\
180335184372088832\
180435184372088833\
180535184372088834\
180670368744177662\
180770368744177663\
180870368744177664\
180970368744177665\
181070368744177666\
1811140737488355326\
1812140737488355327\
1813140737488355328\
1814140737488355329\
1815140737488355330\
1816281474976710654\
1817281474976710655\
1818281474976710656\
1819281474976710657\
1820281474976710658\
1821562949953421310\
1822562949953421311\
1823562949953421312\
1824562949953421313\
1825562949953421314\
18261125899906842622\
18271125899906842623\
18281125899906842624\
18291125899906842625\
18301125899906842626\
18312251799813685246\
18322251799813685247\
18332251799813685248\
18342251799813685249\
18352251799813685250\
18364503599627370494\
18374503599627370495\
18384503599627370496\
18394503599627370497\
18404503599627370498\
18419007199254740990\
18429007199254740991\
18439007199254740992\
18449007199254740993\
18459007199254740994\
184618014398509481982\
184718014398509481983\
184818014398509481984\
184918014398509481985\
185018014398509481986\
185136028797018963966\
185236028797018963967\
185336028797018963968\
185436028797018963969\
185536028797018963970\
185672057594037927934\
185772057594037927935\
185872057594037927936\
185972057594037927937\
186072057594037927938\
1861144115188075855870\
1862144115188075855871\
1863144115188075855872\
1864144115188075855873\
1865144115188075855874\
1866288230376151711742\
1867288230376151711743\
1868288230376151711744\
1869288230376151711745\
1870288230376151711746\
1871576460752303423486\
1872576460752303423487\
1873576460752303423488\
1874576460752303423489\
1875576460752303423490\
18761152921504606846974\
18771152921504606846975\
18781152921504606846976\
18791152921504606846977\
18801152921504606846978\
18812305843009213693950\
18822305843009213693951\
18832305843009213693952\
18842305843009213693953\
18852305843009213693954\
18864611686018427387902\
18874611686018427387903\
18884611686018427387904\
18894611686018427387905\
18904611686018427387906\
18919223372036854775806\
18929223372036854775807}
danielk1977003c1ff2008-07-29 10:26:45 +00001893
1894finish_test