# 2008 December 11

#

# 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 is automatically generated from a separate TCL script.

# This file seeks to exercise integer boundary values.

#

# $Id: boundary3.test,v 1.2 2009/01/02 15:45:48 shane Exp $

set testdir [file dirname $argv0]

source $testdir/tester.tcl

# Many of the boundary tests depend on a working 64-bit implementation.

if {![working_64bit_int]} { finish_test; return }

do_test boundary3-1.1 {

db eval {

CREATE TABLE t1(a,x);

INSERT INTO t1(oid,a,x) VALUES(-8388609,1,'ffffffffff7fffff');

INSERT INTO t1(oid,a,x) VALUES(-36028797018963969,2,'ff7fffffffffffff');

INSERT INTO t1(oid,a,x) VALUES(9223372036854775807,3,'7fffffffffffffff');

INSERT INTO t1(oid,a,x) VALUES(127,4,'000000000000007f');

INSERT INTO t1(oid,a,x) VALUES(3,5,'0000000000000003');

INSERT INTO t1(oid,a,x) VALUES(16777216,6,'0000000001000000');

INSERT INTO t1(oid,a,x) VALUES(4398046511103,7,'000003ffffffffff');

INSERT INTO t1(oid,a,x) VALUES(16383,8,'0000000000003fff');

INSERT INTO t1(oid,a,x) VALUES(16777215,9,'0000000000ffffff');

INSERT INTO t1(oid,a,x) VALUES(281474976710655,10,'0000ffffffffffff');

INSERT INTO t1(oid,a,x) VALUES(-2147483648,11,'ffffffff80000000');

INSERT INTO t1(oid,a,x) VALUES(268435455,12,'000000000fffffff');

INSERT INTO t1(oid,a,x) VALUES(562949953421311,13,'0001ffffffffffff');

INSERT INTO t1(oid,a,x) VALUES(4294967295,14,'00000000ffffffff');

INSERT INTO t1(oid,a,x) VALUES(2097151,15,'00000000001fffff');

INSERT INTO t1(oid,a,x) VALUES(16384,16,'0000000000004000');

INSERT INTO t1(oid,a,x) VALUES(72057594037927935,17,'00ffffffffffffff');

INSERT INTO t1(oid,a,x) VALUES(8388607,18,'00000000007fffff');

INSERT INTO t1(oid,a,x) VALUES(1099511627776,19,'0000010000000000');

INSERT INTO t1(oid,a,x) VALUES(2147483647,20,'000000007fffffff');

INSERT INTO t1(oid,a,x) VALUES(-140737488355329,21,'ffff7fffffffffff');

INSERT INTO t1(oid,a,x) VALUES(34359738368,22,'0000000800000000');

INSERT INTO t1(oid,a,x) VALUES(32767,23,'0000000000007fff');

INSERT INTO t1(oid,a,x) VALUES(8388608,24,'0000000000800000');

INSERT INTO t1(oid,a,x) VALUES(140737488355327,25,'00007fffffffffff');

INSERT INTO t1(oid,a,x) VALUES(281474976710656,26,'0001000000000000');

INSERT INTO t1(oid,a,x) VALUES(36028797018963967,27,'007fffffffffffff');

INSERT INTO t1(oid,a,x) VALUES(72057594037927936,28,'0100000000000000');

INSERT INTO t1(oid,a,x) VALUES(-32769,29,'ffffffffffff7fff');

INSERT INTO t1(oid,a,x) VALUES(255,30,'00000000000000ff');

INSERT INTO t1(oid,a,x) VALUES(4,31,'0000000000000004');

INSERT INTO t1(oid,a,x) VALUES(-32768,32,'ffffffffffff8000');

INSERT INTO t1(oid,a,x) VALUES(-2,33,'fffffffffffffffe');

INSERT INTO t1(oid,a,x) VALUES(140737488355328,34,'0000800000000000');

INSERT INTO t1(oid,a,x) VALUES(549755813888,35,'0000008000000000');

INSERT INTO t1(oid,a,x) VALUES(4294967296,36,'0000000100000000');

INSERT INTO t1(oid,a,x) VALUES(-8388608,37,'ffffffffff800000');

INSERT INTO t1(oid,a,x) VALUES(-1,38,'ffffffffffffffff');

INSERT INTO t1(oid,a,x) VALUES(34359738367,39,'00000007ffffffff');

INSERT INTO t1(oid,a,x) VALUES(268435456,40,'0000000010000000');

INSERT INTO t1(oid,a,x) VALUES(2,41,'0000000000000002');

INSERT INTO t1(oid,a,x) VALUES(2097152,42,'0000000000200000');

INSERT INTO t1(oid,a,x) VALUES(562949953421312,43,'0002000000000000');

INSERT INTO t1(oid,a,x) VALUES(-140737488355328,44,'ffff800000000000');

INSERT INTO t1(oid,a,x) VALUES(36028797018963968,45,'0080000000000000');

INSERT INTO t1(oid,a,x) VALUES(549755813887,46,'0000007fffffffff');

INSERT INTO t1(oid,a,x) VALUES(-2147483649,47,'ffffffff7fffffff');

INSERT INTO t1(oid,a,x) VALUES(65535,48,'000000000000ffff');

INSERT INTO t1(oid,a,x) VALUES(128,49,'0000000000000080');

INSERT INTO t1(oid,a,x) VALUES(32768,50,'0000000000008000');

INSERT INTO t1(oid,a,x) VALUES(2147483648,51,'0000000080000000');

INSERT INTO t1(oid,a,x) VALUES(-3,52,'fffffffffffffffd');

INSERT INTO t1(oid,a,x) VALUES(-128,53,'ffffffffffffff80');

INSERT INTO t1(oid,a,x) VALUES(-129,54,'ffffffffffffff7f');

INSERT INTO t1(oid,a,x) VALUES(-9223372036854775808,55,'8000000000000000');

INSERT INTO t1(oid,a,x) VALUES(4398046511104,56,'0000040000000000');

INSERT INTO t1(oid,a,x) VALUES(1099511627775,57,'000000ffffffffff');

INSERT INTO t1(oid,a,x) VALUES(-549755813889,58,'ffffff7fffffffff');

INSERT INTO t1(oid,a,x) VALUES(0,59,'0000000000000000');

INSERT INTO t1(oid,a,x) VALUES(1,60,'0000000000000001');

INSERT INTO t1(oid,a,x) VALUES(256,61,'0000000000000100');

INSERT INTO t1(oid,a,x) VALUES(65536,62,'0000000000010000');

INSERT INTO t1(oid,a,x) VALUES(-549755813888,63,'ffffff8000000000');

INSERT INTO t1(oid,a,x) VALUES(-36028797018963968,64,'ff80000000000000');

CREATE INDEX t1i1 ON t1(a);

CREATE INDEX t1i2 ON t1(x);

}

} {}

