AryaWu/sqlite
0
1# 2008 December 112#3# The author disclaims copyright to this source code. In place of4# 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 is automatically generated from a separate TCL script.14# This file seeks to exercise integer boundary values.15#16# $Id: boundary2.test,v 1.2 2009/01/02 15:45:48 shane Exp $17 18set testdir [file dirname $argv0]19source $testdir/tester.tcl20 21# Many of the boundary tests depend on a working 64-bit implementation.22if {![working_64bit_int]} { finish_test; return }23 24do_test boundary2-1.1 {25 db eval {26 CREATE TABLE t1(r INTEGER, a INTEGER, x TEXT);27 INSERT INTO t1 VALUES(-8388609,1,'ffffffffff7fffff');28 INSERT INTO t1 VALUES(-36028797018963969,2,'ff7fffffffffffff');29 INSERT INTO t1 VALUES(9223372036854775807,3,'7fffffffffffffff');30 INSERT INTO t1 VALUES(127,4,'000000000000007f');31 INSERT INTO t1 VALUES(3,5,'0000000000000003');32 INSERT INTO t1 VALUES(16777216,6,'0000000001000000');33 INSERT INTO t1 VALUES(4398046511103,7,'000003ffffffffff');34 INSERT INTO t1 VALUES(16383,8,'0000000000003fff');35 INSERT INTO t1 VALUES(16777215,9,'0000000000ffffff');36 INSERT INTO t1 VALUES(281474976710655,10,'0000ffffffffffff');37 INSERT INTO t1 VALUES(-2147483648,11,'ffffffff80000000');38 INSERT INTO t1 VALUES(268435455,12,'000000000fffffff');39 INSERT INTO t1 VALUES(562949953421311,13,'0001ffffffffffff');40 INSERT INTO t1 VALUES(4294967295,14,'00000000ffffffff');41 INSERT INTO t1 VALUES(2097151,15,'00000000001fffff');42 INSERT INTO t1 VALUES(16384,16,'0000000000004000');43 INSERT INTO t1 VALUES(72057594037927935,17,'00ffffffffffffff');44 INSERT INTO t1 VALUES(8388607,18,'00000000007fffff');45 INSERT INTO t1 VALUES(1099511627776,19,'0000010000000000');46 INSERT INTO t1 VALUES(2147483647,20,'000000007fffffff');47 INSERT INTO t1 VALUES(-140737488355329,21,'ffff7fffffffffff');48 INSERT INTO t1 VALUES(34359738368,22,'0000000800000000');49 INSERT INTO t1 VALUES(32767,23,'0000000000007fff');50 INSERT INTO t1 VALUES(8388608,24,'0000000000800000');51 INSERT INTO t1 VALUES(140737488355327,25,'00007fffffffffff');52 INSERT INTO t1 VALUES(281474976710656,26,'0001000000000000');53 INSERT INTO t1 VALUES(36028797018963967,27,'007fffffffffffff');54 INSERT INTO t1 VALUES(72057594037927936,28,'0100000000000000');55 INSERT INTO t1 VALUES(-32769,29,'ffffffffffff7fff');56 INSERT INTO t1 VALUES(255,30,'00000000000000ff');57 INSERT INTO t1 VALUES(4,31,'0000000000000004');58 INSERT INTO t1 VALUES(-32768,32,'ffffffffffff8000');59 INSERT INTO t1 VALUES(-2,33,'fffffffffffffffe');60 INSERT INTO t1 VALUES(140737488355328,34,'0000800000000000');61 INSERT INTO t1 VALUES(549755813888,35,'0000008000000000');62 INSERT INTO t1 VALUES(4294967296,36,'0000000100000000');63 INSERT INTO t1 VALUES(-8388608,37,'ffffffffff800000');64 INSERT INTO t1 VALUES(-1,38,'ffffffffffffffff');65 INSERT INTO t1 VALUES(34359738367,39,'00000007ffffffff');66 INSERT INTO t1 VALUES(268435456,40,'0000000010000000');67 INSERT INTO t1 VALUES(2,41,'0000000000000002');68 INSERT INTO t1 VALUES(2097152,42,'0000000000200000');69 INSERT INTO t1 VALUES(562949953421312,43,'0002000000000000');70 INSERT INTO t1 VALUES(-140737488355328,44,'ffff800000000000');71 INSERT INTO t1 VALUES(36028797018963968,45,'0080000000000000');72 INSERT INTO t1 VALUES(549755813887,46,'0000007fffffffff');73 INSERT INTO t1 VALUES(-2147483649,47,'ffffffff7fffffff');74 INSERT INTO t1 VALUES(65535,48,'000000000000ffff');75 INSERT INTO t1 VALUES(128,49,'0000000000000080');76 INSERT INTO t1 VALUES(32768,50,'0000000000008000');77 INSERT INTO t1 VALUES(2147483648,51,'0000000080000000');78 INSERT INTO t1 VALUES(-3,52,'fffffffffffffffd');79 INSERT INTO t1 VALUES(-128,53,'ffffffffffffff80');80 INSERT INTO t1 VALUES(-129,54,'ffffffffffffff7f');81 INSERT INTO t1 VALUES(-9223372036854775808,55,'8000000000000000');82 INSERT INTO t1 VALUES(4398046511104,56,'0000040000000000');83 INSERT INTO t1 VALUES(1099511627775,57,'000000ffffffffff');84 INSERT INTO t1 VALUES(-549755813889,58,'ffffff7fffffffff');85 INSERT INTO t1 VALUES(0,59,'0000000000000000');86 INSERT INTO t1 VALUES(1,60,'0000000000000001');87 INSERT INTO t1 VALUES(256,61,'0000000000000100');88 INSERT INTO t1 VALUES(65536,62,'0000000000010000');89 INSERT INTO t1 VALUES(-549755813888,63,'ffffff8000000000');90 INSERT INTO t1 VALUES(-36028797018963968,64,'ff80000000000000');91 CREATE INDEX t1i1 ON t1(r);92 CREATE INDEX t1i2 ON t1(a);93 CREATE INDEX t1i3 ON t1(x);94 }95} {}96do_test boundary2-1.2 {97 db eval {98 SELECT count(*) FROM t199 }100} {64}101do_test boundary2-2.1.1 {102 db eval {103 SELECT * FROM t1 WHERE r=72057594037927935104 }105} {72057594037927935 17 00ffffffffffffff}106do_test boundary2-2.1.2 {107 db eval {108 SELECT r, a FROM t1 WHERE x='00ffffffffffffff'109 }110} {72057594037927935 17}111do_test boundary2-2.1.3 {112 db eval {113 SELECT r, x FROM t1 WHERE a=17114 }115} {72057594037927935 00ffffffffffffff}116do_test boundary2-2.1.gt.1 {117 db eval {118 SELECT a FROM t1 WHERE r > 72057594037927935 ORDER BY a119 }120} {3 28}121do_test boundary2-2.1.gt.2 {122 db eval {123 SELECT a FROM t1 WHERE r > 72057594037927935 ORDER BY a DESC124 }125} {28 3}126do_test boundary2-2.1.gt.3 {127 db eval {128 SELECT a FROM t1 WHERE r > 72057594037927935 ORDER BY r129 }130} {28 3}131do_test boundary2-2.1.gt.4 {132 db eval {133 SELECT a FROM t1 WHERE r > 72057594037927935 ORDER BY r DESC134 }135} {3 28}136do_test boundary2-2.1.gt.5 {137 db eval {138 SELECT a FROM t1 WHERE r > 72057594037927935 ORDER BY x139 }140} {28 3}141do_test boundary2-2.1.ge.1 {142 db eval {143 SELECT a FROM t1 WHERE r >= 72057594037927935 ORDER BY a144 }145} {3 17 28}146do_test boundary2-2.1.ge.2 {147 db eval {148 SELECT a FROM t1 WHERE r >= 72057594037927935 ORDER BY a DESC149 }150} {28 17 3}151do_test boundary2-2.1.ge.3 {152 db eval {153 SELECT a FROM t1 WHERE r >= 72057594037927935 ORDER BY r154 }155} {17 28 3}156do_test boundary2-2.1.ge.4 {157 db eval {158 SELECT a FROM t1 WHERE r >= 72057594037927935 ORDER BY r DESC159 }160} {3 28 17}161do_test boundary2-2.1.ge.5 {162 db eval {163 SELECT a FROM t1 WHERE r >= 72057594037927935 ORDER BY x164 }165} {17 28 3}166do_test boundary2-2.1.lt.1 {167 db eval {168 SELECT a FROM t1 WHERE r < 72057594037927935 ORDER BY a169 }170} {1 2 4 5 6 7 8 9 10 11 12 13 14 15 16 18 19 20 21 22 23 24 25 26 27 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64}171do_test boundary2-2.1.lt.2 {172 db eval {173 SELECT a FROM t1 WHERE r < 72057594037927935 ORDER BY a DESC174 }175} {64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 49 48 47 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29 27 26 25 24 23 22 21 20 19 18 16 15 14 13 12 11 10 9 8 7 6 5 4 2 1}176do_test boundary2-2.1.lt.3 {177 db eval {178 SELECT a FROM t1 WHERE r < 72057594037927935 ORDER BY r179 }180} {55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38 59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45}181do_test boundary2-2.1.lt.4 {182 db eval {183 SELECT a FROM t1 WHERE r < 72057594037927935 ORDER BY r DESC184 }185} {45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39 36 14 51 20 40 12 6 9 24 18 42 15 62 48 50 23 16 8 61 30 49 4 31 5 41 60 59 38 33 52 53 54 32 29 37 1 11 47 63 58 44 21 64 2 55}186do_test boundary2-2.1.lt.5 {187 db eval {188 SELECT a FROM t1 WHERE r < 72057594037927935 ORDER BY x189 }190} {59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38}191do_test boundary2-2.1.le.1 {192 db eval {193 SELECT a FROM t1 WHERE r <= 72057594037927935 ORDER BY a194 }195} {1 2 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64}196do_test boundary2-2.1.le.2 {197 db eval {198 SELECT a FROM t1 WHERE r <= 72057594037927935 ORDER BY a DESC199 }200} {64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 49 48 47 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 2 1}201do_test boundary2-2.1.le.3 {202 db eval {203 SELECT a FROM t1 WHERE r <= 72057594037927935 ORDER BY r204 }205} {55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38 59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17}206do_test boundary2-2.1.le.4 {207 db eval {208 SELECT a FROM t1 WHERE r <= 72057594037927935 ORDER BY r DESC209 }210} {17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39 36 14 51 20 40 12 6 9 24 18 42 15 62 48 50 23 16 8 61 30 49 4 31 5 41 60 59 38 33 52 53 54 32 29 37 1 11 47 63 58 44 21 64 2 55}211do_test boundary2-2.1.le.5 {212 db eval {213 SELECT a FROM t1 WHERE r <= 72057594037927935 ORDER BY x214 }215} {59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38}216do_test boundary2-2.2.1 {217 db eval {218 SELECT * FROM t1 WHERE r=16384219 }220} {16384 16 0000000000004000}221do_test boundary2-2.2.2 {222 db eval {223 SELECT r, a FROM t1 WHERE x='0000000000004000'224 }225} {16384 16}226do_test boundary2-2.2.3 {227 db eval {228 SELECT r, x FROM t1 WHERE a=16229 }230} {16384 0000000000004000}231do_test boundary2-2.2.gt.1 {232 db eval {233 SELECT a FROM t1 WHERE r > 16384 ORDER BY a234 }235} {3 6 7 9 10 12 13 14 15 17 18 19 20 22 23 24 25 26 27 28 34 35 36 39 40 42 43 45 46 48 50 51 56 57 62}236do_test boundary2-2.2.gt.2 {237 db eval {238 SELECT a FROM t1 WHERE r > 16384 ORDER BY a DESC239 }240} {62 57 56 51 50 48 46 45 43 42 40 39 36 35 34 28 27 26 25 24 23 22 20 19 18 17 15 14 13 12 10 9 7 6 3}241do_test boundary2-2.2.gt.3 {242 db eval {243 SELECT a FROM t1 WHERE r > 16384 ORDER BY r244 }245} {23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}246do_test boundary2-2.2.gt.4 {247 db eval {248 SELECT a FROM t1 WHERE r > 16384 ORDER BY r DESC249 }250} {3 28 17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39 36 14 51 20 40 12 6 9 24 18 42 15 62 48 50 23}251do_test boundary2-2.2.gt.5 {252 db eval {253 SELECT a FROM t1 WHERE r > 16384 ORDER BY x254 }255} {23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}256do_test boundary2-2.2.ge.1 {257 db eval {258 SELECT a FROM t1 WHERE r >= 16384 ORDER BY a259 }260} {3 6 7 9 10 12 13 14 15 16 17 18 19 20 22 23 24 25 26 27 28 34 35 36 39 40 42 43 45 46 48 50 51 56 57 62}261do_test boundary2-2.2.ge.2 {262 db eval {263 SELECT a FROM t1 WHERE r >= 16384 ORDER BY a DESC264 }265} {62 57 56 51 50 48 46 45 43 42 40 39 36 35 34 28 27 26 25 24 23 22 20 19 18 17 16 15 14 13 12 10 9 7 6 3}266do_test boundary2-2.2.ge.3 {267 db eval {268 SELECT a FROM t1 WHERE r >= 16384 ORDER BY r269 }270} {16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}271do_test boundary2-2.2.ge.4 {272 db eval {273 SELECT a FROM t1 WHERE r >= 16384 ORDER BY r DESC274 }275} {3 28 17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39 36 14 51 20 40 12 6 9 24 18 42 15 62 48 50 23 16}276do_test boundary2-2.2.ge.5 {277 db eval {278 SELECT a FROM t1 WHERE r >= 16384 ORDER BY x279 }280} {16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}281do_test boundary2-2.2.lt.1 {282 db eval {283 SELECT a FROM t1 WHERE r < 16384 ORDER BY a284 }285} {1 2 4 5 8 11 21 29 30 31 32 33 37 38 41 44 47 49 52 53 54 55 58 59 60 61 63 64}286do_test boundary2-2.2.lt.2 {287 db eval {288 SELECT a FROM t1 WHERE r < 16384 ORDER BY a DESC289 }290} {64 63 61 60 59 58 55 54 53 52 49 47 44 41 38 37 33 32 31 30 29 21 11 8 5 4 2 1}291do_test boundary2-2.2.lt.3 {292 db eval {293 SELECT a FROM t1 WHERE r < 16384 ORDER BY r294 }295} {55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38 59 60 41 5 31 4 49 30 61 8}296do_test boundary2-2.2.lt.4 {297 db eval {298 SELECT a FROM t1 WHERE r < 16384 ORDER BY r DESC299 }300} {8 61 30 49 4 31 5 41 60 59 38 33 52 53 54 32 29 37 1 11 47 63 58 44 21 64 2 55}301do_test boundary2-2.2.lt.5 {302 db eval {303 SELECT a FROM t1 WHERE r < 16384 ORDER BY x304 }305} {59 60 41 5 31 4 49 30 61 8 55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38}306do_test boundary2-2.2.le.1 {307 db eval {308 SELECT a FROM t1 WHERE r <= 16384 ORDER BY a309 }310} {1 2 4 5 8 11 16 21 29 30 31 32 33 37 38 41 44 47 49 52 53 54 55 58 59 60 61 63 64}311do_test boundary2-2.2.le.2 {312 db eval {313 SELECT a FROM t1 WHERE r <= 16384 ORDER BY a DESC314 }315} {64 63 61 60 59 58 55 54 53 52 49 47 44 41 38 37 33 32 31 30 29 21 16 11 8 5 4 2 1}316do_test boundary2-2.2.le.3 {317 db eval {318 SELECT a FROM t1 WHERE r <= 16384 ORDER BY r319 }320} {55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38 59 60 41 5 31 4 49 30 61 8 16}321do_test boundary2-2.2.le.4 {322 db eval {323 SELECT a FROM t1 WHERE r <= 16384 ORDER BY r DESC324 }325} {16 8 61 30 49 4 31 5 41 60 59 38 33 52 53 54 32 29 37 1 11 47 63 58 44 21 64 2 55}326do_test boundary2-2.2.le.5 {327 db eval {328 SELECT a FROM t1 WHERE r <= 16384 ORDER BY x329 }330} {59 60 41 5 31 4 49 30 61 8 16 55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38}331do_test boundary2-2.3.1 {332 db eval {333 SELECT * FROM t1 WHERE r=4294967296334 }335} {4294967296 36 0000000100000000}336do_test boundary2-2.3.2 {337 db eval {338 SELECT r, a FROM t1 WHERE x='0000000100000000'339 }340} {4294967296 36}341do_test boundary2-2.3.3 {342 db eval {343 SELECT r, x FROM t1 WHERE a=36344 }345} {4294967296 0000000100000000}346do_test boundary2-2.3.gt.1 {347 db eval {348 SELECT a FROM t1 WHERE r > 4294967296 ORDER BY a349 }350} {3 7 10 13 17 19 22 25 26 27 28 34 35 39 43 45 46 56 57}351do_test boundary2-2.3.gt.2 {352 db eval {353 SELECT a FROM t1 WHERE r > 4294967296 ORDER BY a DESC354 }355} {57 56 46 45 43 39 35 34 28 27 26 25 22 19 17 13 10 7 3}356do_test boundary2-2.3.gt.3 {357 db eval {358 SELECT a FROM t1 WHERE r > 4294967296 ORDER BY r359 }360} {39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}361do_test boundary2-2.3.gt.4 {362 db eval {363 SELECT a FROM t1 WHERE r > 4294967296 ORDER BY r DESC364 }365} {3 28 17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39}366do_test boundary2-2.3.gt.5 {367 db eval {368 SELECT a FROM t1 WHERE r > 4294967296 ORDER BY x369 }370} {39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}371do_test boundary2-2.3.ge.1 {372 db eval {373 SELECT a FROM t1 WHERE r >= 4294967296 ORDER BY a374 }375} {3 7 10 13 17 19 22 25 26 27 28 34 35 36 39 43 45 46 56 57}376do_test boundary2-2.3.ge.2 {377 db eval {378 SELECT a FROM t1 WHERE r >= 4294967296 ORDER BY a DESC379 }380} {57 56 46 45 43 39 36 35 34 28 27 26 25 22 19 17 13 10 7 3}381do_test boundary2-2.3.ge.3 {382 db eval {383 SELECT a FROM t1 WHERE r >= 4294967296 ORDER BY r384 }385} {36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}386do_test boundary2-2.3.ge.4 {387 db eval {388 SELECT a FROM t1 WHERE r >= 4294967296 ORDER BY r DESC389 }390} {3 28 17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39 36}391do_test boundary2-2.3.ge.5 {392 db eval {393 SELECT a FROM t1 WHERE r >= 4294967296 ORDER BY x394 }395} {36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}396do_test boundary2-2.3.lt.1 {397 db eval {398 SELECT a FROM t1 WHERE r < 4294967296 ORDER BY a399 }400} {1 2 4 5 6 8 9 11 12 14 15 16 18 20 21 23 24 29 30 31 32 33 37 38 40 41 42 44 47 48 49 50 51 52 53 54 55 58 59 60 61 62 63 64}401do_test boundary2-2.3.lt.2 {402 db eval {403 SELECT a FROM t1 WHERE r < 4294967296 ORDER BY a DESC404 }405} {64 63 62 61 60 59 58 55 54 53 52 51 50 49 48 47 44 42 41 40 38 37 33 32 31 30 29 24 23 21 20 18 16 15 14 12 11 9 8 6 5 4 2 1}406do_test boundary2-2.3.lt.3 {407 db eval {408 SELECT a FROM t1 WHERE r < 4294967296 ORDER BY r409 }410} {55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38 59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14}411do_test boundary2-2.3.lt.4 {412 db eval {413 SELECT a FROM t1 WHERE r < 4294967296 ORDER BY r DESC414 }415} {14 51 20 40 12 6 9 24 18 42 15 62 48 50 23 16 8 61 30 49 4 31 5 41 60 59 38 33 52 53 54 32 29 37 1 11 47 63 58 44 21 64 2 55}416do_test boundary2-2.3.lt.5 {417 db eval {418 SELECT a FROM t1 WHERE r < 4294967296 ORDER BY x419 }420} {59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38}421do_test boundary2-2.3.le.1 {422 db eval {423 SELECT a FROM t1 WHERE r <= 4294967296 ORDER BY a424 }425} {1 2 4 5 6 8 9 11 12 14 15 16 18 20 21 23 24 29 30 31 32 33 36 37 38 40 41 42 44 47 48 49 50 51 52 53 54 55 58 59 60 61 62 63 64}426do_test boundary2-2.3.le.2 {427 db eval {428 SELECT a FROM t1 WHERE r <= 4294967296 ORDER BY a DESC429 }430} {64 63 62 61 60 59 58 55 54 53 52 51 50 49 48 47 44 42 41 40 38 37 36 33 32 31 30 29 24 23 21 20 18 16 15 14 12 11 9 8 6 5 4 2 1}431do_test boundary2-2.3.le.3 {432 db eval {433 SELECT a FROM t1 WHERE r <= 4294967296 ORDER BY r434 }435} {55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38 59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36}436do_test boundary2-2.3.le.4 {437 db eval {438 SELECT a FROM t1 WHERE r <= 4294967296 ORDER BY r DESC439 }440} {36 14 51 20 40 12 6 9 24 18 42 15 62 48 50 23 16 8 61 30 49 4 31 5 41 60 59 38 33 52 53 54 32 29 37 1 11 47 63 58 44 21 64 2 55}441do_test boundary2-2.3.le.5 {442 db eval {443 SELECT a FROM t1 WHERE r <= 4294967296 ORDER BY x444 }445} {59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38}446do_test boundary2-2.4.1 {447 db eval {448 SELECT * FROM t1 WHERE r=16777216449 }450} {16777216 6 0000000001000000}451do_test boundary2-2.4.2 {452 db eval {453 SELECT r, a FROM t1 WHERE x='0000000001000000'454 }455} {16777216 6}456do_test boundary2-2.4.3 {457 db eval {458 SELECT r, x FROM t1 WHERE a=6459 }460} {16777216 0000000001000000}461do_test boundary2-2.4.gt.1 {462 db eval {463 SELECT a FROM t1 WHERE r > 16777216 ORDER BY a464 }465} {3 7 10 12 13 14 17 19 20 22 25 26 27 28 34 35 36 39 40 43 45 46 51 56 57}466do_test boundary2-2.4.gt.2 {467 db eval {468 SELECT a FROM t1 WHERE r > 16777216 ORDER BY a DESC469 }470} {57 56 51 46 45 43 40 39 36 35 34 28 27 26 25 22 20 19 17 14 13 12 10 7 3}471do_test boundary2-2.4.gt.3 {472 db eval {473 SELECT a FROM t1 WHERE r > 16777216 ORDER BY r474 }475} {12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}476do_test boundary2-2.4.gt.4 {477 db eval {478 SELECT a FROM t1 WHERE r > 16777216 ORDER BY r DESC479 }480} {3 28 17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39 36 14 51 20 40 12}481do_test boundary2-2.4.gt.5 {482 db eval {483 SELECT a FROM t1 WHERE r > 16777216 ORDER BY x484 }485} {12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}486do_test boundary2-2.4.ge.1 {487 db eval {488 SELECT a FROM t1 WHERE r >= 16777216 ORDER BY a489 }490} {3 6 7 10 12 13 14 17 19 20 22 25 26 27 28 34 35 36 39 40 43 45 46 51 56 57}491do_test boundary2-2.4.ge.2 {492 db eval {493 SELECT a FROM t1 WHERE r >= 16777216 ORDER BY a DESC494 }495} {57 56 51 46 45 43 40 39 36 35 34 28 27 26 25 22 20 19 17 14 13 12 10 7 6 3}496do_test boundary2-2.4.ge.3 {497 db eval {498 SELECT a FROM t1 WHERE r >= 16777216 ORDER BY r499 }500} {6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}501do_test boundary2-2.4.ge.4 {502 db eval {503 SELECT a FROM t1 WHERE r >= 16777216 ORDER BY r DESC504 }505} {3 28 17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39 36 14 51 20 40 12 6}506do_test boundary2-2.4.ge.5 {507 db eval {508 SELECT a FROM t1 WHERE r >= 16777216 ORDER BY x509 }510} {6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}511do_test boundary2-2.4.lt.1 {512 db eval {513 SELECT a FROM t1 WHERE r < 16777216 ORDER BY a514 }515} {1 2 4 5 8 9 11 15 16 18 21 23 24 29 30 31 32 33 37 38 41 42 44 47 48 49 50 52 53 54 55 58 59 60 61 62 63 64}516do_test boundary2-2.4.lt.2 {517 db eval {518 SELECT a FROM t1 WHERE r < 16777216 ORDER BY a DESC519 }520} {64 63 62 61 60 59 58 55 54 53 52 50 49 48 47 44 42 41 38 37 33 32 31 30 29 24 23 21 18 16 15 11 9 8 5 4 2 1}521do_test boundary2-2.4.lt.3 {522 db eval {523 SELECT a FROM t1 WHERE r < 16777216 ORDER BY r524 }525} {55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38 59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9}526do_test boundary2-2.4.lt.4 {527 db eval {528 SELECT a FROM t1 WHERE r < 16777216 ORDER BY r DESC529 }530} {9 24 18 42 15 62 48 50 23 16 8 61 30 49 4 31 5 41 60 59 38 33 52 53 54 32 29 37 1 11 47 63 58 44 21 64 2 55}531do_test boundary2-2.4.lt.5 {532 db eval {533 SELECT a FROM t1 WHERE r < 16777216 ORDER BY x534 }535} {59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38}536do_test boundary2-2.4.le.1 {537 db eval {538 SELECT a FROM t1 WHERE r <= 16777216 ORDER BY a539 }540} {1 2 4 5 6 8 9 11 15 16 18 21 23 24 29 30 31 32 33 37 38 41 42 44 47 48 49 50 52 53 54 55 58 59 60 61 62 63 64}541do_test boundary2-2.4.le.2 {542 db eval {543 SELECT a FROM t1 WHERE r <= 16777216 ORDER BY a DESC544 }545} {64 63 62 61 60 59 58 55 54 53 52 50 49 48 47 44 42 41 38 37 33 32 31 30 29 24 23 21 18 16 15 11 9 8 6 5 4 2 1}546do_test boundary2-2.4.le.3 {547 db eval {548 SELECT a FROM t1 WHERE r <= 16777216 ORDER BY r549 }550} {55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38 59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6}551do_test boundary2-2.4.le.4 {552 db eval {553 SELECT a FROM t1 WHERE r <= 16777216 ORDER BY r DESC554 }555} {6 9 24 18 42 15 62 48 50 23 16 8 61 30 49 4 31 5 41 60 59 38 33 52 53 54 32 29 37 1 11 47 63 58 44 21 64 2 55}556do_test boundary2-2.4.le.5 {557 db eval {558 SELECT a FROM t1 WHERE r <= 16777216 ORDER BY x559 }560} {59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38}561do_test boundary2-2.5.1 {562 db eval {563 SELECT * FROM t1 WHERE r=-32769564 }565} {-32769 29 ffffffffffff7fff}566do_test boundary2-2.5.2 {567 db eval {568 SELECT r, a FROM t1 WHERE x='ffffffffffff7fff'569 }570} {-32769 29}571do_test boundary2-2.5.3 {572 db eval {573 SELECT r, x FROM t1 WHERE a=29574 }575} {-32769 ffffffffffff7fff}576do_test boundary2-2.5.gt.1 {577 db eval {578 SELECT a FROM t1 WHERE r > -32769 ORDER BY a579 }580} {3 4 5 6 7 8 9 10 12 13 14 15 16 17 18 19 20 22 23 24 25 26 27 28 30 31 32 33 34 35 36 38 39 40 41 42 43 45 46 48 49 50 51 52 53 54 56 57 59 60 61 62}581do_test boundary2-2.5.gt.2 {582 db eval {583 SELECT a FROM t1 WHERE r > -32769 ORDER BY a DESC584 }585} {62 61 60 59 57 56 54 53 52 51 50 49 48 46 45 43 42 41 40 39 38 36 35 34 33 32 31 30 28 27 26 25 24 23 22 20 19 18 17 16 15 14 13 12 10 9 8 7 6 5 4 3}586do_test boundary2-2.5.gt.3 {587 db eval {588 SELECT a FROM t1 WHERE r > -32769 ORDER BY r589 }590} {32 54 53 52 33 38 59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}591do_test boundary2-2.5.gt.4 {592 db eval {593 SELECT a FROM t1 WHERE r > -32769 ORDER BY r DESC594 }595} {3 28 17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39 36 14 51 20 40 12 6 9 24 18 42 15 62 48 50 23 16 8 61 30 49 4 31 5 41 60 59 38 33 52 53 54 32}596do_test boundary2-2.5.gt.5 {597 db eval {598 SELECT a FROM t1 WHERE r > -32769 ORDER BY x599 }600} {59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3 32 54 53 52 33 38}601do_test boundary2-2.5.ge.1 {602 db eval {603 SELECT a FROM t1 WHERE r >= -32769 ORDER BY a604 }605} {3 4 5 6 7 8 9 10 12 13 14 15 16 17 18 19 20 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 38 39 40 41 42 43 45 46 48 49 50 51 52 53 54 56 57 59 60 61 62}606do_test boundary2-2.5.ge.2 {607 db eval {608 SELECT a FROM t1 WHERE r >= -32769 ORDER BY a DESC609 }610} {62 61 60 59 57 56 54 53 52 51 50 49 48 46 45 43 42 41 40 39 38 36 35 34 33 32 31 30 29 28 27 26 25 24 23 22 20 19 18 17 16 15 14 13 12 10 9 8 7 6 5 4 3}611do_test boundary2-2.5.ge.3 {612 db eval {613 SELECT a FROM t1 WHERE r >= -32769 ORDER BY r614 }615} {29 32 54 53 52 33 38 59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}616do_test boundary2-2.5.ge.4 {617 db eval {618 SELECT a FROM t1 WHERE r >= -32769 ORDER BY r DESC619 }620} {3 28 17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39 36 14 51 20 40 12 6 9 24 18 42 15 62 48 50 23 16 8 61 30 49 4 31 5 41 60 59 38 33 52 53 54 32 29}621do_test boundary2-2.5.ge.5 {622 db eval {623 SELECT a FROM t1 WHERE r >= -32769 ORDER BY x624 }625} {59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3 29 32 54 53 52 33 38}626do_test boundary2-2.5.lt.1 {627 db eval {628 SELECT a FROM t1 WHERE r < -32769 ORDER BY a629 }630} {1 2 11 21 37 44 47 55 58 63 64}631do_test boundary2-2.5.lt.2 {632 db eval {633 SELECT a FROM t1 WHERE r < -32769 ORDER BY a DESC634 }635} {64 63 58 55 47 44 37 21 11 2 1}636do_test boundary2-2.5.lt.3 {637 db eval {638 SELECT a FROM t1 WHERE r < -32769 ORDER BY r639 }640} {55 2 64 21 44 58 63 47 11 1 37}641do_test boundary2-2.5.lt.4 {642 db eval {643 SELECT a FROM t1 WHERE r < -32769 ORDER BY r DESC644 }645} {37 1 11 47 63 58 44 21 64 2 55}646do_test boundary2-2.5.lt.5 {647 db eval {648 SELECT a FROM t1 WHERE r < -32769 ORDER BY x649 }650} {55 2 64 21 44 58 63 47 11 1 37}651do_test boundary2-2.5.le.1 {652 db eval {653 SELECT a FROM t1 WHERE r <= -32769 ORDER BY a654 }655} {1 2 11 21 29 37 44 47 55 58 63 64}656do_test boundary2-2.5.le.2 {657 db eval {658 SELECT a FROM t1 WHERE r <= -32769 ORDER BY a DESC659 }660} {64 63 58 55 47 44 37 29 21 11 2 1}661do_test boundary2-2.5.le.3 {662 db eval {663 SELECT a FROM t1 WHERE r <= -32769 ORDER BY r664 }665} {55 2 64 21 44 58 63 47 11 1 37 29}666do_test boundary2-2.5.le.4 {667 db eval {668 SELECT a FROM t1 WHERE r <= -32769 ORDER BY r DESC669 }670} {29 37 1 11 47 63 58 44 21 64 2 55}671do_test boundary2-2.5.le.5 {672 db eval {673 SELECT a FROM t1 WHERE r <= -32769 ORDER BY x674 }675} {55 2 64 21 44 58 63 47 11 1 37 29}676do_test boundary2-2.6.1 {677 db eval {678 SELECT * FROM t1 WHERE r=-140737488355329679 }680} {-140737488355329 21 ffff7fffffffffff}681do_test boundary2-2.6.2 {682 db eval {683 SELECT r, a FROM t1 WHERE x='ffff7fffffffffff'684 }685} {-140737488355329 21}686do_test boundary2-2.6.3 {687 db eval {688 SELECT r, x FROM t1 WHERE a=21689 }690} {-140737488355329 ffff7fffffffffff}691do_test boundary2-2.6.gt.1 {692 db eval {693 SELECT a FROM t1 WHERE r > -140737488355329 ORDER BY a694 }695} {1 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 56 57 58 59 60 61 62 63}696do_test boundary2-2.6.gt.2 {697 db eval {698 SELECT a FROM t1 WHERE r > -140737488355329 ORDER BY a DESC699 }700} {63 62 61 60 59 58 57 56 54 53 52 51 50 49 48 47 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29 28 27 26 25 24 23 22 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 1}701do_test boundary2-2.6.gt.3 {702 db eval {703 SELECT a FROM t1 WHERE r > -140737488355329 ORDER BY r704 }705} {44 58 63 47 11 1 37 29 32 54 53 52 33 38 59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}706do_test boundary2-2.6.gt.4 {707 db eval {708 SELECT a FROM t1 WHERE r > -140737488355329 ORDER BY r DESC709 }710} {3 28 17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39 36 14 51 20 40 12 6 9 24 18 42 15 62 48 50 23 16 8 61 30 49 4 31 5 41 60 59 38 33 52 53 54 32 29 37 1 11 47 63 58 44}711do_test boundary2-2.6.gt.5 {712 db eval {713 SELECT a FROM t1 WHERE r > -140737488355329 ORDER BY x714 }715} {59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3 44 58 63 47 11 1 37 29 32 54 53 52 33 38}716do_test boundary2-2.6.ge.1 {717 db eval {718 SELECT a FROM t1 WHERE r >= -140737488355329 ORDER BY a719 }720} {1 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 56 57 58 59 60 61 62 63}721do_test boundary2-2.6.ge.2 {722 db eval {723 SELECT a FROM t1 WHERE r >= -140737488355329 ORDER BY a DESC724 }725} {63 62 61 60 59 58 57 56 54 53 52 51 50 49 48 47 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31 30 29 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 1}726do_test boundary2-2.6.ge.3 {727 db eval {728 SELECT a FROM t1 WHERE r >= -140737488355329 ORDER BY r729 }730} {21 44 58 63 47 11 1 37 29 32 54 53 52 33 38 59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}731do_test boundary2-2.6.ge.4 {732 db eval {733 SELECT a FROM t1 WHERE r >= -140737488355329 ORDER BY r DESC734 }735} {3 28 17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39 36 14 51 20 40 12 6 9 24 18 42 15 62 48 50 23 16 8 61 30 49 4 31 5 41 60 59 38 33 52 53 54 32 29 37 1 11 47 63 58 44 21}736do_test boundary2-2.6.ge.5 {737 db eval {738 SELECT a FROM t1 WHERE r >= -140737488355329 ORDER BY x739 }740} {59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38}741do_test boundary2-2.6.lt.1 {742 db eval {743 SELECT a FROM t1 WHERE r < -140737488355329 ORDER BY a744 }745} {2 55 64}746do_test boundary2-2.6.lt.2 {747 db eval {748 SELECT a FROM t1 WHERE r < -140737488355329 ORDER BY a DESC749 }750} {64 55 2}751do_test boundary2-2.6.lt.3 {752 db eval {753 SELECT a FROM t1 WHERE r < -140737488355329 ORDER BY r754 }755} {55 2 64}756do_test boundary2-2.6.lt.4 {757 db eval {758 SELECT a FROM t1 WHERE r < -140737488355329 ORDER BY r DESC759 }760} {64 2 55}761do_test boundary2-2.6.lt.5 {762 db eval {763 SELECT a FROM t1 WHERE r < -140737488355329 ORDER BY x764 }765} {55 2 64}766do_test boundary2-2.6.le.1 {767 db eval {768 SELECT a FROM t1 WHERE r <= -140737488355329 ORDER BY a769 }770} {2 21 55 64}771do_test boundary2-2.6.le.2 {772 db eval {773 SELECT a FROM t1 WHERE r <= -140737488355329 ORDER BY a DESC774 }775} {64 55 21 2}776do_test boundary2-2.6.le.3 {777 db eval {778 SELECT a FROM t1 WHERE r <= -140737488355329 ORDER BY r779 }780} {55 2 64 21}781do_test boundary2-2.6.le.4 {782 db eval {783 SELECT a FROM t1 WHERE r <= -140737488355329 ORDER BY r DESC784 }785} {21 64 2 55}786do_test boundary2-2.6.le.5 {787 db eval {788 SELECT a FROM t1 WHERE r <= -140737488355329 ORDER BY x789 }790} {55 2 64 21}791do_test boundary2-2.7.1 {792 db eval {793 SELECT * FROM t1 WHERE r=2794 }795} {2 41 0000000000000002}796do_test boundary2-2.7.2 {797 db eval {798 SELECT r, a FROM t1 WHERE x='0000000000000002'799 }800} {2 41}801do_test boundary2-2.7.3 {802 db eval {803 SELECT r, x FROM t1 WHERE a=41804 }805} {2 0000000000000002}806do_test boundary2-2.7.gt.1 {807 db eval {808 SELECT a FROM t1 WHERE r > 2 ORDER BY a809 }810} {3 4 5 6 7 8 9 10 12 13 14 15 16 17 18 19 20 22 23 24 25 26 27 28 30 31 34 35 36 39 40 42 43 45 46 48 49 50 51 56 57 61 62}811do_test boundary2-2.7.gt.2 {812 db eval {813 SELECT a FROM t1 WHERE r > 2 ORDER BY a DESC814 }815} {62 61 57 56 51 50 49 48 46 45 43 42 40 39 36 35 34 31 30 28 27 26 25 24 23 22 20 19 18 17 16 15 14 13 12 10 9 8 7 6 5 4 3}816do_test boundary2-2.7.gt.3 {817 db eval {818 SELECT a FROM t1 WHERE r > 2 ORDER BY r819 }820} {5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}821do_test boundary2-2.7.gt.4 {822 db eval {823 SELECT a FROM t1 WHERE r > 2 ORDER BY r DESC824 }825} {3 28 17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39 36 14 51 20 40 12 6 9 24 18 42 15 62 48 50 23 16 8 61 30 49 4 31 5}826do_test boundary2-2.7.gt.5 {827 db eval {828 SELECT a FROM t1 WHERE r > 2 ORDER BY x829 }830} {5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}831do_test boundary2-2.7.ge.1 {832 db eval {833 SELECT a FROM t1 WHERE r >= 2 ORDER BY a834 }835} {3 4 5 6 7 8 9 10 12 13 14 15 16 17 18 19 20 22 23 24 25 26 27 28 30 31 34 35 36 39 40 41 42 43 45 46 48 49 50 51 56 57 61 62}836do_test boundary2-2.7.ge.2 {837 db eval {838 SELECT a FROM t1 WHERE r >= 2 ORDER BY a DESC839 }840} {62 61 57 56 51 50 49 48 46 45 43 42 41 40 39 36 35 34 31 30 28 27 26 25 24 23 22 20 19 18 17 16 15 14 13 12 10 9 8 7 6 5 4 3}841do_test boundary2-2.7.ge.3 {842 db eval {843 SELECT a FROM t1 WHERE r >= 2 ORDER BY r844 }845} {41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}846do_test boundary2-2.7.ge.4 {847 db eval {848 SELECT a FROM t1 WHERE r >= 2 ORDER BY r DESC849 }850} {3 28 17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39 36 14 51 20 40 12 6 9 24 18 42 15 62 48 50 23 16 8 61 30 49 4 31 5 41}851do_test boundary2-2.7.ge.5 {852 db eval {853 SELECT a FROM t1 WHERE r >= 2 ORDER BY x854 }855} {41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}856do_test boundary2-2.7.lt.1 {857 db eval {858 SELECT a FROM t1 WHERE r < 2 ORDER BY a859 }860} {1 2 11 21 29 32 33 37 38 44 47 52 53 54 55 58 59 60 63 64}861do_test boundary2-2.7.lt.2 {862 db eval {863 SELECT a FROM t1 WHERE r < 2 ORDER BY a DESC864 }865} {64 63 60 59 58 55 54 53 52 47 44 38 37 33 32 29 21 11 2 1}866do_test boundary2-2.7.lt.3 {867 db eval {868 SELECT a FROM t1 WHERE r < 2 ORDER BY r869 }870} {55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38 59 60}871do_test boundary2-2.7.lt.4 {872 db eval {873 SELECT a FROM t1 WHERE r < 2 ORDER BY r DESC874 }875} {60 59 38 33 52 53 54 32 29 37 1 11 47 63 58 44 21 64 2 55}876do_test boundary2-2.7.lt.5 {877 db eval {878 SELECT a FROM t1 WHERE r < 2 ORDER BY x879 }880} {59 60 55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38}881do_test boundary2-2.7.le.1 {882 db eval {883 SELECT a FROM t1 WHERE r <= 2 ORDER BY a884 }885} {1 2 11 21 29 32 33 37 38 41 44 47 52 53 54 55 58 59 60 63 64}886do_test boundary2-2.7.le.2 {887 db eval {888 SELECT a FROM t1 WHERE r <= 2 ORDER BY a DESC889 }890} {64 63 60 59 58 55 54 53 52 47 44 41 38 37 33 32 29 21 11 2 1}891do_test boundary2-2.7.le.3 {892 db eval {893 SELECT a FROM t1 WHERE r <= 2 ORDER BY r894 }895} {55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38 59 60 41}896do_test boundary2-2.7.le.4 {897 db eval {898 SELECT a FROM t1 WHERE r <= 2 ORDER BY r DESC899 }900} {41 60 59 38 33 52 53 54 32 29 37 1 11 47 63 58 44 21 64 2 55}901do_test boundary2-2.7.le.5 {902 db eval {903 SELECT a FROM t1 WHERE r <= 2 ORDER BY x904 }905} {59 60 41 55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38}906do_test boundary2-2.8.1 {907 db eval {908 SELECT * FROM t1 WHERE r=4909 }910} {4 31 0000000000000004}911do_test boundary2-2.8.2 {912 db eval {913 SELECT r, a FROM t1 WHERE x='0000000000000004'914 }915} {4 31}916do_test boundary2-2.8.3 {917 db eval {918 SELECT r, x FROM t1 WHERE a=31919 }920} {4 0000000000000004}921do_test boundary2-2.8.gt.1 {922 db eval {923 SELECT a FROM t1 WHERE r > 4 ORDER BY a924 }925} {3 4 6 7 8 9 10 12 13 14 15 16 17 18 19 20 22 23 24 25 26 27 28 30 34 35 36 39 40 42 43 45 46 48 49 50 51 56 57 61 62}926do_test boundary2-2.8.gt.2 {927 db eval {928 SELECT a FROM t1 WHERE r > 4 ORDER BY a DESC929 }930} {62 61 57 56 51 50 49 48 46 45 43 42 40 39 36 35 34 30 28 27 26 25 24 23 22 20 19 18 17 16 15 14 13 12 10 9 8 7 6 4 3}931do_test boundary2-2.8.gt.3 {932 db eval {933 SELECT a FROM t1 WHERE r > 4 ORDER BY r934 }935} {4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}936do_test boundary2-2.8.gt.4 {937 db eval {938 SELECT a FROM t1 WHERE r > 4 ORDER BY r DESC939 }940} {3 28 17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39 36 14 51 20 40 12 6 9 24 18 42 15 62 48 50 23 16 8 61 30 49 4}941do_test boundary2-2.8.gt.5 {942 db eval {943 SELECT a FROM t1 WHERE r > 4 ORDER BY x944 }945} {4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}946do_test boundary2-2.8.ge.1 {947 db eval {948 SELECT a FROM t1 WHERE r >= 4 ORDER BY a949 }950} {3 4 6 7 8 9 10 12 13 14 15 16 17 18 19 20 22 23 24 25 26 27 28 30 31 34 35 36 39 40 42 43 45 46 48 49 50 51 56 57 61 62}951do_test boundary2-2.8.ge.2 {952 db eval {953 SELECT a FROM t1 WHERE r >= 4 ORDER BY a DESC954 }955} {62 61 57 56 51 50 49 48 46 45 43 42 40 39 36 35 34 31 30 28 27 26 25 24 23 22 20 19 18 17 16 15 14 13 12 10 9 8 7 6 4 3}956do_test boundary2-2.8.ge.3 {957 db eval {958 SELECT a FROM t1 WHERE r >= 4 ORDER BY r959 }960} {31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}961do_test boundary2-2.8.ge.4 {962 db eval {963 SELECT a FROM t1 WHERE r >= 4 ORDER BY r DESC964 }965} {3 28 17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39 36 14 51 20 40 12 6 9 24 18 42 15 62 48 50 23 16 8 61 30 49 4 31}966do_test boundary2-2.8.ge.5 {967 db eval {968 SELECT a FROM t1 WHERE r >= 4 ORDER BY x969 }970} {31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}971do_test boundary2-2.8.lt.1 {972 db eval {973 SELECT a FROM t1 WHERE r < 4 ORDER BY a974 }975} {1 2 5 11 21 29 32 33 37 38 41 44 47 52 53 54 55 58 59 60 63 64}976do_test boundary2-2.8.lt.2 {977 db eval {978 SELECT a FROM t1 WHERE r < 4 ORDER BY a DESC979 }980} {64 63 60 59 58 55 54 53 52 47 44 41 38 37 33 32 29 21 11 5 2 1}981do_test boundary2-2.8.lt.3 {982 db eval {983 SELECT a FROM t1 WHERE r < 4 ORDER BY r984 }985} {55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38 59 60 41 5}986do_test boundary2-2.8.lt.4 {987 db eval {988 SELECT a FROM t1 WHERE r < 4 ORDER BY r DESC989 }990} {5 41 60 59 38 33 52 53 54 32 29 37 1 11 47 63 58 44 21 64 2 55}991do_test boundary2-2.8.lt.5 {992 db eval {993 SELECT a FROM t1 WHERE r < 4 ORDER BY x994 }995} {59 60 41 5 55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38}996do_test boundary2-2.8.le.1 {997 db eval {998 SELECT a FROM t1 WHERE r <= 4 ORDER BY a999 }1000} {1 2 5 11 21 29 31 32 33 37 38 41 44 47 52 53 54 55 58 59 60 63 64}1001do_test boundary2-2.8.le.2 {1002 db eval {1003 SELECT a FROM t1 WHERE r <= 4 ORDER BY a DESC1004 }1005} {64 63 60 59 58 55 54 53 52 47 44 41 38 37 33 32 31 29 21 11 5 2 1}1006do_test boundary2-2.8.le.3 {1007 db eval {1008 SELECT a FROM t1 WHERE r <= 4 ORDER BY r1009 }1010} {55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38 59 60 41 5 31}1011do_test boundary2-2.8.le.4 {1012 db eval {1013 SELECT a FROM t1 WHERE r <= 4 ORDER BY r DESC1014 }1015} {31 5 41 60 59 38 33 52 53 54 32 29 37 1 11 47 63 58 44 21 64 2 55}1016do_test boundary2-2.8.le.5 {1017 db eval {1018 SELECT a FROM t1 WHERE r <= 4 ORDER BY x1019 }1020} {59 60 41 5 31 55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38}1021do_test boundary2-2.9.1 {1022 db eval {1023 SELECT * FROM t1 WHERE r=5629499534213111024 }1025} {562949953421311 13 0001ffffffffffff}1026do_test boundary2-2.9.2 {1027 db eval {1028 SELECT r, a FROM t1 WHERE x='0001ffffffffffff'1029 }1030} {562949953421311 13}1031do_test boundary2-2.9.3 {1032 db eval {1033 SELECT r, x FROM t1 WHERE a=131034 }1035} {562949953421311 0001ffffffffffff}1036do_test boundary2-2.9.gt.1 {1037 db eval {1038 SELECT a FROM t1 WHERE r > 562949953421311 ORDER BY a1039 }1040} {3 17 27 28 43 45}1041do_test boundary2-2.9.gt.2 {1042 db eval {1043 SELECT a FROM t1 WHERE r > 562949953421311 ORDER BY a DESC1044 }1045} {45 43 28 27 17 3}1046do_test boundary2-2.9.gt.3 {1047 db eval {1048 SELECT a FROM t1 WHERE r > 562949953421311 ORDER BY r1049 }1050} {43 27 45 17 28 3}1051do_test boundary2-2.9.gt.4 {1052 db eval {1053 SELECT a FROM t1 WHERE r > 562949953421311 ORDER BY r DESC1054 }1055} {3 28 17 45 27 43}1056do_test boundary2-2.9.gt.5 {1057 db eval {1058 SELECT a FROM t1 WHERE r > 562949953421311 ORDER BY x1059 }1060} {43 27 45 17 28 3}1061do_test boundary2-2.9.ge.1 {1062 db eval {1063 SELECT a FROM t1 WHERE r >= 562949953421311 ORDER BY a1064 }1065} {3 13 17 27 28 43 45}1066do_test boundary2-2.9.ge.2 {1067 db eval {1068 SELECT a FROM t1 WHERE r >= 562949953421311 ORDER BY a DESC1069 }1070} {45 43 28 27 17 13 3}1071do_test boundary2-2.9.ge.3 {1072 db eval {1073 SELECT a FROM t1 WHERE r >= 562949953421311 ORDER BY r1074 }1075} {13 43 27 45 17 28 3}1076do_test boundary2-2.9.ge.4 {1077 db eval {1078 SELECT a FROM t1 WHERE r >= 562949953421311 ORDER BY r DESC1079 }1080} {3 28 17 45 27 43 13}1081do_test boundary2-2.9.ge.5 {1082 db eval {1083 SELECT a FROM t1 WHERE r >= 562949953421311 ORDER BY x1084 }1085} {13 43 27 45 17 28 3}1086do_test boundary2-2.9.lt.1 {1087 db eval {1088 SELECT a FROM t1 WHERE r < 562949953421311 ORDER BY a1089 }1090} {1 2 4 5 6 7 8 9 10 11 12 14 15 16 18 19 20 21 22 23 24 25 26 29 30 31 32 33 34 35 36 37 38 39 40 41 42 44 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64}1091do_test boundary2-2.9.lt.2 {1092 db eval {1093 SELECT a FROM t1 WHERE r < 562949953421311 ORDER BY a DESC1094 }1095} {64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 49 48 47 46 44 42 41 40 39 38 37 36 35 34 33 32 31 30 29 26 25 24 23 22 21 20 19 18 16 15 14 12 11 10 9 8 7 6 5 4 2 1}1096do_test boundary2-2.9.lt.3 {1097 db eval {1098 SELECT a FROM t1 WHERE r < 562949953421311 ORDER BY r1099 }1100} {55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38 59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26}1101do_test boundary2-2.9.lt.4 {1102 db eval {1103 SELECT a FROM t1 WHERE r < 562949953421311 ORDER BY r DESC1104 }1105} {26 10 34 25 56 7 19 57 35 46 22 39 36 14 51 20 40 12 6 9 24 18 42 15 62 48 50 23 16 8 61 30 49 4 31 5 41 60 59 38 33 52 53 54 32 29 37 1 11 47 63 58 44 21 64 2 55}1106do_test boundary2-2.9.lt.5 {1107 db eval {1108 SELECT a FROM t1 WHERE r < 562949953421311 ORDER BY x1109 }1110} {59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38}1111do_test boundary2-2.9.le.1 {1112 db eval {1113 SELECT a FROM t1 WHERE r <= 562949953421311 ORDER BY a1114 }1115} {1 2 4 5 6 7 8 9 10 11 12 13 14 15 16 18 19 20 21 22 23 24 25 26 29 30 31 32 33 34 35 36 37 38 39 40 41 42 44 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64}1116do_test boundary2-2.9.le.2 {1117 db eval {1118 SELECT a FROM t1 WHERE r <= 562949953421311 ORDER BY a DESC1119 }1120} {64 63 62 61 60 59 58 57 56 55 54 53 52 51 50 49 48 47 46 44 42 41 40 39 38 37 36 35 34 33 32 31 30 29 26 25 24 23 22 21 20 19 18 16 15 14 13 12 11 10 9 8 7 6 5 4 2 1}1121do_test boundary2-2.9.le.3 {1122 db eval {1123 SELECT a FROM t1 WHERE r <= 562949953421311 ORDER BY r1124 }1125} {55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38 59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13}1126do_test boundary2-2.9.le.4 {1127 db eval {1128 SELECT a FROM t1 WHERE r <= 562949953421311 ORDER BY r DESC1129 }1130} {13 26 10 34 25 56 7 19 57 35 46 22 39 36 14 51 20 40 12 6 9 24 18 42 15 62 48 50 23 16 8 61 30 49 4 31 5 41 60 59 38 33 52 53 54 32 29 37 1 11 47 63 58 44 21 64 2 55}1131do_test boundary2-2.9.le.5 {1132 db eval {1133 SELECT a FROM t1 WHERE r <= 562949953421311 ORDER BY x1134 }1135} {59 60 41 5 31 4 49 30 61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 55 2 64 21 44 58 63 47 11 1 37 29 32 54 53 52 33 38}1136do_test boundary2-2.10.1 {1137 db eval {1138 SELECT * FROM t1 WHERE r=2561139 }1140} {256 61 0000000000000100}1141do_test boundary2-2.10.2 {1142 db eval {1143 SELECT r, a FROM t1 WHERE x='0000000000000100'1144 }1145} {256 61}1146do_test boundary2-2.10.3 {1147 db eval {1148 SELECT r, x FROM t1 WHERE a=611149 }1150} {256 0000000000000100}1151do_test boundary2-2.10.gt.1 {1152 db eval {1153 SELECT a FROM t1 WHERE r > 256 ORDER BY a1154 }1155} {3 6 7 8 9 10 12 13 14 15 16 17 18 19 20 22 23 24 25 26 27 28 34 35 36 39 40 42 43 45 46 48 50 51 56 57 62}1156do_test boundary2-2.10.gt.2 {1157 db eval {1158 SELECT a FROM t1 WHERE r > 256 ORDER BY a DESC1159 }1160} {62 57 56 51 50 48 46 45 43 42 40 39 36 35 34 28 27 26 25 24 23 22 20 19 18 17 16 15 14 13 12 10 9 8 7 6 3}1161do_test boundary2-2.10.gt.3 {1162 db eval {1163 SELECT a FROM t1 WHERE r > 256 ORDER BY r1164 }1165} {8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}1166do_test boundary2-2.10.gt.4 {1167 db eval {1168 SELECT a FROM t1 WHERE r > 256 ORDER BY r DESC1169 }1170} {3 28 17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39 36 14 51 20 40 12 6 9 24 18 42 15 62 48 50 23 16 8}1171do_test boundary2-2.10.gt.5 {1172 db eval {1173 SELECT a FROM t1 WHERE r > 256 ORDER BY x1174 }1175} {8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}1176do_test boundary2-2.10.ge.1 {1177 db eval {1178 SELECT a FROM t1 WHERE r >= 256 ORDER BY a1179 }1180} {3 6 7 8 9 10 12 13 14 15 16 17 18 19 20 22 23 24 25 26 27 28 34 35 36 39 40 42 43 45 46 48 50 51 56 57 61 62}1181do_test boundary2-2.10.ge.2 {1182 db eval {1183 SELECT a FROM t1 WHERE r >= 256 ORDER BY a DESC1184 }1185} {62 61 57 56 51 50 48 46 45 43 42 40 39 36 35 34 28 27 26 25 24 23 22 20 19 18 17 16 15 14 13 12 10 9 8 7 6 3}1186do_test boundary2-2.10.ge.3 {1187 db eval {1188 SELECT a FROM t1 WHERE r >= 256 ORDER BY r1189 }1190} {61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}1191do_test boundary2-2.10.ge.4 {1192 db eval {1193 SELECT a FROM t1 WHERE r >= 256 ORDER BY r DESC1194 }1195} {3 28 17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39 36 14 51 20 40 12 6 9 24 18 42 15 62 48 50 23 16 8 61}1196do_test boundary2-2.10.ge.5 {1197 db eval {1198 SELECT a FROM t1 WHERE r >= 256 ORDER BY x1199 }1200} {61 8 16 23 50 48 62 15 42 18 24 9 6 12 40 20 51 14 36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}