| # 2005 Mar 16 |
| # |
| # The author disclaims copyright to this source code. In place of |
| # a legal notice, here is a blessing: |
| # |
| # May you do good and not evil. |
| # May you find forgiveness for yourself and forgive others. |
| # May you share freely, never taking more than you give. |
| # |
| #*********************************************************************** |
| # This file implements regression tests for SQLite library. |
| # |
| # This file implements tests for miscellanous features that were |
| # left out of other test files. |
| # |
| # $Id: misc5.test,v 1.22 2008/07/29 10:26:45 danielk1977 Exp $ |
| |
| set testdir [file dirname $argv0] |
| source $testdir/tester.tcl |
| |
| # Build records using the MakeRecord opcode such that the size of the |
| # header is at the transition point in the size of a varint. |
| # |
| # This test causes an assertion failure or a buffer overrun in version |
| # 3.1.5 and earlier. |
| # |
| for {set i 120} {$i<140} {incr i} { |
| do_test misc5-1.$i { |
| catchsql {DROP TABLE t1} |
| set sql1 {CREATE TABLE t1} |
| set sql2 {INSERT INTO t1 VALUES} |
| set sep ( |
| for {set j 0} {$j<$i} {incr j} { |
| append sql1 ${sep}a$j |
| append sql2 ${sep}$j |
| set sep , |
| } |
| append sql1 {);} |
| append sql2 {);} |
| execsql $sql1$sql2 |
| } {} |
| } |
| |
| # Make sure large integers are stored correctly. |
| # |
| ifcapable conflict { |
| do_test misc5-2.1 { |
| execsql { |
| create table t2(x unique); |
| insert into t2 values(1); |
| insert or ignore into t2 select x*2 from t2; |
| insert or ignore into t2 select x*4 from t2; |
| insert or ignore into t2 select x*16 from t2; |
| insert or ignore into t2 select x*256 from t2; |
| insert or ignore into t2 select x*65536 from t2; |
| insert or ignore into t2 select x*2147483648 from t2; |
| insert or ignore into t2 select x-1 from t2; |
| insert or ignore into t2 select x+1 from t2; |
| insert or ignore into t2 select -x from t2; |
| select count(*) from t2; |
| } |
| } 371 |
| } else { |
| do_test misc5-2.1 { |
| execsql { |
| BEGIN; |
| create table t2(x unique); |
| create table t2_temp(x); |
| insert into t2_temp values(1); |
| insert into t2_temp select x*2 from t2_temp; |
| insert into t2_temp select x*4 from t2_temp; |
| insert into t2_temp select x*16 from t2_temp; |
| insert into t2_temp select x*256 from t2_temp; |
| insert into t2_temp select x*65536 from t2_temp; |
| insert into t2_temp select x*2147483648 from t2_temp; |
| insert into t2_temp select x-1 from t2_temp; |
| insert into t2_temp select x+1 from t2_temp; |
| insert into t2_temp select -x from t2_temp; |
| INSERT INTO t2 SELECT DISTINCT(x) FROM t2_temp; |
| DROP TABLE t2_temp; |
| COMMIT; |
| select count(*) from t2; |
| } |
| } 371 |
| } |
| do_test misc5-2.2 { |
| execsql { |
| select x from t2 order by x; |
| } |
| } \ |
| "-4611686018427387905\ |
| -4611686018427387904\ |
| -4611686018427387903\ |
| -2305843009213693953\ |
| -2305843009213693952\ |
| -2305843009213693951\ |
| -1152921504606846977\ |
| -1152921504606846976\ |
| -1152921504606846975\ |
| -576460752303423489\ |
| -576460752303423488\ |
| -576460752303423487\ |
| -288230376151711745\ |
| -288230376151711744\ |
| -288230376151711743\ |
| -144115188075855873\ |
| -144115188075855872\ |
| -144115188075855871\ |
| -72057594037927937\ |
| -72057594037927936\ |
| -72057594037927935\ |
| -36028797018963969\ |
| -36028797018963968\ |
| -36028797018963967\ |
| -18014398509481985\ |
| -18014398509481984\ |
| -18014398509481983\ |
| -9007199254740993\ |
| -9007199254740992\ |
| -9007199254740991\ |
| -4503599627370497\ |
| -4503599627370496\ |
| -4503599627370495\ |
| -2251799813685249\ |
| -2251799813685248\ |
| -2251799813685247\ |
| -1125899906842625\ |
| -1125899906842624\ |
| -1125899906842623\ |
| -562949953421313\ |
| -562949953421312\ |
| -562949953421311\ |
| -281474976710657\ |
| -281474976710656\ |
| -281474976710655\ |
| -140737488355329\ |
| -140737488355328\ |
| -140737488355327\ |
| -70368744177665\ |
| -70368744177664\ |
| -70368744177663\ |
| -35184372088833\ |
| -35184372088832\ |
| -35184372088831\ |
| -17592186044417\ |
| -17592186044416\ |
| -17592186044415\ |
| -8796093022209\ |
| -8796093022208\ |
| -8796093022207\ |
| -4398046511105\ |
| -4398046511104\ |
| -4398046511103\ |
| -2199023255553\ |
| -2199023255552\ |
| -2199023255551\ |
| -1099511627777\ |
| -1099511627776\ |
| -1099511627775\ |
| -549755813889\ |
| -549755813888\ |
| -549755813887\ |
| -274877906945\ |
| -274877906944\ |
| -274877906943\ |
| -137438953473\ |
| -137438953472\ |
| -137438953471\ |
| -68719476737\ |
| -68719476736\ |
| -68719476735\ |
| -34359738369\ |
| -34359738368\ |
| -34359738367\ |
| -17179869185\ |
| -17179869184\ |
| -17179869183\ |
| -8589934593\ |
| -8589934592\ |
| -8589934591\ |
| -4294967297\ |
| -4294967296\ |
| -4294967295\ |
| -2147483649\ |
| -2147483648\ |
| -2147483647\ |
| -1073741825\ |
| -1073741824\ |
| -1073741823\ |
| -536870913\ |
| -536870912\ |
| -536870911\ |
| -268435457\ |
| -268435456\ |
| -268435455\ |
| -134217729\ |
| -134217728\ |
| -134217727\ |
| -67108865\ |
| -67108864\ |
| -67108863\ |
| -33554433\ |
| -33554432\ |
| -33554431\ |
| -16777217\ |
| -16777216\ |
| -16777215\ |
| -8388609\ |
| -8388608\ |
| -8388607\ |
| -4194305\ |
| -4194304\ |
| -4194303\ |
| -2097153\ |
| -2097152\ |
| -2097151\ |
| -1048577\ |
| -1048576\ |
| -1048575\ |
| -524289\ |
| -524288\ |
| -524287\ |
| -262145\ |
| -262144\ |
| -262143\ |
| -131073\ |
| -131072\ |
| -131071\ |
| -65537\ |
| -65536\ |
| -65535\ |
| -32769\ |
| -32768\ |
| -32767\ |
| -16385\ |
| -16384\ |
| -16383\ |
| -8193\ |
| -8192\ |
| -8191\ |
| -4097\ |
| -4096\ |
| -4095\ |
| -2049\ |
| -2048\ |
| -2047\ |
| -1025\ |
| -1024\ |
| -1023\ |
| -513\ |
| -512\ |
| -511\ |
| -257\ |
| -256\ |
| -255\ |
| -129\ |
| -128\ |
| -127\ |
| -65\ |
| -64\ |
| -63\ |
| -33\ |
| -32\ |
| -31\ |
| -17\ |
| -16\ |
| -15\ |
| -9\ |
| -8\ |
| -7\ |
| -5\ |
| -4\ |
| -3\ |
| -2\ |
| -1\ |
| 0\ |
| 1\ |
| 2\ |
| 3\ |
| 4\ |
| 5\ |
| 7\ |
| 8\ |
| 9\ |
| 15\ |
| 16\ |
| 17\ |
| 31\ |
| 32\ |
| 33\ |
| 63\ |
| 64\ |
| 65\ |
| 127\ |
| 128\ |
| 129\ |
| 255\ |
| 256\ |
| 257\ |
| 511\ |
| 512\ |
| 513\ |
| 1023\ |
| 1024\ |
| 1025\ |
| 2047\ |
| 2048\ |
| 2049\ |
| 4095\ |
| 4096\ |
| 4097\ |
| 8191\ |
| 8192\ |
| 8193\ |
| 16383\ |
| 16384\ |
| 16385\ |
| 32767\ |
| 32768\ |
| 32769\ |
| 65535\ |
| 65536\ |
| 65537\ |
| 131071\ |
| 131072\ |
| 131073\ |
| 262143\ |
| 262144\ |
| 262145\ |
| 524287\ |
| 524288\ |
| 524289\ |
| 1048575\ |
| 1048576\ |
| 1048577\ |
| 2097151\ |
| 2097152\ |
| 2097153\ |
| 4194303\ |
| 4194304\ |
| 4194305\ |
| 8388607\ |
| 8388608\ |
| 8388609\ |
| 16777215\ |
| 16777216\ |
| 16777217\ |
| 33554431\ |
| 33554432\ |
| 33554433\ |
| 67108863\ |
| 67108864\ |
| 67108865\ |
| 134217727\ |
| 134217728\ |
| 134217729\ |
| 268435455\ |
| 268435456\ |
| 268435457\ |
| 536870911\ |
| 536870912\ |
| 536870913\ |
| 1073741823\ |
| 1073741824\ |
| 1073741825\ |
| 2147483647\ |
| 2147483648\ |
| 2147483649\ |
| 4294967295\ |
| 4294967296\ |
| 4294967297\ |
| 8589934591\ |
| 8589934592\ |
| 8589934593\ |
| 17179869183\ |
| 17179869184\ |
| 17179869185\ |
| 34359738367\ |
| 34359738368\ |
| 34359738369\ |
| 68719476735\ |
| 68719476736\ |
| 68719476737\ |
| 137438953471\ |
| 137438953472\ |
| 137438953473\ |
| 274877906943\ |
| 274877906944\ |
| 274877906945\ |
| 549755813887\ |
| 549755813888\ |
| 549755813889\ |
| 1099511627775\ |
| 1099511627776\ |
| 1099511627777\ |
| 2199023255551\ |
| 2199023255552\ |
| 2199023255553\ |
| 4398046511103\ |
| 4398046511104\ |
| 4398046511105\ |
| 8796093022207\ |
| 8796093022208\ |
| 8796093022209\ |
| 17592186044415\ |
| 17592186044416\ |
| 17592186044417\ |
| 35184372088831\ |
| 35184372088832\ |
| 35184372088833\ |
| 70368744177663\ |
| 70368744177664\ |
| 70368744177665\ |
| 140737488355327\ |
| 140737488355328\ |
| 140737488355329\ |
| 281474976710655\ |
| 281474976710656\ |
| 281474976710657\ |
| 562949953421311\ |
| 562949953421312\ |
| 562949953421313\ |
| 1125899906842623\ |
| 1125899906842624\ |
| 1125899906842625\ |
| 2251799813685247\ |
| 2251799813685248\ |
| 2251799813685249\ |
| 4503599627370495\ |
| 4503599627370496\ |
| 4503599627370497\ |
| 9007199254740991\ |
| 9007199254740992\ |
| 9007199254740993\ |
| 18014398509481983\ |
| 18014398509481984\ |
| 18014398509481985\ |
| 36028797018963967\ |
| 36028797018963968\ |
| 36028797018963969\ |
| 72057594037927935\ |
| 72057594037927936\ |
| 72057594037927937\ |
| 144115188075855871\ |
| 144115188075855872\ |
| 144115188075855873\ |
| 288230376151711743\ |
| 288230376151711744\ |
| 288230376151711745\ |
| 576460752303423487\ |
| 576460752303423488\ |
| 576460752303423489\ |
| 1152921504606846975\ |
| 1152921504606846976\ |
| 1152921504606846977\ |
| 2305843009213693951\ |
| 2305843009213693952\ |
| 2305843009213693953\ |
| 4611686018427387903\ |
| 4611686018427387904\ |
| 4611686018427387905" |
| |
| # Ticket #1210. Do proper reference counting of Table structures |
| # so that deeply nested SELECT statements can be flattened correctly. |
| # |
| ifcapable subquery { |
| do_test misc5-3.1 { |
| execsql { |
| CREATE TABLE songs(songid, artist, timesplayed); |
| INSERT INTO songs VALUES(1,'one',1); |
| INSERT INTO songs VALUES(2,'one',2); |
| INSERT INTO songs VALUES(3,'two',3); |
| INSERT INTO songs VALUES(4,'three',5); |
| INSERT INTO songs VALUES(5,'one',7); |
| INSERT INTO songs VALUES(6,'two',11); |
| SELECT DISTINCT artist |
| FROM ( |
| SELECT DISTINCT artist |
| FROM songs |
| WHERE songid IN ( |
| SELECT songid |
| FROM songs |
| WHERE LOWER(artist) = ( |
| -- This sub-query is indeterminate. Because there is no ORDER BY, |
| -- it may return 'one', 'two' or 'three'. Because of this, the |
| -- outermost parent query may correctly return any of 'one', 'two' |
| -- or 'three' as well. |
| SELECT DISTINCT LOWER(artist) |
| FROM ( |
| -- This sub-query returns the table: |
| -- |
| -- two 14 |
| -- one 10 |
| -- three 5 |
| -- |
| SELECT DISTINCT artist,sum(timesplayed) AS total |
| FROM songs |
| GROUP BY LOWER(artist) |
| ORDER BY total DESC |
| LIMIT 10 |
| ) |
| WHERE artist <> '' |
| ) |
| ) |
| ) |
| ORDER BY LOWER(artist) ASC; |
| } |
| } {one} |
| } |
| |
| # Ticket #1370. Do not overwrite small files (less than 1024 bytes) |
| # when trying to open them as a database. |
| # |
| if {[permutation] == ""} { |
| do_test misc5-4.1 { |
| db close |
| file delete -force test.db |
| set fd [open test.db w] |
| puts $fd "This is not really a database" |
| close $fd |
| sqlite3 db test.db |
| catchsql { |
| CREATE TABLE t1(a,b,c); |
| } |
| } {1 {file is encrypted or is not a database}} |
| } |
| |
| # Ticket #1371. Allow floating point numbers of the form .N or N. |
| # |
| do_test misc5-5.1 { |
| execsql {SELECT .1 } |
| } 0.1 |
| do_test misc5-5.2 { |
| execsql {SELECT 2. } |
| } 2.0 |
| do_test misc5-5.3 { |
| execsql {SELECT 3.e0 } |
| } 3.0 |
| do_test misc5-5.4 { |
| execsql {SELECT .4e+1} |
| } 4.0 |
| |
| # Ticket #1582. Ensure that an unknown table in a LIMIT clause applied to |
| # a UNION ALL query causes an error, not a crash. |
| # |
| db close |
| file delete -force test.db |
| sqlite3 db test.db |
| ifcapable subquery&&compound { |
| do_test misc5-6.1 { |
| catchsql { |
| SELECT * FROM sqlite_master |
| UNION ALL |
| SELECT * FROM sqlite_master |
| LIMIT (SELECT count(*) FROM blah); |
| } |
| } {1 {no such table: blah}} |
| do_test misc5-6.2 { |
| execsql { |
| CREATE TABLE logs(msg TEXT, timestamp INTEGER, dbtime TEXT); |
| } |
| catchsql { |
| SELECT * FROM logs WHERE logs.oid >= (SELECT head FROM logs_base) |
| UNION ALL |
| SELECT * FROM logs |
| LIMIT (SELECT lmt FROM logs_base) ; |
| } |
| } {1 {no such table: logs_base}} |
| } |
| |
| # Overflow the lemon parser stack by providing an overly complex |
| # expression. Make sure that the overflow is detected and reported. |
| # |
| do_test misc5-7.1 { |
| execsql {CREATE TABLE t1(x)} |
| set sql "INSERT INTO t1 VALUES(" |
| set tail "" |
| for {set i 0} {$i<200} {incr i} { |
| append sql "(1+" |
| append tail ")" |
| } |
| append sql 2$tail |
| catchsql $sql |
| } {1 {parser stack overflow}} |
| |
| # Ticket #1911 |
| # |
| ifcapable compound { |
| do_test misc5-9.1 { |
| execsql { |
| SELECT name, type FROM sqlite_master WHERE name IS NULL |
| UNION |
| SELECT type, name FROM sqlite_master WHERE type IS NULL |
| ORDER BY 1, 2, 1, 2, 1, 2 |
| } |
| } {} |
| do_test misc5-9.2 { |
| execsql { |
| SELECT name, type FROM sqlite_master WHERE name IS NULL |
| UNION |
| SELECT type, name FROM sqlite_master WHERE type IS NULL |
| ORDER BY 1, 2, 1, 2, 1, 2, 1, 2, 1, 2, 1, 2, 1, 2, 1, 2, 1, 2 |
| } |
| } {} |
| } |
| |
| # Ticket #1912. Make the tokenizer require a space after a numeric |
| # literal. |
| # |
| do_test misc5-10.1 { |
| catchsql { |
| SELECT 123abc |
| } |
| } {1 {unrecognized token: "123abc"}} |
| do_test misc5-10.2 { |
| catchsql { |
| SELECT 1*123.4e5ghi; |
| } |
| } {1 {unrecognized token: "123.4e5ghi"}} |
| |
| |
| # Additional integer encoding tests. |
| # |
| do_test misc5-11.1 { |
| db eval { |
| CREATE TABLE t3(x); |
| INSERT INTO t3 VALUES(-18); |
| INSERT INTO t3 VALUES(-17); |
| INSERT INTO t3 VALUES(-16); |
| INSERT INTO t3 VALUES(-15); |
| INSERT INTO t3 VALUES(-14); |
| INSERT INTO t3 VALUES(-13); |
| INSERT INTO t3 VALUES(-12); |
| INSERT INTO t3 VALUES(-11); |
| INSERT INTO t3 VALUES(-10); |
| INSERT INTO t3 VALUES(-9); |
| INSERT INTO t3 VALUES(-8); |
| INSERT INTO t3 VALUES(-7); |
| INSERT INTO t3 VALUES(-6); |
| INSERT INTO t3 VALUES(-5); |
| INSERT INTO t3 VALUES(-4); |
| INSERT INTO t3 VALUES(-3); |
| INSERT INTO t3 VALUES(-2); |
| INSERT INTO t3 VALUES(-1); |
| INSERT INTO t3 VALUES(0); |
| INSERT INTO t3 VALUES(1); |
| INSERT INTO t3 VALUES(2); |
| INSERT INTO t3 VALUES(3); |
| INSERT INTO t3 VALUES(4); |
| INSERT INTO t3 VALUES(5); |
| INSERT INTO t3 VALUES(6); |
| INSERT INTO t3 VALUES(7); |
| INSERT INTO t3 VALUES(8); |
| INSERT INTO t3 VALUES(9); |
| INSERT INTO t3 VALUES(10); |
| INSERT INTO t3 VALUES(11); |
| INSERT INTO t3 VALUES(12); |
| INSERT INTO t3 VALUES(13); |
| INSERT INTO t3 VALUES(14); |
| INSERT INTO t3 VALUES(15); |
| INSERT INTO t3 VALUES(16); |
| INSERT INTO t3 VALUES(17); |
| INSERT INTO t3 VALUES(18); |
| INSERT INTO t3 VALUES(30); |
| INSERT INTO t3 VALUES(31); |
| INSERT INTO t3 VALUES(32); |
| INSERT INTO t3 VALUES(33); |
| INSERT INTO t3 VALUES(34); |
| INSERT INTO t3 VALUES(-30); |
| INSERT INTO t3 VALUES(-31); |
| INSERT INTO t3 VALUES(-32); |
| INSERT INTO t3 VALUES(-33); |
| INSERT INTO t3 VALUES(-34); |
| INSERT INTO t3 VALUES(62); |
| INSERT INTO t3 VALUES(63); |
| INSERT INTO t3 VALUES(64); |
| INSERT INTO t3 VALUES(65); |
| INSERT INTO t3 VALUES(66); |
| INSERT INTO t3 VALUES(-62); |
| INSERT INTO t3 VALUES(-63); |
| INSERT INTO t3 VALUES(-64); |
| INSERT INTO t3 VALUES(-65); |
| INSERT INTO t3 VALUES(-66); |
| INSERT INTO t3 VALUES(126); |
| INSERT INTO t3 VALUES(127); |
| INSERT INTO t3 VALUES(128); |
| INSERT INTO t3 VALUES(129); |
| INSERT INTO t3 VALUES(130); |
| INSERT INTO t3 VALUES(-126); |
| INSERT INTO t3 VALUES(-127); |
| INSERT INTO t3 VALUES(-128); |
| INSERT INTO t3 VALUES(-129); |
| INSERT INTO t3 VALUES(-130); |
| INSERT INTO t3 VALUES(254); |
| INSERT INTO t3 VALUES(255); |
| INSERT INTO t3 VALUES(256); |
| INSERT INTO t3 VALUES(257); |
| INSERT INTO t3 VALUES(258); |
| INSERT INTO t3 VALUES(-254); |
| INSERT INTO t3 VALUES(-255); |
| INSERT INTO t3 VALUES(-256); |
| INSERT INTO t3 VALUES(-257); |
| INSERT INTO t3 VALUES(-258); |
| INSERT INTO t3 VALUES(510); |
| INSERT INTO t3 VALUES(511); |
| INSERT INTO t3 VALUES(512); |
| INSERT INTO t3 VALUES(513); |
| INSERT INTO t3 VALUES(514); |
| INSERT INTO t3 VALUES(-510); |
| INSERT INTO t3 VALUES(-511); |
| INSERT INTO t3 VALUES(-512); |
| INSERT INTO t3 VALUES(-513); |
| INSERT INTO t3 VALUES(-514); |
| INSERT INTO t3 VALUES(1022); |
| INSERT INTO t3 VALUES(1023); |
| INSERT INTO t3 VALUES(1024); |
| INSERT INTO t3 VALUES(1025); |
| INSERT INTO t3 VALUES(1026); |
| INSERT INTO t3 VALUES(-1022); |
| INSERT INTO t3 VALUES(-1023); |
| INSERT INTO t3 VALUES(-1024); |
| INSERT INTO t3 VALUES(-1025); |
| INSERT INTO t3 VALUES(-1026); |
| INSERT INTO t3 VALUES(2046); |
| INSERT INTO t3 VALUES(2047); |
| INSERT INTO t3 VALUES(2048); |
| INSERT INTO t3 VALUES(2049); |
| INSERT INTO t3 VALUES(2050); |
| INSERT INTO t3 VALUES(-2046); |
| INSERT INTO t3 VALUES(-2047); |
| INSERT INTO t3 VALUES(-2048); |
| INSERT INTO t3 VALUES(-2049); |
| INSERT INTO t3 VALUES(-2050); |
| INSERT INTO t3 VALUES(4094); |
| INSERT INTO t3 VALUES(4095); |
| INSERT INTO t3 VALUES(4096); |
| INSERT INTO t3 VALUES(4097); |
| INSERT INTO t3 VALUES(4098); |
| INSERT INTO t3 VALUES(-4094); |
| INSERT INTO t3 VALUES(-4095); |
| INSERT INTO t3 VALUES(-4096); |
| INSERT INTO t3 VALUES(-4097); |
| INSERT INTO t3 VALUES(-4098); |
| INSERT INTO t3 VALUES(8190); |
| INSERT INTO t3 VALUES(8191); |
| INSERT INTO t3 VALUES(8192); |
| INSERT INTO t3 VALUES(8193); |
| INSERT INTO t3 VALUES(8194); |
| INSERT INTO t3 VALUES(-8190); |
| INSERT INTO t3 VALUES(-8191); |
| INSERT INTO t3 VALUES(-8192); |
| INSERT INTO t3 VALUES(-8193); |
| INSERT INTO t3 VALUES(-8194); |
| INSERT INTO t3 VALUES(16382); |
| INSERT INTO t3 VALUES(16383); |
| INSERT INTO t3 VALUES(16384); |
| INSERT INTO t3 VALUES(16385); |
| INSERT INTO t3 VALUES(16386); |
| INSERT INTO t3 VALUES(-16382); |
| INSERT INTO t3 VALUES(-16383); |
| INSERT INTO t3 VALUES(-16384); |
| INSERT INTO t3 VALUES(-16385); |
| INSERT INTO t3 VALUES(-16386); |
| INSERT INTO t3 VALUES(32766); |
| INSERT INTO t3 VALUES(32767); |
| INSERT INTO t3 VALUES(32768); |
| INSERT INTO t3 VALUES(32769); |
| INSERT INTO t3 VALUES(32770); |
| INSERT INTO t3 VALUES(-32766); |
| INSERT INTO t3 VALUES(-32767); |
| INSERT INTO t3 VALUES(-32768); |
| INSERT INTO t3 VALUES(-32769); |
| INSERT INTO t3 VALUES(-32770); |
| INSERT INTO t3 VALUES(65534); |
| INSERT INTO t3 VALUES(65535); |
| INSERT INTO t3 VALUES(65536); |
| INSERT INTO t3 VALUES(65537); |
| INSERT INTO t3 VALUES(65538); |
| INSERT INTO t3 VALUES(-65534); |
| INSERT INTO t3 VALUES(-65535); |
| INSERT INTO t3 VALUES(-65536); |
| INSERT INTO t3 VALUES(-65537); |
| INSERT INTO t3 VALUES(-65538); |
| INSERT INTO t3 VALUES(131070); |
| INSERT INTO t3 VALUES(131071); |
| INSERT INTO t3 VALUES(131072); |
| INSERT INTO t3 VALUES(131073); |
| INSERT INTO t3 VALUES(131074); |
| INSERT INTO t3 VALUES(-131070); |
| INSERT INTO t3 VALUES(-131071); |
| INSERT INTO t3 VALUES(-131072); |
| INSERT INTO t3 VALUES(-131073); |
| INSERT INTO t3 VALUES(-131074); |
| INSERT INTO t3 VALUES(262142); |
| INSERT INTO t3 VALUES(262143); |
| INSERT INTO t3 VALUES(262144); |
| INSERT INTO t3 VALUES(262145); |
| INSERT INTO t3 VALUES(262146); |
| INSERT INTO t3 VALUES(-262142); |
| INSERT INTO t3 VALUES(-262143); |
| INSERT INTO t3 VALUES(-262144); |
| INSERT INTO t3 VALUES(-262145); |
| INSERT INTO t3 VALUES(-262146); |
| INSERT INTO t3 VALUES(524286); |
| INSERT INTO t3 VALUES(524287); |
| INSERT INTO t3 VALUES(524288); |
| INSERT INTO t3 VALUES(524289); |
| INSERT INTO t3 VALUES(524290); |
| INSERT INTO t3 VALUES(-524286); |
| INSERT INTO t3 VALUES(-524287); |
| INSERT INTO t3 VALUES(-524288); |
| INSERT INTO t3 VALUES(-524289); |
| INSERT INTO t3 VALUES(-524290); |
| INSERT INTO t3 VALUES(1048574); |
| INSERT INTO t3 VALUES(1048575); |
| INSERT INTO t3 VALUES(1048576); |
| INSERT INTO t3 VALUES(1048577); |
| INSERT INTO t3 VALUES(1048578); |
| INSERT INTO t3 VALUES(-1048574); |
| INSERT INTO t3 VALUES(-1048575); |
| INSERT INTO t3 VALUES(-1048576); |
| INSERT INTO t3 VALUES(-1048577); |
| INSERT INTO t3 VALUES(-1048578); |
| INSERT INTO t3 VALUES(2097150); |
| INSERT INTO t3 VALUES(2097151); |
| INSERT INTO t3 VALUES(2097152); |
| INSERT INTO t3 VALUES(2097153); |
| INSERT INTO t3 VALUES(2097154); |
| INSERT INTO t3 VALUES(-2097150); |
| INSERT INTO t3 VALUES(-2097151); |
| INSERT INTO t3 VALUES(-2097152); |
| INSERT INTO t3 VALUES(-2097153); |
| INSERT INTO t3 VALUES(-2097154); |
| INSERT INTO t3 VALUES(4194302); |
| INSERT INTO t3 VALUES(4194303); |
| INSERT INTO t3 VALUES(4194304); |
| INSERT INTO t3 VALUES(4194305); |
| INSERT INTO t3 VALUES(4194306); |
| INSERT INTO t3 VALUES(-4194302); |
| INSERT INTO t3 VALUES(-4194303); |
| INSERT INTO t3 VALUES(-4194304); |
| INSERT INTO t3 VALUES(-4194305); |
| INSERT INTO t3 VALUES(-4194306); |
| INSERT INTO t3 VALUES(8388606); |
| INSERT INTO t3 VALUES(8388607); |
| INSERT INTO t3 VALUES(8388608); |
| INSERT INTO t3 VALUES(8388609); |
| INSERT INTO t3 VALUES(8388610); |
| INSERT INTO t3 VALUES(-8388606); |
| INSERT INTO t3 VALUES(-8388607); |
| INSERT INTO t3 VALUES(-8388608); |
| INSERT INTO t3 VALUES(-8388609); |
| INSERT INTO t3 VALUES(-8388610); |
| INSERT INTO t3 VALUES(16777214); |
| INSERT INTO t3 VALUES(16777215); |
| INSERT INTO t3 VALUES(16777216); |
| INSERT INTO t3 VALUES(16777217); |
| INSERT INTO t3 VALUES(16777218); |
| INSERT INTO t3 VALUES(-16777214); |
| INSERT INTO t3 VALUES(-16777215); |
| INSERT INTO t3 VALUES(-16777216); |
| INSERT INTO t3 VALUES(-16777217); |
| INSERT INTO t3 VALUES(-16777218); |
| INSERT INTO t3 VALUES(33554430); |
| INSERT INTO t3 VALUES(33554431); |
| INSERT INTO t3 VALUES(33554432); |
| INSERT INTO t3 VALUES(33554433); |
| INSERT INTO t3 VALUES(33554434); |
| INSERT INTO t3 VALUES(-33554430); |
| INSERT INTO t3 VALUES(-33554431); |
| INSERT INTO t3 VALUES(-33554432); |
| INSERT INTO t3 VALUES(-33554433); |
| INSERT INTO t3 VALUES(-33554434); |
| INSERT INTO t3 VALUES(67108862); |
| INSERT INTO t3 VALUES(67108863); |
| INSERT INTO t3 VALUES(67108864); |
| INSERT INTO t3 VALUES(67108865); |
| INSERT INTO t3 VALUES(67108866); |
| INSERT INTO t3 VALUES(-67108862); |
| INSERT INTO t3 VALUES(-67108863); |
| INSERT INTO t3 VALUES(-67108864); |
| INSERT INTO t3 VALUES(-67108865); |
| INSERT INTO t3 VALUES(-67108866); |
| INSERT INTO t3 VALUES(134217726); |
| INSERT INTO t3 VALUES(134217727); |
| INSERT INTO t3 VALUES(134217728); |
| INSERT INTO t3 VALUES(134217729); |
| INSERT INTO t3 VALUES(134217730); |
| INSERT INTO t3 VALUES(-134217726); |
| INSERT INTO t3 VALUES(-134217727); |
| INSERT INTO t3 VALUES(-134217728); |
| INSERT INTO t3 VALUES(-134217729); |
| INSERT INTO t3 VALUES(-134217730); |
| INSERT INTO t3 VALUES(268435454); |
| INSERT INTO t3 VALUES(268435455); |
| INSERT INTO t3 VALUES(268435456); |
| INSERT INTO t3 VALUES(268435457); |
| INSERT INTO t3 VALUES(268435458); |
| INSERT INTO t3 VALUES(-268435454); |
| INSERT INTO t3 VALUES(-268435455); |
| INSERT INTO t3 VALUES(-268435456); |
| INSERT INTO t3 VALUES(-268435457); |
| INSERT INTO t3 VALUES(-268435458); |
| INSERT INTO t3 VALUES(536870910); |
| INSERT INTO t3 VALUES(536870911); |
| INSERT INTO t3 VALUES(536870912); |
| INSERT INTO t3 VALUES(536870913); |
| INSERT INTO t3 VALUES(536870914); |
| INSERT INTO t3 VALUES(-536870910); |
| INSERT INTO t3 VALUES(-536870911); |
| INSERT INTO t3 VALUES(-536870912); |
| INSERT INTO t3 VALUES(-536870913); |
| INSERT INTO t3 VALUES(-536870914); |
| INSERT INTO t3 VALUES(1073741822); |
| INSERT INTO t3 VALUES(1073741823); |
| INSERT INTO t3 VALUES(1073741824); |
| INSERT INTO t3 VALUES(1073741825); |
| INSERT INTO t3 VALUES(1073741826); |
| INSERT INTO t3 VALUES(-1073741822); |
| INSERT INTO t3 VALUES(-1073741823); |
| INSERT INTO t3 VALUES(-1073741824); |
| INSERT INTO t3 VALUES(-1073741825); |
| INSERT INTO t3 VALUES(-1073741826); |
| INSERT INTO t3 VALUES(2147483646); |
| INSERT INTO t3 VALUES(2147483647); |
| INSERT INTO t3 VALUES(2147483648); |
| INSERT INTO t3 VALUES(2147483649); |
| INSERT INTO t3 VALUES(2147483650); |
| INSERT INTO t3 VALUES(-2147483646); |
| INSERT INTO t3 VALUES(-2147483647); |
| INSERT INTO t3 VALUES(-2147483648); |
| INSERT INTO t3 VALUES(-2147483649); |
| INSERT INTO t3 VALUES(-2147483650); |
| INSERT INTO t3 VALUES(4294967294); |
| INSERT INTO t3 VALUES(4294967295); |
| INSERT INTO t3 VALUES(4294967296); |
| INSERT INTO t3 VALUES(4294967297); |
| INSERT INTO t3 VALUES(4294967298); |
| INSERT INTO t3 VALUES(-4294967294); |
| INSERT INTO t3 VALUES(-4294967295); |
| INSERT INTO t3 VALUES(-4294967296); |
| INSERT INTO t3 VALUES(-4294967297); |
| INSERT INTO t3 VALUES(-4294967298); |
| INSERT INTO t3 VALUES(8589934590); |
| INSERT INTO t3 VALUES(8589934591); |
| INSERT INTO t3 VALUES(8589934592); |
| INSERT INTO t3 VALUES(8589934593); |
| INSERT INTO t3 VALUES(8589934594); |
| INSERT INTO t3 VALUES(-8589934590); |
| INSERT INTO t3 VALUES(-8589934591); |
| INSERT INTO t3 VALUES(-8589934592); |
| INSERT INTO t3 VALUES(-8589934593); |
| INSERT INTO t3 VALUES(-8589934594); |
| INSERT INTO t3 VALUES(17179869182); |
| INSERT INTO t3 VALUES(17179869183); |
| INSERT INTO t3 VALUES(17179869184); |
| INSERT INTO t3 VALUES(17179869185); |
| INSERT INTO t3 VALUES(17179869186); |
| INSERT INTO t3 VALUES(-17179869182); |
| INSERT INTO t3 VALUES(-17179869183); |
| INSERT INTO t3 VALUES(-17179869184); |
| INSERT INTO t3 VALUES(-17179869185); |
| INSERT INTO t3 VALUES(-17179869186); |
| INSERT INTO t3 VALUES(34359738366); |
| INSERT INTO t3 VALUES(34359738367); |
| INSERT INTO t3 VALUES(34359738368); |
| INSERT INTO t3 VALUES(34359738369); |
| INSERT INTO t3 VALUES(34359738370); |
| INSERT INTO t3 VALUES(-34359738366); |
| INSERT INTO t3 VALUES(-34359738367); |
| INSERT INTO t3 VALUES(-34359738368); |
| INSERT INTO t3 VALUES(-34359738369); |
| INSERT INTO t3 VALUES(-34359738370); |
| INSERT INTO t3 VALUES(68719476734); |
| INSERT INTO t3 VALUES(68719476735); |
| INSERT INTO t3 VALUES(68719476736); |
| INSERT INTO t3 VALUES(68719476737); |
| INSERT INTO t3 VALUES(68719476738); |
| INSERT INTO t3 VALUES(-68719476734); |
| INSERT INTO t3 VALUES(-68719476735); |
| INSERT INTO t3 VALUES(-68719476736); |
| INSERT INTO t3 VALUES(-68719476737); |
| INSERT INTO t3 VALUES(-68719476738); |
| INSERT INTO t3 VALUES(137438953470); |
| INSERT INTO t3 VALUES(137438953471); |
| INSERT INTO t3 VALUES(137438953472); |
| INSERT INTO t3 VALUES(137438953473); |
| INSERT INTO t3 VALUES(137438953474); |
| INSERT INTO t3 VALUES(-137438953470); |
| INSERT INTO t3 VALUES(-137438953471); |
| INSERT INTO t3 VALUES(-137438953472); |
| INSERT INTO t3 VALUES(-137438953473); |
| INSERT INTO t3 VALUES(-137438953474); |
| INSERT INTO t3 VALUES(274877906942); |
| INSERT INTO t3 VALUES(274877906943); |
| INSERT INTO t3 VALUES(274877906944); |
| INSERT INTO t3 VALUES(274877906945); |
| INSERT INTO t3 VALUES(274877906946); |
| INSERT INTO t3 VALUES(-274877906942); |
| INSERT INTO t3 VALUES(-274877906943); |
| INSERT INTO t3 VALUES(-274877906944); |
| INSERT INTO t3 VALUES(-274877906945); |
| INSERT INTO t3 VALUES(-274877906946); |
| INSERT INTO t3 VALUES(549755813886); |
| INSERT INTO t3 VALUES(549755813887); |
| INSERT INTO t3 VALUES(549755813888); |
| INSERT INTO t3 VALUES(549755813889); |
| INSERT INTO t3 VALUES(549755813890); |
| INSERT INTO t3 VALUES(-549755813886); |
| INSERT INTO t3 VALUES(-549755813887); |
| INSERT INTO t3 VALUES(-549755813888); |
| INSERT INTO t3 VALUES(-549755813889); |
| INSERT INTO t3 VALUES(-549755813890); |
| INSERT INTO t3 VALUES(1099511627774); |
| INSERT INTO t3 VALUES(1099511627775); |
| INSERT INTO t3 VALUES(1099511627776); |
| INSERT INTO t3 VALUES(1099511627777); |
| INSERT INTO t3 VALUES(1099511627778); |
| INSERT INTO t3 VALUES(-1099511627774); |
| INSERT INTO t3 VALUES(-1099511627775); |
| INSERT INTO t3 VALUES(-1099511627776); |
| INSERT INTO t3 VALUES(-1099511627777); |
| INSERT INTO t3 VALUES(-1099511627778); |
| INSERT INTO t3 VALUES(2199023255550); |
| INSERT INTO t3 VALUES(2199023255551); |
| INSERT INTO t3 VALUES(2199023255552); |
| INSERT INTO t3 VALUES(2199023255553); |
| INSERT INTO t3 VALUES(2199023255554); |
| INSERT INTO t3 VALUES(-2199023255550); |
| INSERT INTO t3 VALUES(-2199023255551); |
| INSERT INTO t3 VALUES(-2199023255552); |
| INSERT INTO t3 VALUES(-2199023255553); |
| INSERT INTO t3 VALUES(-2199023255554); |
| INSERT INTO t3 VALUES(4398046511102); |
| INSERT INTO t3 VALUES(4398046511103); |
| INSERT INTO t3 VALUES(4398046511104); |
| INSERT INTO t3 VALUES(4398046511105); |
| INSERT INTO t3 VALUES(4398046511106); |
| INSERT INTO t3 VALUES(-4398046511102); |
| INSERT INTO t3 VALUES(-4398046511103); |
| INSERT INTO t3 VALUES(-4398046511104); |
| INSERT INTO t3 VALUES(-4398046511105); |
| INSERT INTO t3 VALUES(-4398046511106); |
| INSERT INTO t3 VALUES(8796093022206); |
| INSERT INTO t3 VALUES(8796093022207); |
| INSERT INTO t3 VALUES(8796093022208); |
| INSERT INTO t3 VALUES(8796093022209); |
| INSERT INTO t3 VALUES(8796093022210); |
| INSERT INTO t3 VALUES(-8796093022206); |
| INSERT INTO t3 VALUES(-8796093022207); |
| INSERT INTO t3 VALUES(-8796093022208); |
| INSERT INTO t3 VALUES(-8796093022209); |
| INSERT INTO t3 VALUES(-8796093022210); |
| INSERT INTO t3 VALUES(17592186044414); |
| INSERT INTO t3 VALUES(17592186044415); |
| INSERT INTO t3 VALUES(17592186044416); |
| INSERT INTO t3 VALUES(17592186044417); |
| INSERT INTO t3 VALUES(17592186044418); |
| INSERT INTO t3 VALUES(-17592186044414); |
| INSERT INTO t3 VALUES(-17592186044415); |
| INSERT INTO t3 VALUES(-17592186044416); |
| INSERT INTO t3 VALUES(-17592186044417); |
| INSERT INTO t3 VALUES(-17592186044418); |
| INSERT INTO t3 VALUES(35184372088830); |
| INSERT INTO t3 VALUES(35184372088831); |
| INSERT INTO t3 VALUES(35184372088832); |
| INSERT INTO t3 VALUES(35184372088833); |
| INSERT INTO t3 VALUES(35184372088834); |
| INSERT INTO t3 VALUES(-35184372088830); |
| INSERT INTO t3 VALUES(-35184372088831); |
| INSERT INTO t3 VALUES(-35184372088832); |
| INSERT INTO t3 VALUES(-35184372088833); |
| INSERT INTO t3 VALUES(-35184372088834); |
| INSERT INTO t3 VALUES(70368744177662); |
| INSERT INTO t3 VALUES(70368744177663); |
| INSERT INTO t3 VALUES(70368744177664); |
| INSERT INTO t3 VALUES(70368744177665); |
| INSERT INTO t3 VALUES(70368744177666); |
| INSERT INTO t3 VALUES(-70368744177662); |
| INSERT INTO t3 VALUES(-70368744177663); |
| INSERT INTO t3 VALUES(-70368744177664); |
| INSERT INTO t3 VALUES(-70368744177665); |
| INSERT INTO t3 VALUES(-70368744177666); |
| INSERT INTO t3 VALUES(140737488355326); |
| INSERT INTO t3 VALUES(140737488355327); |
| INSERT INTO t3 VALUES(140737488355328); |
| INSERT INTO t3 VALUES(140737488355329); |
| INSERT INTO t3 VALUES(140737488355330); |
| INSERT INTO t3 VALUES(-140737488355326); |
| INSERT INTO t3 VALUES(-140737488355327); |
| INSERT INTO t3 VALUES(-140737488355328); |
| INSERT INTO t3 VALUES(-140737488355329); |
| INSERT INTO t3 VALUES(-140737488355330); |
| INSERT INTO t3 VALUES(281474976710654); |
| INSERT INTO t3 VALUES(281474976710655); |
| INSERT INTO t3 VALUES(281474976710656); |
| INSERT INTO t3 VALUES(281474976710657); |
| INSERT INTO t3 VALUES(281474976710658); |
| INSERT INTO t3 VALUES(-281474976710654); |
| INSERT INTO t3 VALUES(-281474976710655); |
| INSERT INTO t3 VALUES(-281474976710656); |
| INSERT INTO t3 VALUES(-281474976710657); |
| INSERT INTO t3 VALUES(-281474976710658); |
| INSERT INTO t3 VALUES(562949953421310); |
| INSERT INTO t3 VALUES(562949953421311); |
| INSERT INTO t3 VALUES(562949953421312); |
| INSERT INTO t3 VALUES(562949953421313); |
| INSERT INTO t3 VALUES(562949953421314); |
| INSERT INTO t3 VALUES(-562949953421310); |
| INSERT INTO t3 VALUES(-562949953421311); |
| INSERT INTO t3 VALUES(-562949953421312); |
| INSERT INTO t3 VALUES(-562949953421313); |
| INSERT INTO t3 VALUES(-562949953421314); |
| INSERT INTO t3 VALUES(1125899906842622); |
| INSERT INTO t3 VALUES(1125899906842623); |
| INSERT INTO t3 VALUES(1125899906842624); |
| INSERT INTO t3 VALUES(1125899906842625); |
| INSERT INTO t3 VALUES(1125899906842626); |
| INSERT INTO t3 VALUES(-1125899906842622); |
| INSERT INTO t3 VALUES(-1125899906842623); |
| INSERT INTO t3 VALUES(-1125899906842624); |
| INSERT INTO t3 VALUES(-1125899906842625); |
| INSERT INTO t3 VALUES(-1125899906842626); |
| INSERT INTO t3 VALUES(2251799813685246); |
| INSERT INTO t3 VALUES(2251799813685247); |
| INSERT INTO t3 VALUES(2251799813685248); |
| INSERT INTO t3 VALUES(2251799813685249); |
| INSERT INTO t3 VALUES(2251799813685250); |
| INSERT INTO t3 VALUES(-2251799813685246); |
| INSERT INTO t3 VALUES(-2251799813685247); |
| INSERT INTO t3 VALUES(-2251799813685248); |
| INSERT INTO t3 VALUES(-2251799813685249); |
| INSERT INTO t3 VALUES(-2251799813685250); |
| INSERT INTO t3 VALUES(4503599627370494); |
| INSERT INTO t3 VALUES(4503599627370495); |
| INSERT INTO t3 VALUES(4503599627370496); |
| INSERT INTO t3 VALUES(4503599627370497); |
| INSERT INTO t3 VALUES(4503599627370498); |
| INSERT INTO t3 VALUES(-4503599627370494); |
| INSERT INTO t3 VALUES(-4503599627370495); |
| INSERT INTO t3 VALUES(-4503599627370496); |
| INSERT INTO t3 VALUES(-4503599627370497); |
| INSERT INTO t3 VALUES(-4503599627370498); |
| INSERT INTO t3 VALUES(9007199254740990); |
| INSERT INTO t3 VALUES(9007199254740991); |
| INSERT INTO t3 VALUES(9007199254740992); |
| INSERT INTO t3 VALUES(9007199254740993); |
| INSERT INTO t3 VALUES(9007199254740994); |
| INSERT INTO t3 VALUES(-9007199254740990); |
| INSERT INTO t3 VALUES(-9007199254740991); |
| INSERT INTO t3 VALUES(-9007199254740992); |
| INSERT INTO t3 VALUES(-9007199254740993); |
| INSERT INTO t3 VALUES(-9007199254740994); |
| INSERT INTO t3 VALUES(18014398509481982); |
| INSERT INTO t3 VALUES(18014398509481983); |
| INSERT INTO t3 VALUES(18014398509481984); |
| INSERT INTO t3 VALUES(18014398509481985); |
| INSERT INTO t3 VALUES(18014398509481986); |
| INSERT INTO t3 VALUES(-18014398509481982); |
| INSERT INTO t3 VALUES(-18014398509481983); |
| INSERT INTO t3 VALUES(-18014398509481984); |
| INSERT INTO t3 VALUES(-18014398509481985); |
| INSERT INTO t3 VALUES(-18014398509481986); |
| INSERT INTO t3 VALUES(36028797018963966); |
| INSERT INTO t3 VALUES(36028797018963967); |
| INSERT INTO t3 VALUES(36028797018963968); |
| INSERT INTO t3 VALUES(36028797018963969); |
| INSERT INTO t3 VALUES(36028797018963970); |
| INSERT INTO t3 VALUES(-36028797018963966); |
| INSERT INTO t3 VALUES(-36028797018963967); |
| INSERT INTO t3 VALUES(-36028797018963968); |
| INSERT INTO t3 VALUES(-36028797018963969); |
| INSERT INTO t3 VALUES(-36028797018963970); |
| INSERT INTO t3 VALUES(72057594037927934); |
| INSERT INTO t3 VALUES(72057594037927935); |
| INSERT INTO t3 VALUES(72057594037927936); |
| INSERT INTO t3 VALUES(72057594037927937); |
| INSERT INTO t3 VALUES(72057594037927938); |
| INSERT INTO t3 VALUES(-72057594037927934); |
| INSERT INTO t3 VALUES(-72057594037927935); |
| INSERT INTO t3 VALUES(-72057594037927936); |
| INSERT INTO t3 VALUES(-72057594037927937); |
| INSERT INTO t3 VALUES(-72057594037927938); |
| INSERT INTO t3 VALUES(144115188075855870); |
| INSERT INTO t3 VALUES(144115188075855871); |
| INSERT INTO t3 VALUES(144115188075855872); |
| INSERT INTO t3 VALUES(144115188075855873); |
| INSERT INTO t3 VALUES(144115188075855874); |
| INSERT INTO t3 VALUES(-144115188075855870); |
| INSERT INTO t3 VALUES(-144115188075855871); |
| INSERT INTO t3 VALUES(-144115188075855872); |
| INSERT INTO t3 VALUES(-144115188075855873); |
| INSERT INTO t3 VALUES(-144115188075855874); |
| INSERT INTO t3 VALUES(288230376151711742); |
| INSERT INTO t3 VALUES(288230376151711743); |
| INSERT INTO t3 VALUES(288230376151711744); |
| INSERT INTO t3 VALUES(288230376151711745); |
| INSERT INTO t3 VALUES(288230376151711746); |
| INSERT INTO t3 VALUES(-288230376151711742); |
| INSERT INTO t3 VALUES(-288230376151711743); |
| INSERT INTO t3 VALUES(-288230376151711744); |
| INSERT INTO t3 VALUES(-288230376151711745); |
| INSERT INTO t3 VALUES(-288230376151711746); |
| INSERT INTO t3 VALUES(576460752303423486); |
| INSERT INTO t3 VALUES(576460752303423487); |
| INSERT INTO t3 VALUES(576460752303423488); |
| INSERT INTO t3 VALUES(576460752303423489); |
| INSERT INTO t3 VALUES(576460752303423490); |
| INSERT INTO t3 VALUES(-576460752303423486); |
| INSERT INTO t3 VALUES(-576460752303423487); |
| INSERT INTO t3 VALUES(-576460752303423488); |
| INSERT INTO t3 VALUES(-576460752303423489); |
| INSERT INTO t3 VALUES(-576460752303423490); |
| INSERT INTO t3 VALUES(1152921504606846974); |
| INSERT INTO t3 VALUES(1152921504606846975); |
| INSERT INTO t3 VALUES(1152921504606846976); |
| INSERT INTO t3 VALUES(1152921504606846977); |
| INSERT INTO t3 VALUES(1152921504606846978); |
| INSERT INTO t3 VALUES(-1152921504606846974); |
| INSERT INTO t3 VALUES(-1152921504606846975); |
| INSERT INTO t3 VALUES(-1152921504606846976); |
| INSERT INTO t3 VALUES(-1152921504606846977); |
| INSERT INTO t3 VALUES(-1152921504606846978); |
| INSERT INTO t3 VALUES(2305843009213693950); |
| INSERT INTO t3 VALUES(2305843009213693951); |
| INSERT INTO t3 VALUES(2305843009213693952); |
| INSERT INTO t3 VALUES(2305843009213693953); |
| INSERT INTO t3 VALUES(2305843009213693954); |
| INSERT INTO t3 VALUES(-2305843009213693950); |
| INSERT INTO t3 VALUES(-2305843009213693951); |
| INSERT INTO t3 VALUES(-2305843009213693952); |
| INSERT INTO t3 VALUES(-2305843009213693953); |
| INSERT INTO t3 VALUES(-2305843009213693954); |
| INSERT INTO t3 VALUES(4611686018427387902); |
| INSERT INTO t3 VALUES(4611686018427387903); |
| INSERT INTO t3 VALUES(4611686018427387904); |
| INSERT INTO t3 VALUES(4611686018427387905); |
| INSERT INTO t3 VALUES(4611686018427387906); |
| INSERT INTO t3 VALUES(-4611686018427387902); |
| INSERT INTO t3 VALUES(-4611686018427387903); |
| INSERT INTO t3 VALUES(-4611686018427387904); |
| INSERT INTO t3 VALUES(-4611686018427387905); |
| INSERT INTO t3 VALUES(-4611686018427387906); |
| INSERT INTO t3 VALUES(9223372036854775806); |
| INSERT INTO t3 VALUES(9223372036854775807); |
| INSERT INTO t3 VALUES(-9223372036854775806); |
| INSERT INTO t3 VALUES(-9223372036854775807); |
| INSERT INTO t3 VALUES(-9223372036854775808); |
| SELECT x FROM t3 ORDER BY x; |
| } |
| } {-9223372036854775808\ |
| -9223372036854775807\ |
| -9223372036854775806\ |
| -4611686018427387906\ |
| -4611686018427387905\ |
| -4611686018427387904\ |
| -4611686018427387903\ |
| -4611686018427387902\ |
| -2305843009213693954\ |
| -2305843009213693953\ |
| -2305843009213693952\ |
| -2305843009213693951\ |
| -2305843009213693950\ |
| -1152921504606846978\ |
| -1152921504606846977\ |
| -1152921504606846976\ |
| -1152921504606846975\ |
| -1152921504606846974\ |
| -576460752303423490\ |
| -576460752303423489\ |
| -576460752303423488\ |
| -576460752303423487\ |
| -576460752303423486\ |
| -288230376151711746\ |
| -288230376151711745\ |
| -288230376151711744\ |
| -288230376151711743\ |
| -288230376151711742\ |
| -144115188075855874\ |
| -144115188075855873\ |
| -144115188075855872\ |
| -144115188075855871\ |
| -144115188075855870\ |
| -72057594037927938\ |
| -72057594037927937\ |
| -72057594037927936\ |
| -72057594037927935\ |
| -72057594037927934\ |
| -36028797018963970\ |
| -36028797018963969\ |
| -36028797018963968\ |
| -36028797018963967\ |
| -36028797018963966\ |
| -18014398509481986\ |
| -18014398509481985\ |
| -18014398509481984\ |
| -18014398509481983\ |
| -18014398509481982\ |
| -9007199254740994\ |
| -9007199254740993\ |
| -9007199254740992\ |
| -9007199254740991\ |
| -9007199254740990\ |
| -4503599627370498\ |
| -4503599627370497\ |
| -4503599627370496\ |
| -4503599627370495\ |
| -4503599627370494\ |
| -2251799813685250\ |
| -2251799813685249\ |
| -2251799813685248\ |
| -2251799813685247\ |
| -2251799813685246\ |
| -1125899906842626\ |
| -1125899906842625\ |
| -1125899906842624\ |
| -1125899906842623\ |
| -1125899906842622\ |
| -562949953421314\ |
| -562949953421313\ |
| -562949953421312\ |
| -562949953421311\ |
| -562949953421310\ |
| -281474976710658\ |
| -281474976710657\ |
| -281474976710656\ |
| -281474976710655\ |
| -281474976710654\ |
| -140737488355330\ |
| -140737488355329\ |
| -140737488355328\ |
| -140737488355327\ |
| -140737488355326\ |
| -70368744177666\ |
| -70368744177665\ |
| -70368744177664\ |
| -70368744177663\ |
| -70368744177662\ |
| -35184372088834\ |
| -35184372088833\ |
| -35184372088832\ |
| -35184372088831\ |
| -35184372088830\ |
| -17592186044418\ |
| -17592186044417\ |
| -17592186044416\ |
| -17592186044415\ |
| -17592186044414\ |
| -8796093022210\ |
| -8796093022209\ |
| -8796093022208\ |
| -8796093022207\ |
| -8796093022206\ |
| -4398046511106\ |
| -4398046511105\ |
| -4398046511104\ |
| -4398046511103\ |
| -4398046511102\ |
| -2199023255554\ |
| -2199023255553\ |
| -2199023255552\ |
| -2199023255551\ |
| -2199023255550\ |
| -1099511627778\ |
| -1099511627777\ |
| -1099511627776\ |
| -1099511627775\ |
| -1099511627774\ |
| -549755813890\ |
| -549755813889\ |
| -549755813888\ |
| -549755813887\ |
| -549755813886\ |
| -274877906946\ |
| -274877906945\ |
| -274877906944\ |
| -274877906943\ |
| -274877906942\ |
| -137438953474\ |
| -137438953473\ |
| -137438953472\ |
| -137438953471\ |
| -137438953470\ |
| -68719476738\ |
| -68719476737\ |
| -68719476736\ |
| -68719476735\ |
| -68719476734\ |
| -34359738370\ |
| -34359738369\ |
| -34359738368\ |
| -34359738367\ |
| -34359738366\ |
| -17179869186\ |
| -17179869185\ |
| -17179869184\ |
| -17179869183\ |
| -17179869182\ |
| -8589934594\ |
| -8589934593\ |
| -8589934592\ |
| -8589934591\ |
| -8589934590\ |
| -4294967298\ |
| -4294967297\ |
| -4294967296\ |
| -4294967295\ |
| -4294967294\ |
| -2147483650\ |
| -2147483649\ |
| -2147483648\ |
| -2147483647\ |
| -2147483646\ |
| -1073741826\ |
| -1073741825\ |
| -1073741824\ |
| -1073741823\ |
| -1073741822\ |
| -536870914\ |
| -536870913\ |
| -536870912\ |
| -536870911\ |
| -536870910\ |
| -268435458\ |
| -268435457\ |
| -268435456\ |
| -268435455\ |
| -268435454\ |
| -134217730\ |
| -134217729\ |
| -134217728\ |
| -134217727\ |
| -134217726\ |
| -67108866\ |
| -67108865\ |
| -67108864\ |
| -67108863\ |
| -67108862\ |
| -33554434\ |
| -33554433\ |
| -33554432\ |
| -33554431\ |
| -33554430\ |
| -16777218\ |
| -16777217\ |
| -16777216\ |
| -16777215\ |
| -16777214\ |
| -8388610\ |
| -8388609\ |
| -8388608\ |
| -8388607\ |
| -8388606\ |
| -4194306\ |
| -4194305\ |
| -4194304\ |
| -4194303\ |
| -4194302\ |
| -2097154\ |
| -2097153\ |
| -2097152\ |
| -2097151\ |
| -2097150\ |
| -1048578\ |
| -1048577\ |
| -1048576\ |
| -1048575\ |
| -1048574\ |
| -524290\ |
| -524289\ |
| -524288\ |
| -524287\ |
| -524286\ |
| -262146\ |
| -262145\ |
| -262144\ |
| -262143\ |
| -262142\ |
| -131074\ |
| -131073\ |
| -131072\ |
| -131071\ |
| -131070\ |
| -65538\ |
| -65537\ |
| -65536\ |
| -65535\ |
| -65534\ |
| -32770\ |
| -32769\ |
| -32768\ |
| -32767\ |
| -32766\ |
| -16386\ |
| -16385\ |
| -16384\ |
| -16383\ |
| -16382\ |
| -8194\ |
| -8193\ |
| -8192\ |
| -8191\ |
| -8190\ |
| -4098\ |
| -4097\ |
| -4096\ |
| -4095\ |
| -4094\ |
| -2050\ |
| -2049\ |
| -2048\ |
| -2047\ |
| -2046\ |
| -1026\ |
| -1025\ |
| -1024\ |
| -1023\ |
| -1022\ |
| -514\ |
| -513\ |
| -512\ |
| -511\ |
| -510\ |
| -258\ |
| -257\ |
| -256\ |
| -255\ |
| -254\ |
| -130\ |
| -129\ |
| -128\ |
| -127\ |
| -126\ |
| -66\ |
| -65\ |
| -64\ |
| -63\ |
| -62\ |
| -34\ |
| -33\ |
| -32\ |
| -31\ |
| -30\ |
| -18\ |
| -17\ |
| -16\ |
| -15\ |
| -14\ |
| -13\ |
| -12\ |
| -11\ |
| -10\ |
| -9\ |
| -8\ |
| -7\ |
| -6\ |
| -5\ |
| -4\ |
| -3\ |
| -2\ |
| -1\ |
| 0\ |
| 1\ |
| 2\ |
| 3\ |
| 4\ |
| 5\ |
| 6\ |
| 7\ |
| 8\ |
| 9\ |
| 10\ |
| 11\ |
| 12\ |
| 13\ |
| 14\ |
| 15\ |
| 16\ |
| 17\ |
| 18\ |
| 30\ |
| 31\ |
| 32\ |
| 33\ |
| 34\ |
| 62\ |
| 63\ |
| 64\ |
| 65\ |
| 66\ |
| 126\ |
| 127\ |
| 128\ |
| 129\ |
| 130\ |
| 254\ |
| 255\ |
| 256\ |
| 257\ |
| 258\ |
| 510\ |
| 511\ |
| 512\ |
| 513\ |
| 514\ |
| 1022\ |
| 1023\ |
| 1024\ |
| 1025\ |
| 1026\ |
| 2046\ |
| 2047\ |
| 2048\ |
| 2049\ |
| 2050\ |
| 4094\ |
| 4095\ |
| 4096\ |
| 4097\ |
| 4098\ |
| 8190\ |
| 8191\ |
| 8192\ |
| 8193\ |
| 8194\ |
| 16382\ |
| 16383\ |
| 16384\ |
| 16385\ |
| 16386\ |
| 32766\ |
| 32767\ |
| 32768\ |
| 32769\ |
| 32770\ |
| 65534\ |
| 65535\ |
| 65536\ |
| 65537\ |
| 65538\ |
| 131070\ |
| 131071\ |
| 131072\ |
| 131073\ |
| 131074\ |
| 262142\ |
| 262143\ |
| 262144\ |
| 262145\ |
| 262146\ |
| 524286\ |
| 524287\ |
| 524288\ |
| 524289\ |
| 524290\ |
| 1048574\ |
| 1048575\ |
| 1048576\ |
| 1048577\ |
| 1048578\ |
| 2097150\ |
| 2097151\ |
| 2097152\ |
| 2097153\ |
| 2097154\ |
| 4194302\ |
| 4194303\ |
| 4194304\ |
| 4194305\ |
| 4194306\ |
| 8388606\ |
| 8388607\ |
| 8388608\ |
| 8388609\ |
| 8388610\ |
| 16777214\ |
| 16777215\ |
| 16777216\ |
| 16777217\ |
| 16777218\ |
| 33554430\ |
| 33554431\ |
| 33554432\ |
| 33554433\ |
| 33554434\ |
| 67108862\ |
| 67108863\ |
| 67108864\ |
| 67108865\ |
| 67108866\ |
| 134217726\ |
| 134217727\ |
| 134217728\ |
| 134217729\ |
| 134217730\ |
| 268435454\ |
| 268435455\ |
| 268435456\ |
| 268435457\ |
| 268435458\ |
| 536870910\ |
| 536870911\ |
| 536870912\ |
| 536870913\ |
| 536870914\ |
| 1073741822\ |
| 1073741823\ |
| 1073741824\ |
| 1073741825\ |
| 1073741826\ |
| 2147483646\ |
| 2147483647\ |
| 2147483648\ |
| 2147483649\ |
| 2147483650\ |
| 4294967294\ |
| 4294967295\ |
| 4294967296\ |
| 4294967297\ |
| 4294967298\ |
| 8589934590\ |
| 8589934591\ |
| 8589934592\ |
| 8589934593\ |
| 8589934594\ |
| 17179869182\ |
| 17179869183\ |
| 17179869184\ |
| 17179869185\ |
| 17179869186\ |
| 34359738366\ |
| 34359738367\ |
| 34359738368\ |
| 34359738369\ |
| 34359738370\ |
| 68719476734\ |
| 68719476735\ |
| 68719476736\ |
| 68719476737\ |
| 68719476738\ |
| 137438953470\ |
| 137438953471\ |
| 137438953472\ |
| 137438953473\ |
| 137438953474\ |
| 274877906942\ |
| 274877906943\ |
| 274877906944\ |
| 274877906945\ |
| 274877906946\ |
| 549755813886\ |
| 549755813887\ |
| 549755813888\ |
| 549755813889\ |
| 549755813890\ |
| 1099511627774\ |
| 1099511627775\ |
| 1099511627776\ |
| 1099511627777\ |
| 1099511627778\ |
| 2199023255550\ |
| 2199023255551\ |
| 2199023255552\ |
| 2199023255553\ |
| 2199023255554\ |
| 4398046511102\ |
| 4398046511103\ |
| 4398046511104\ |
| 4398046511105\ |
| 4398046511106\ |
| 8796093022206\ |
| 8796093022207\ |
| 8796093022208\ |
| 8796093022209\ |
| 8796093022210\ |
| 17592186044414\ |
| 17592186044415\ |
| 17592186044416\ |
| 17592186044417\ |
| 17592186044418\ |
| 35184372088830\ |
| 35184372088831\ |
| 35184372088832\ |
| 35184372088833\ |
| 35184372088834\ |
| 70368744177662\ |
| 70368744177663\ |
| 70368744177664\ |
| 70368744177665\ |
| 70368744177666\ |
| 140737488355326\ |
| 140737488355327\ |
| 140737488355328\ |
| 140737488355329\ |
| 140737488355330\ |
| 281474976710654\ |
| 281474976710655\ |
| 281474976710656\ |
| 281474976710657\ |
| 281474976710658\ |
| 562949953421310\ |
| 562949953421311\ |
| 562949953421312\ |
| 562949953421313\ |
| 562949953421314\ |
| 1125899906842622\ |
| 1125899906842623\ |
| 1125899906842624\ |
| 1125899906842625\ |
| 1125899906842626\ |
| 2251799813685246\ |
| 2251799813685247\ |
| 2251799813685248\ |
| 2251799813685249\ |
| 2251799813685250\ |
| 4503599627370494\ |
| 4503599627370495\ |
| 4503599627370496\ |
| 4503599627370497\ |
| 4503599627370498\ |
| 9007199254740990\ |
| 9007199254740991\ |
| 9007199254740992\ |
| 9007199254740993\ |
| 9007199254740994\ |
| 18014398509481982\ |
| 18014398509481983\ |
| 18014398509481984\ |
| 18014398509481985\ |
| 18014398509481986\ |
| 36028797018963966\ |
| 36028797018963967\ |
| 36028797018963968\ |
| 36028797018963969\ |
| 36028797018963970\ |
| 72057594037927934\ |
| 72057594037927935\ |
| 72057594037927936\ |
| 72057594037927937\ |
| 72057594037927938\ |
| 144115188075855870\ |
| 144115188075855871\ |
| 144115188075855872\ |
| 144115188075855873\ |
| 144115188075855874\ |
| 288230376151711742\ |
| 288230376151711743\ |
| 288230376151711744\ |
| 288230376151711745\ |
| 288230376151711746\ |
| 576460752303423486\ |
| 576460752303423487\ |
| 576460752303423488\ |
| 576460752303423489\ |
| 576460752303423490\ |
| 1152921504606846974\ |
| 1152921504606846975\ |
| 1152921504606846976\ |
| 1152921504606846977\ |
| 1152921504606846978\ |
| 2305843009213693950\ |
| 2305843009213693951\ |
| 2305843009213693952\ |
| 2305843009213693953\ |
| 2305843009213693954\ |
| 4611686018427387902\ |
| 4611686018427387903\ |
| 4611686018427387904\ |
| 4611686018427387905\ |
| 4611686018427387906\ |
| 9223372036854775806\ |
| 9223372036854775807} |
| |
| finish_test |
