-- original: boundary1.test -- credit: http://www.sqlite.org/src/tree?ci=trunk&name=test SELECT a FROM t1 WHERE rowid > -32769 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid > -32769 ORDER BY x ;SELECT a FROM t1 WHERE rowid >= -32769 ORDER BY a ;SELECT a FROM t1 WHERE rowid >= -32769 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid >= -32769 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid >= -32769 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid >= -32769 ORDER BY x ;SELECT a FROM t1 WHERE rowid < -32769 ORDER BY a ;SELECT a FROM t1 WHERE rowid < -32769 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid < -32769 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid < -32769 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid < -32769 ORDER BY x ;SELECT a FROM t1 WHERE rowid <= -32769 ORDER BY a ;SELECT a FROM t1 WHERE rowid <= -32769 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid <= -32769 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid <= -32769 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid <= -32769 ORDER BY x ;SELECT * FROM t1 WHERE rowid=-140737488355329 ;SELECT rowid, a FROM t1 WHERE x='ffff7fffffffffff' ;SELECT rowid, x FROM t1 WHERE a=21 ;SELECT a FROM t1 WHERE rowid > -140737488355329 ORDER BY a ;SELECT a FROM t1 WHERE rowid > -140737488355329 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid > -140737488355329 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid > -140737488355329 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid > -140737488355329 ORDER BY x ;SELECT a FROM t1 WHERE rowid >= -140737488355329 ORDER BY a ;SELECT a FROM t1 WHERE rowid >= -140737488355329 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid >= -140737488355329 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid >= -140737488355329 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid >= -140737488355329 ORDER BY x ;SELECT a FROM t1 WHERE rowid < -140737488355329 ORDER BY a ;SELECT a FROM t1 WHERE rowid < -140737488355329 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid < -140737488355329 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid < -140737488355329 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid < -140737488355329 ORDER BY x ;SELECT a FROM t1 WHERE rowid <= -140737488355329 ORDER BY a ;SELECT a FROM t1 WHERE rowid <= -140737488355329 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid <= -140737488355329 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid <= -140737488355329 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid <= -140737488355329 ORDER BY x ;SELECT * FROM t1 WHERE rowid=2 ;SELECT rowid, a FROM t1 WHERE x='0000000000000002' ;SELECT rowid, x FROM t1 WHERE a=41 ;SELECT a FROM t1 WHERE rowid > 2 ORDER BY a ;SELECT a FROM t1 WHERE rowid > 2 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid > 2 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid > 2 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid > 2 ORDER BY x ;SELECT a FROM t1 WHERE rowid >= 2 ORDER BY a ;SELECT a FROM t1 WHERE rowid >= 2 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid >= 2 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid >= 2 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid >= 2 ORDER BY x ;SELECT a FROM t1 WHERE rowid < 2 ORDER BY a ;SELECT a FROM t1 WHERE rowid < 2 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid < 2 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid < 2 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid < 2 ORDER BY x ;SELECT a FROM t1 WHERE rowid <= 2 ORDER BY a ;SELECT a FROM t1 WHERE rowid <= 2 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid <= 2 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid <= 2 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid <= 2 ORDER BY x ;SELECT * FROM t1 WHERE rowid=4 ;SELECT rowid, a FROM t1 WHERE x='0000000000000004' ;SELECT rowid, x FROM t1 WHERE a=31 ;SELECT a FROM t1 WHERE rowid > 4 ORDER BY a ;SELECT a FROM t1 WHERE rowid > 4 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid > 4 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid > 4 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid > 4 ORDER BY x ;SELECT a FROM t1 WHERE rowid >= 4 ORDER BY a ;SELECT a FROM t1 WHERE rowid >= 4 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid >= 4 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid >= 4 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid >= 4 ORDER BY x ;SELECT a FROM t1 WHERE rowid < 4 ORDER BY a ;SELECT a FROM t1 WHERE rowid < 4 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid < 4 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid < 4 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid < 4 ORDER BY x ;SELECT a FROM t1 WHERE rowid <= 4 ORDER BY a ;SELECT a FROM t1 WHERE rowid <= 4 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid <= 4 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid <= 4 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid <= 4 ORDER BY x ;SELECT * FROM t1 WHERE rowid=562949953421311 ;SELECT rowid, a FROM t1 WHERE x='0001ffffffffffff' ;SELECT rowid, x FROM t1 WHERE a=13 ;SELECT a FROM t1 WHERE rowid > 562949953421311 ORDER BY a ;SELECT a FROM t1 WHERE rowid > 562949953421311 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid > 562949953421311 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid > 562949953421311 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid > 562949953421311 ORDER BY x ;SELECT a FROM t1 WHERE rowid >= 562949953421311 ORDER BY a ;SELECT a FROM t1 WHERE rowid >= 562949953421311 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid >= 562949953421311 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid >= 562949953421311 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid >= 562949953421311 ORDER BY x ;SELECT a FROM t1 WHERE rowid < 562949953421311 ORDER BY a;