do_test boundary3-1.2 {

db eval {

SELECT count(*) FROM t1

}

} {64}

do_test boundary3-1.3 {

db eval {

CREATE TABLE t2(r,a);

INSERT INTO t2 SELECT rowid, a FROM t1;

CREATE INDEX t2i1 ON t2(r);

CREATE INDEX t2i2 ON t2(a);

INSERT INTO t2 VALUES(9.22337303685477580800e+18,65);

INSERT INTO t2 VALUES(-9.22337303685477580800e+18,66);

SELECT count(*) FROM t2;

}

} {66}

do_test boundary3-2.1.1 {

db eval {

SELECT t1.* FROM t1, t2 WHERE t1.rowid=72057594037927935 AND t2.a=t1.a

}

} {17 00ffffffffffffff}

do_test boundary3-2.1.2 {

db eval {

SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='00ffffffffffffff'

}

} {72057594037927935 17}

do_test boundary3-2.1.3 {

db eval {

SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=17

}

} {72057594037927935 00ffffffffffffff}

do_test boundary3-2.1.gt.1 {

db eval {

SELECT t2.a FROM t1 JOIN t2 USING(a)

WHERE t1.rowid > 72057594037927935 ORDER BY t2.a

}

} {3 28}

do_test boundary3-2.1.gt.2 {

db eval {

SELECT t2.a FROM t2 NATURAL JOIN t1

WHERE t1.rowid > 72057594037927935 ORDER BY t1.a DESC

}

} {28 3}

do_test boundary3-2.1.gt.3 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r

WHERE t2.a=17

ORDER BY t1.rowid

}

} {28 3}

do_test boundary3-2.1.gt.4 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r

WHERE t2.a=17

