-- original: boundary3.test -- credit: http://www.sqlite.org/src/tree?ci=trunk&name=test SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r WHERE t2.a=41 ORDER BY t1.rowid DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r WHERE t2.a=41 ORDER BY x ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real) WHERE t2.a=41 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real) WHERE t2.a=41 ORDER BY t1.rowid DESC ;SELECT t1.* FROM t1, t2 WHERE t1.rowid=4 AND t2.a=t1.a ;SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000000000004' ;SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=31 ;SELECT t2.a FROM t1 JOIN t2 USING(a) WHERE t1.rowid > 4 ORDER BY t2.a ;SELECT t2.a FROM t2 NATURAL JOIN t1 WHERE t1.rowid > 4 ORDER BY t1.a DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r WHERE t2.a=31 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r WHERE t2.a=31 ORDER BY t1.rowid DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r WHERE t2.a=31 ORDER BY x ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real) WHERE t2.a=31 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real) WHERE t2.a=31 ORDER BY t1.rowid DESC ;SELECT t2.a FROM t1 JOIN t2 USING(a) WHERE t1.rowid >= 4 ORDER BY t2.a ;SELECT t2.a FROM t2 NATURAL JOIN t1 WHERE t1.rowid >= 4 ORDER BY t1.a DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r WHERE t2.a=31 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r WHERE t2.a=31 ORDER BY t1.rowid DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r WHERE t2.a=31 ORDER BY x ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real) WHERE t2.a=31 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real) WHERE t2.a=31 ORDER BY t1.rowid DESC ;SELECT t2.a FROM t1 JOIN t2 USING(a) WHERE t1.rowid < 4 ORDER BY t2.a ;SELECT t2.a FROM t2 NATURAL JOIN t1 WHERE t1.rowid < 4 ORDER BY t1.a DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r WHERE t2.a=31 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r WHERE t2.a=31 ORDER BY t1.rowid DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r WHERE t2.a=31 ORDER BY x ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real) WHERE t2.a=31 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real) WHERE t2.a=31 ORDER BY t1.rowid DESC ;SELECT t2.a FROM t1 JOIN t2 USING(a) WHERE t1.rowid <= 4 ORDER BY t2.a ;SELECT t2.a FROM t2 NATURAL JOIN t1 WHERE t1.rowid <= 4 ORDER BY t1.a DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r WHERE t2.a=31 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r WHERE t2.a=31 ORDER BY t1.rowid DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r WHERE t2.a=31 ORDER BY x ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real) WHERE t2.a=31 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real) WHERE t2.a=31 ORDER BY t1.rowid DESC ;SELECT t1.* FROM t1, t2 WHERE t1.rowid=562949953421311 AND t2.a=t1.a ;SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0001ffffffffffff' ;SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=13 ;SELECT t2.a FROM t1 JOIN t2 USING(a) WHERE t1.rowid > 562949953421311 ORDER BY t2.a ;SELECT t2.a FROM t2 NATURAL JOIN t1 WHERE t1.rowid > 562949953421311 ORDER BY t1.a DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r WHERE t2.a=13 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r WHERE t2.a=13 ORDER BY t1.rowid DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r WHERE t2.a=13 ORDER BY x ;SELECT t2.a FROM t1 JOIN t2 USING(a) WHERE t1.rowid >= 562949953421311 ORDER BY t2.a ;SELECT t2.a FROM t2 NATURAL JOIN t1 WHERE t1.rowid >= 562949953421311 ORDER BY t1.a DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r WHERE t2.a=13 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r WHERE t2.a=13 ORDER BY t1.rowid DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r WHERE t2.a=13 ORDER BY x ;SELECT t2.a FROM t1 JOIN t2 USING(a) WHERE t1.rowid < 562949953421311 ORDER BY t2.a ;SELECT t2.a FROM t2 NATURAL JOIN t1 WHERE t1.rowid < 562949953421311 ORDER BY t1.a DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r WHERE t2.a=13 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r WHERE t2.a=13 ORDER BY t1.rowid DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r WHERE t2.a=13 ORDER BY x ;SELECT t2.a FROM t1 JOIN t2 USING(a) WHERE t1.rowid <= 562949953421311 ORDER BY t2.a ;SELECT t2.a FROM t2 NATURAL JOIN t1 WHERE t1.rowid <= 562949953421311 ORDER BY t1.a DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r WHERE t2.a=13 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r WHERE t2.a=13 ORDER BY t1.rowid DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r WHERE t2.a=13 ORDER BY x ;SELECT t1.* FROM t1, t2 WHERE t1.rowid=256 AND t2.a=t1.a ;SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000000000100' ;SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=61 ;SELECT t2.a FROM t1 JOIN t2 USING(a) WHERE t1.rowid > 256 ORDER BY t2.a ;SELECT t2.a FROM t2 NATURAL JOIN t1 WHERE t1.rowid > 256 ORDER BY t1.a DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r WHERE t2.a=61 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r WHERE t2.a=61 ORDER BY t1.rowid DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r WHERE t2.a=61 ORDER BY x ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real) WHERE t2.a=61 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real) WHERE t2.a=61 ORDER BY t1.rowid DESC ;SELECT t2.a FROM t1 JOIN t2 USING(a) WHERE t1.rowid >= 256 ORDER BY t2.a ;SELECT t2.a FROM t2 NATURAL JOIN t1 WHERE t1.rowid >= 256 ORDER BY t1.a DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r WHERE t2.a=61 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r WHERE t2.a=61 ORDER BY t1.rowid DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= t2.r WHERE t2.a=61 ORDER BY x ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real) WHERE t2.a=61 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid >= CAST(t2.r AS real) WHERE t2.a=61 ORDER BY t1.rowid DESC ;SELECT t2.a FROM t1 JOIN t2 USING(a) WHERE t1.rowid < 256 ORDER BY t2.a ;SELECT t2.a FROM t2 NATURAL JOIN t1 WHERE t1.rowid < 256 ORDER BY t1.a DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r WHERE t2.a=61 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r WHERE t2.a=61 ORDER BY t1.rowid DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < t2.r WHERE t2.a=61 ORDER BY x ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real) WHERE t2.a=61 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid < CAST(t2.r AS real) WHERE t2.a=61 ORDER BY t1.rowid DESC ;SELECT t2.a FROM t1 JOIN t2 USING(a) WHERE t1.rowid <= 256 ORDER BY t2.a ;SELECT t2.a FROM t2 NATURAL JOIN t1 WHERE t1.rowid <= 256 ORDER BY t1.a DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r WHERE t2.a=61 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r WHERE t2.a=61 ORDER BY t1.rowid DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= t2.r WHERE t2.a=61 ORDER BY x ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real) WHERE t2.a=61 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid <= CAST(t2.r AS real) WHERE t2.a=61 ORDER BY t1.rowid DESC ;SELECT t1.* FROM t1, t2 WHERE t1.rowid=34359738368 AND t2.a=t1.a ;SELECT t2.* FROM t1 JOIN t2 USING(a) WHERE x='0000000800000000' ;SELECT t1.rowid, x FROM t1 JOIN t2 ON t2.r=t1.rowid WHERE t2.a=22 ;SELECT t2.a FROM t1 JOIN t2 USING(a) WHERE t1.rowid > 34359738368 ORDER BY t2.a ;SELECT t2.a FROM t2 NATURAL JOIN t1 WHERE t1.rowid > 34359738368 ORDER BY t1.a DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r WHERE t2.a=22 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r WHERE t2.a=22 ORDER BY t1.rowid DESC ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > t2.r WHERE t2.a=22 ORDER BY x ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real) WHERE t2.a=22 ORDER BY t1.rowid ;SELECT t1.a FROM t1 JOIN t2 ON t1.rowid > CAST(t2.r AS real) WHERE t2.a=22 ORDER BY t1.rowid DESC ;SELECT t2.a FROM t1 JOIN t2 USING(a) WHERE t1.rowid >= 34359738368 ORDER BY t2.a;