-- original: boundary1.test -- credit: http://www.sqlite.org/src/tree?ci=trunk&name=test SELECT a FROM t1 WHERE rowid > 2097151 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid > 2097151 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid > 2097151 ORDER BY x ;SELECT a FROM t1 WHERE rowid >= 2097151 ORDER BY a ;SELECT a FROM t1 WHERE rowid >= 2097151 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid >= 2097151 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid >= 2097151 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid >= 2097151 ORDER BY x ;SELECT a FROM t1 WHERE rowid < 2097151 ORDER BY a ;SELECT a FROM t1 WHERE rowid < 2097151 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid < 2097151 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid < 2097151 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid < 2097151 ORDER BY x ;SELECT a FROM t1 WHERE rowid <= 2097151 ORDER BY a ;SELECT a FROM t1 WHERE rowid <= 2097151 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid <= 2097151 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid <= 2097151 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid <= 2097151 ORDER BY x ;SELECT * FROM t1 WHERE rowid=140737488355327 ;SELECT rowid, a FROM t1 WHERE x='00007fffffffffff' ;SELECT rowid, x FROM t1 WHERE a=25 ;SELECT a FROM t1 WHERE rowid > 140737488355327 ORDER BY a ;SELECT a FROM t1 WHERE rowid > 140737488355327 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid > 140737488355327 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid > 140737488355327 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid > 140737488355327 ORDER BY x ;SELECT a FROM t1 WHERE rowid >= 140737488355327 ORDER BY a ;SELECT a FROM t1 WHERE rowid >= 140737488355327 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid >= 140737488355327 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid >= 140737488355327 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid >= 140737488355327 ORDER BY x ;SELECT a FROM t1 WHERE rowid < 140737488355327 ORDER BY a ;SELECT a FROM t1 WHERE rowid < 140737488355327 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid < 140737488355327 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid < 140737488355327 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid < 140737488355327 ORDER BY x ;SELECT a FROM t1 WHERE rowid <= 140737488355327 ORDER BY a ;SELECT a FROM t1 WHERE rowid <= 140737488355327 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid <= 140737488355327 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid <= 140737488355327 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid <= 140737488355327 ORDER BY x ;SELECT * FROM t1 WHERE rowid=281474976710656 ;SELECT rowid, a FROM t1 WHERE x='0001000000000000' ;SELECT rowid, x FROM t1 WHERE a=26 ;SELECT a FROM t1 WHERE rowid > 281474976710656 ORDER BY a ;SELECT a FROM t1 WHERE rowid > 281474976710656 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid > 281474976710656 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid > 281474976710656 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid > 281474976710656 ORDER BY x ;SELECT a FROM t1 WHERE rowid >= 281474976710656 ORDER BY a ;SELECT a FROM t1 WHERE rowid >= 281474976710656 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid >= 281474976710656 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid >= 281474976710656 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid >= 281474976710656 ORDER BY x ;SELECT a FROM t1 WHERE rowid < 281474976710656 ORDER BY a ;SELECT a FROM t1 WHERE rowid < 281474976710656 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid < 281474976710656 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid < 281474976710656 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid < 281474976710656 ORDER BY x ;SELECT a FROM t1 WHERE rowid <= 281474976710656 ORDER BY a ;SELECT a FROM t1 WHERE rowid <= 281474976710656 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid <= 281474976710656 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid <= 281474976710656 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid <= 281474976710656 ORDER BY x ;SELECT * FROM t1 WHERE rowid=32767 ;SELECT rowid, a FROM t1 WHERE x='0000000000007fff' ;SELECT rowid, x FROM t1 WHERE a=23 ;SELECT a FROM t1 WHERE rowid > 32767 ORDER BY a ;SELECT a FROM t1 WHERE rowid > 32767 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid > 32767 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid > 32767 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid > 32767 ORDER BY x ;SELECT a FROM t1 WHERE rowid >= 32767 ORDER BY a ;SELECT a FROM t1 WHERE rowid >= 32767 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid >= 32767 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid >= 32767 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid >= 32767 ORDER BY x ;SELECT a FROM t1 WHERE rowid < 32767 ORDER BY a ;SELECT a FROM t1 WHERE rowid < 32767 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid < 32767 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid < 32767 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid < 32767 ORDER BY x ;SELECT a FROM t1 WHERE rowid <= 32767 ORDER BY a ;SELECT a FROM t1 WHERE rowid <= 32767 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid <= 32767 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid <= 32767 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid <= 32767 ORDER BY x ;SELECT * FROM t1 WHERE rowid=127 ;SELECT rowid, a FROM t1 WHERE x='000000000000007f' ;SELECT rowid, x FROM t1 WHERE a=4 ;SELECT a FROM t1 WHERE rowid > 127 ORDER BY a ;SELECT a FROM t1 WHERE rowid > 127 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid > 127 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid > 127 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid > 127 ORDER BY x ;SELECT a FROM t1 WHERE rowid >= 127 ORDER BY a ;SELECT a FROM t1 WHERE rowid >= 127 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid >= 127 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid >= 127 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid >= 127 ORDER BY x;