ORDER BY t1.rowid DESC

}

} {3 28}

do_test boundary3-2.1.gt.5 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r

WHERE t2.a=17

ORDER BY x

}

} {28 3}

do_test boundary3-2.1.ge.1 {

db eval {

SELECT t2.a FROM t1 JOIN t2 USING(a)

WHERE t1.rowid >= 72057594037927935 ORDER BY t2.a

}

} {3 17 28}

do_test boundary3-2.1.ge.2 {

db eval {

SELECT t2.a FROM t2 NATURAL JOIN t1

WHERE t1.rowid >= 72057594037927935 ORDER BY t1.a DESC

}

} {28 17 3}

do_test boundary3-2.1.ge.3 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r

WHERE t2.a=17

ORDER BY t1.rowid

}

} {17 28 3}

do_test boundary3-2.1.ge.4 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r

WHERE t2.a=17

ORDER BY t1.rowid DESC

}

} {3 28 17}

do_test boundary3-2.1.ge.5 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r

WHERE t2.a=17

ORDER BY x

}

} {17 28 3}

do_test boundary3-2.1.lt.1 {

db eval {

SELECT t2.a FROM t1 JOIN t2 USING(a)

WHERE t1.rowid < 72057594037927935 ORDER BY t2.a

}

} {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}

do_test boundary3-2.1.lt.2 {

db eval {

SELECT t2.a FROM t2 NATURAL JOIN t1

WHERE t1.rowid < 72057594037927935 ORDER BY t1.a DESC

}

} {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}

do_test boundary3-2.1.lt.3 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r

WHERE t2.a=17

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.1.lt.4 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r

WHERE t2.a=17

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.1.lt.5 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r

WHERE t2.a=17

ORDER BY x

}

} {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}

do_test boundary3-2.1.le.1 {

db eval {

SELECT t2.a FROM t1 JOIN t2 USING(a)

WHERE t1.rowid <= 72057594037927935 ORDER BY t2.a

}

} {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}

do_test boundary3-2.1.le.2 {

db eval {

SELECT t2.a FROM t2 NATURAL JOIN t1

WHERE t1.rowid <= 72057594037927935 ORDER BY t1.a DESC

}

} {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}

do_test boundary3-2.1.le.3 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r

WHERE t2.a=17

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.1.le.4 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r

WHERE t2.a=17

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.1.le.5 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r

WHERE t2.a=17

ORDER BY x

}

} {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}

do_test boundary3-2.2.1 {

db eval {

SELECT t1.* FROM t1, t2 WHERE t1.rowid=16384 AND t2.a=t1.a

}

} {16 0000000000004000}

do_test boundary3-2.2.2 {

db eval {

SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000000004000'

}

} {16384 16}

do_test boundary3-2.2.3 {

db eval {

SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=16

}

} {16384 0000000000004000}

do_test boundary3-2.2.gt.1 {

db eval {

SELECT t2.a FROM t1 JOIN t2 USING(a)

WHERE t1.rowid > 16384 ORDER BY t2.a

}

} {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}

do_test boundary3-2.2.gt.2 {

db eval {

SELECT t2.a FROM t2 NATURAL JOIN t1

WHERE t1.rowid > 16384 ORDER BY t1.a DESC

}

} {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}

do_test boundary3-2.2.gt.3 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r

WHERE t2.a=16

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.2.gt.4 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r

WHERE t2.a=16

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.2.gt.5 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r

WHERE t2.a=16

ORDER BY x

}

} {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}

do_test boundary3-2.2.gt.10 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)

WHERE t2.a=16

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.2.gt.11 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)

WHERE t2.a=16

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.2.ge.1 {

db eval {

SELECT t2.a FROM t1 JOIN t2 USING(a)

WHERE t1.rowid >= 16384 ORDER BY t2.a

}

} {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}

do_test boundary3-2.2.ge.2 {

db eval {

SELECT t2.a FROM t2 NATURAL JOIN t1

WHERE t1.rowid >= 16384 ORDER BY t1.a DESC

}

} {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}

do_test boundary3-2.2.ge.3 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r

WHERE t2.a=16

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.2.ge.4 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r

WHERE t2.a=16

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.2.ge.5 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r

WHERE t2.a=16

ORDER BY x

}

} {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}

do_test boundary3-2.2.ge.10 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)

