-- original: boundary1.test -- credit: http://www.sqlite.org/src/tree?ci=trunk&name=test SELECT a FROM t1 WHERE rowid > 2147483648 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid > 2147483648 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid > 2147483648 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid > 2147483648 ORDER BY x ;SELECT a FROM t1 WHERE rowid >= 2147483648 ORDER BY a ;SELECT a FROM t1 WHERE rowid >= 2147483648 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid >= 2147483648 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid >= 2147483648 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid >= 2147483648 ORDER BY x ;SELECT a FROM t1 WHERE rowid < 2147483648 ORDER BY a ;SELECT a FROM t1 WHERE rowid < 2147483648 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid < 2147483648 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid < 2147483648 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid < 2147483648 ORDER BY x ;SELECT a FROM t1 WHERE rowid <= 2147483648 ORDER BY a ;SELECT a FROM t1 WHERE rowid <= 2147483648 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid <= 2147483648 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid <= 2147483648 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid <= 2147483648 ORDER BY x ;SELECT * FROM t1 WHERE rowid=549755813887 ;SELECT rowid, a FROM t1 WHERE x='0000007fffffffff' ;SELECT rowid, x FROM t1 WHERE a=46 ;SELECT a FROM t1 WHERE rowid > 549755813887 ORDER BY a ;SELECT a FROM t1 WHERE rowid > 549755813887 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid > 549755813887 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid > 549755813887 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid > 549755813887 ORDER BY x ;SELECT a FROM t1 WHERE rowid >= 549755813887 ORDER BY a ;SELECT a FROM t1 WHERE rowid >= 549755813887 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid >= 549755813887 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid >= 549755813887 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid >= 549755813887 ORDER BY x ;SELECT a FROM t1 WHERE rowid < 549755813887 ORDER BY a ;SELECT a FROM t1 WHERE rowid < 549755813887 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid < 549755813887 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid < 549755813887 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid < 549755813887 ORDER BY x ;SELECT a FROM t1 WHERE rowid <= 549755813887 ORDER BY a ;SELECT a FROM t1 WHERE rowid <= 549755813887 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid <= 549755813887 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid <= 549755813887 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid <= 549755813887 ORDER BY x ;SELECT * FROM t1 WHERE rowid=-549755813888 ;SELECT rowid, a FROM t1 WHERE x='ffffff8000000000' ;SELECT rowid, x FROM t1 WHERE a=63 ;SELECT a FROM t1 WHERE rowid > -549755813888 ORDER BY a ;SELECT a FROM t1 WHERE rowid > -549755813888 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid > -549755813888 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid > -549755813888 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid > -549755813888 ORDER BY x ;SELECT a FROM t1 WHERE rowid >= -549755813888 ORDER BY a ;SELECT a FROM t1 WHERE rowid >= -549755813888 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid >= -549755813888 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid >= -549755813888 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid >= -549755813888 ORDER BY x ;SELECT a FROM t1 WHERE rowid < -549755813888 ORDER BY a ;SELECT a FROM t1 WHERE rowid < -549755813888 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid < -549755813888 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid < -549755813888 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid < -549755813888 ORDER BY x ;SELECT a FROM t1 WHERE rowid <= -549755813888 ORDER BY a ;SELECT a FROM t1 WHERE rowid <= -549755813888 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid <= -549755813888 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid <= -549755813888 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid <= -549755813888 ORDER BY x ;SELECT * FROM t1 WHERE rowid=281474976710655 ;SELECT rowid, a FROM t1 WHERE x='0000ffffffffffff' ;SELECT rowid, x FROM t1 WHERE a=10 ;SELECT a FROM t1 WHERE rowid > 281474976710655 ORDER BY a ;SELECT a FROM t1 WHERE rowid > 281474976710655 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid > 281474976710655 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid > 281474976710655 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid > 281474976710655 ORDER BY x ;SELECT a FROM t1 WHERE rowid >= 281474976710655 ORDER BY a ;SELECT a FROM t1 WHERE rowid >= 281474976710655 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid >= 281474976710655 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid >= 281474976710655 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid >= 281474976710655 ORDER BY x ;SELECT a FROM t1 WHERE rowid < 281474976710655 ORDER BY a ;SELECT a FROM t1 WHERE rowid < 281474976710655 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid < 281474976710655 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid < 281474976710655 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid < 281474976710655 ORDER BY x ;SELECT a FROM t1 WHERE rowid <= 281474976710655 ORDER BY a ;SELECT a FROM t1 WHERE rowid <= 281474976710655 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid <= 281474976710655 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid <= 281474976710655 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid <= 281474976710655 ORDER BY x ;SELECT * FROM t1 WHERE rowid=4398046511103 ;SELECT rowid, a FROM t1 WHERE x='000003ffffffffff' ;SELECT rowid, x FROM t1 WHERE a=7 ;SELECT a FROM t1 WHERE rowid > 4398046511103 ORDER BY a ;SELECT a FROM t1 WHERE rowid > 4398046511103 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid > 4398046511103 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid > 4398046511103 ORDER BY rowid DESC ;SELECT a FROM t1 WHERE rowid > 4398046511103 ORDER BY x ;SELECT a FROM t1 WHERE rowid >= 4398046511103 ORDER BY a ;SELECT a FROM t1 WHERE rowid >= 4398046511103 ORDER BY a DESC ;SELECT a FROM t1 WHERE rowid >= 4398046511103 ORDER BY rowid ;SELECT a FROM t1 WHERE rowid >= 4398046511103 ORDER BY rowid DESC;