WHERE t2.a=16

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.2.ge.11 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)

WHERE t2.a=16

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.2.lt.1 {

db eval {

SELECT t2.a FROM t1 JOIN t2 USING(a)

WHERE t1.rowid < 16384 ORDER BY t2.a

}

} {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}

do_test boundary3-2.2.lt.2 {

db eval {

SELECT t2.a FROM t2 NATURAL JOIN t1

WHERE t1.rowid < 16384 ORDER BY t1.a DESC

}

} {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}

do_test boundary3-2.2.lt.3 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r

WHERE t2.a=16

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.2.lt.4 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r

WHERE t2.a=16

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.2.lt.5 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r

WHERE t2.a=16

ORDER BY x

}

} {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}

do_test boundary3-2.2.lt.10 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)

WHERE t2.a=16

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.2.lt.11 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)

WHERE t2.a=16

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.2.le.1 {

db eval {

SELECT t2.a FROM t1 JOIN t2 USING(a)

WHERE t1.rowid <= 16384 ORDER BY t2.a

}

} {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}

do_test boundary3-2.2.le.2 {

db eval {

SELECT t2.a FROM t2 NATURAL JOIN t1

WHERE t1.rowid <= 16384 ORDER BY t1.a DESC

}

} {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}

do_test boundary3-2.2.le.3 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r

WHERE t2.a=16

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.2.le.4 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r

WHERE t2.a=16

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.2.le.5 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r

WHERE t2.a=16

ORDER BY x

}

} {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}

do_test boundary3-2.2.le.10 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)

WHERE t2.a=16

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.2.le.11 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)

WHERE t2.a=16

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.3.1 {

db eval {

SELECT t1.* FROM t1, t2 WHERE t1.rowid=4294967296 AND t2.a=t1.a

}

} {36 0000000100000000}

do_test boundary3-2.3.2 {

db eval {

SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000100000000'

}

} {4294967296 36}

do_test boundary3-2.3.3 {

db eval {

SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=36

}

} {4294967296 0000000100000000}

do_test boundary3-2.3.gt.1 {

db eval {

SELECT t2.a FROM t1 JOIN t2 USING(a)

WHERE t1.rowid > 4294967296 ORDER BY t2.a

}

} {3 7 10 13 17 19 22 25 26 27 28 34 35 39 43 45 46 56 57}

do_test boundary3-2.3.gt.2 {

db eval {

SELECT t2.a FROM t2 NATURAL JOIN t1

WHERE t1.rowid > 4294967296 ORDER BY t1.a DESC

}

} {57 56 46 45 43 39 35 34 28 27 26 25 22 19 17 13 10 7 3}

do_test boundary3-2.3.gt.3 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r

WHERE t2.a=36

ORDER BY t1.rowid

}

} {39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}

do_test boundary3-2.3.gt.4 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r

WHERE t2.a=36

ORDER BY t1.rowid DESC

}

} {3 28 17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39}

do_test boundary3-2.3.gt.5 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r

WHERE t2.a=36

ORDER BY x

}

} {39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}

do_test boundary3-2.3.gt.10 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)

WHERE t2.a=36

ORDER BY t1.rowid

}

} {39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}

do_test boundary3-2.3.gt.11 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)

WHERE t2.a=36

ORDER BY t1.rowid DESC

}

} {3 28 17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39}

do_test boundary3-2.3.ge.1 {

db eval {

SELECT t2.a FROM t1 JOIN t2 USING(a)

WHERE t1.rowid >= 4294967296 ORDER BY t2.a

}

} {3 7 10 13 17 19 22 25 26 27 28 34 35 36 39 43 45 46 56 57}

do_test boundary3-2.3.ge.2 {

db eval {

SELECT t2.a FROM t2 NATURAL JOIN t1

WHERE t1.rowid >= 4294967296 ORDER BY t1.a DESC

}

} {57 56 46 45 43 39 36 35 34 28 27 26 25 22 19 17 13 10 7 3}

do_test boundary3-2.3.ge.3 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r

WHERE t2.a=36

ORDER BY t1.rowid

}

} {36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}

do_test boundary3-2.3.ge.4 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r

WHERE t2.a=36

ORDER BY t1.rowid DESC

}

} {3 28 17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39 36}

do_test boundary3-2.3.ge.5 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r

WHERE t2.a=36

ORDER BY x

}

} {36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}

do_test boundary3-2.3.ge.10 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)

WHERE t2.a=36

ORDER BY t1.rowid

}

} {36 39 22 46 35 57 19 7 56 25 34 10 26 13 43 27 45 17 28 3}

do_test boundary3-2.3.ge.11 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)

WHERE t2.a=36

ORDER BY t1.rowid DESC

}

} {3 28 17 45 27 43 13 26 10 34 25 56 7 19 57 35 46 22 39 36}

do_test boundary3-2.3.lt.1 {

db eval {

SELECT t2.a FROM t1 JOIN t2 USING(a)

WHERE t1.rowid < 4294967296 ORDER BY t2.a

}

} {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}

do_test boundary3-2.3.lt.2 {

db eval {

SELECT t2.a FROM t2 NATURAL JOIN t1

WHERE t1.rowid < 4294967296 ORDER BY t1.a DESC

}

} {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}

do_test boundary3-2.3.lt.3 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r

WHERE t2.a=36

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.3.lt.4 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r

WHERE t2.a=36

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.3.lt.5 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r

WHERE t2.a=36

ORDER BY x

}

} {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}

do_test boundary3-2.3.lt.10 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)

WHERE t2.a=36

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.3.lt.11 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)

WHERE t2.a=36

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.3.le.1 {

db eval {

SELECT t2.a FROM t1 JOIN t2 USING(a)

WHERE t1.rowid <= 4294967296 ORDER BY t2.a

}

} {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}

do_test boundary3-2.3.le.2 {

db eval {

SELECT t2.a FROM t2 NATURAL JOIN t1

WHERE t1.rowid <= 4294967296 ORDER BY t1.a DESC

}

} {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}

do_test boundary3-2.3.le.3 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r

WHERE t2.a=36

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.3.le.4 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r

WHERE t2.a=36

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.3.le.5 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r

WHERE t2.a=36

ORDER BY x

}

} {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}

do_test boundary3-2.3.le.10 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)

WHERE t2.a=36

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.3.le.11 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)

WHERE t2.a=36

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.4.1 {

db eval {

SELECT t1.* FROM t1, t2 WHERE t1.rowid=16777216 AND t2.a=t1.a

}

} {6 0000000001000000}

do_test boundary3-2.4.2 {

db eval {

SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000001000000'

}

} {16777216 6}

do_test boundary3-2.4.3 {

db eval {

SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=6

}

} {16777216 0000000001000000}

do_test boundary3-2.4.gt.1 {

db eval {

SELECT t2.a FROM t1 JOIN t2 USING(a)

WHERE t1.rowid > 16777216 ORDER BY t2.a

}

} {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}

do_test boundary3-2.4.gt.2 {

db eval {

SELECT t2.a FROM t2 NATURAL JOIN t1

WHERE t1.rowid > 16777216 ORDER BY t1.a DESC

}

} {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}

do_test boundary3-2.4.gt.3 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r

WHERE t2.a=6

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.4.gt.4 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r

WHERE t2.a=6

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.4.gt.5 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r

WHERE t2.a=6

ORDER BY x

}

} {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}

do_test boundary3-2.4.gt.10 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)

WHERE t2.a=6

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.4.gt.11 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)

WHERE t2.a=6

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.4.ge.1 {

db eval {

SELECT t2.a FROM t1 JOIN t2 USING(a)

WHERE t1.rowid >= 16777216 ORDER BY t2.a

}

} {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}

do_test boundary3-2.4.ge.2 {

db eval {

SELECT t2.a FROM t2 NATURAL JOIN t1

WHERE t1.rowid >= 16777216 ORDER BY t1.a DESC

}

} {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}

do_test boundary3-2.4.ge.3 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r

WHERE t2.a=6

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.4.ge.4 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r

WHERE t2.a=6

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.4.ge.5 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r

WHERE t2.a=6

ORDER BY x

}

} {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}

do_test boundary3-2.4.ge.10 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)

WHERE t2.a=6

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.4.ge.11 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)

WHERE t2.a=6

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.4.lt.1 {

db eval {

SELECT t2.a FROM t1 JOIN t2 USING(a)

WHERE t1.rowid < 16777216 ORDER BY t2.a

}

} {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}

do_test boundary3-2.4.lt.2 {

db eval {

SELECT t2.a FROM t2 NATURAL JOIN t1

WHERE t1.rowid < 16777216 ORDER BY t1.a DESC

}

} {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}

do_test boundary3-2.4.lt.3 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r

WHERE t2.a=6

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.4.lt.4 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r

WHERE t2.a=6

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.4.lt.5 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r

WHERE t2.a=6

ORDER BY x

}

} {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}

do_test boundary3-2.4.lt.10 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)

WHERE t2.a=6

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.4.lt.11 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real)

WHERE t2.a=6

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.4.le.1 {

db eval {

SELECT t2.a FROM t1 JOIN t2 USING(a)

WHERE t1.rowid <= 16777216 ORDER BY t2.a

}

} {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}

do_test boundary3-2.4.le.2 {

db eval {

SELECT t2.a FROM t2 NATURAL JOIN t1

WHERE t1.rowid <= 16777216 ORDER BY t1.a DESC

}

} {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}

do_test boundary3-2.4.le.3 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r

WHERE t2.a=6

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.4.le.4 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r

WHERE t2.a=6

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.4.le.5 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r

WHERE t2.a=6

ORDER BY x

}

} {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}

do_test boundary3-2.4.le.10 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)

WHERE t2.a=6

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.4.le.11 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real)

WHERE t2.a=6

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.5.1 {

db eval {

SELECT t1.* FROM t1, t2 WHERE t1.rowid=-32769 AND t2.a=t1.a

}

} {29 ffffffffffff7fff}

do_test boundary3-2.5.2 {

db eval {

SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='ffffffffffff7fff'

}

} {-32769 29}

do_test boundary3-2.5.3 {

db eval {

SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=29

}

} {-32769 ffffffffffff7fff}

do_test boundary3-2.5.gt.1 {

db eval {

SELECT t2.a FROM t1 JOIN t2 USING(a)

WHERE t1.rowid > -32769 ORDER BY t2.a

}

} {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}

do_test boundary3-2.5.gt.2 {

db eval {

SELECT t2.a FROM t2 NATURAL JOIN t1

WHERE t1.rowid > -32769 ORDER BY t1.a DESC

}

} {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}

do_test boundary3-2.5.gt.3 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r

WHERE t2.a=29

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.5.gt.4 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r

WHERE t2.a=29

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.5.gt.5 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r

WHERE t2.a=29

ORDER BY x

}

} {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}

do_test boundary3-2.5.gt.10 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)

WHERE t2.a=29

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.5.gt.11 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real)

WHERE t2.a=29

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.5.ge.1 {

db eval {

SELECT t2.a FROM t1 JOIN t2 USING(a)

WHERE t1.rowid >= -32769 ORDER BY t2.a

}

} {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}

do_test boundary3-2.5.ge.2 {

db eval {

SELECT t2.a FROM t2 NATURAL JOIN t1

WHERE t1.rowid >= -32769 ORDER BY t1.a DESC

}

} {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}

do_test boundary3-2.5.ge.3 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r

WHERE t2.a=29

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.5.ge.4 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r

WHERE t2.a=29

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.5.ge.5 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r

WHERE t2.a=29

ORDER BY x

}

} {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}

do_test boundary3-2.5.ge.10 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)

WHERE t2.a=29

ORDER BY t1.rowid

}

} {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}

do_test boundary3-2.5.ge.11 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real)

WHERE t2.a=29

ORDER BY t1.rowid DESC

}

} {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}

do_test boundary3-2.5.lt.1 {

db eval {

SELECT t2.a FROM t1 JOIN t2 USING(a)

WHERE t1.rowid < -32769 ORDER BY t2.a

}

} {1 2 11 21 37 44 47 55 58 63 64}

do_test boundary3-2.5.lt.2 {

db eval {

SELECT t2.a FROM t2 NATURAL JOIN t1

WHERE t1.rowid < -32769 ORDER BY t1.a DESC

}

} {64 63 58 55 47 44 37 21 11 2 1}

do_test boundary3-2.5.lt.3 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r

WHERE t2.a=29

ORDER BY t1.rowid

}

} {55 2 64 21 44 58 63 47 11 1 37}

do_test boundary3-2.5.lt.4 {

db eval {

SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r

WHERE t2.a=29

ORDER BY t1.rowid DESC

}