-- original: boundary2.test -- credit: http://www.sqlite.org/src/tree?ci=trunk&name=test SELECT a FROM t1 WHERE r < 127 ORDER BY a ;SELECT a FROM t1 WHERE r < 127 ORDER BY a DESC ;SELECT a FROM t1 WHERE r < 127 ORDER BY r ;SELECT a FROM t1 WHERE r < 127 ORDER BY r DESC ;SELECT a FROM t1 WHERE r < 127 ORDER BY x ;SELECT a FROM t1 WHERE r <= 127 ORDER BY a ;SELECT a FROM t1 WHERE r <= 127 ORDER BY a DESC ;SELECT a FROM t1 WHERE r <= 127 ORDER BY r ;SELECT a FROM t1 WHERE r <= 127 ORDER BY r DESC ;SELECT a FROM t1 WHERE r <= 127 ORDER BY x ;SELECT * FROM t1 WHERE r=36028797018963967 ;SELECT r, a FROM t1 WHERE x='007fffffffffffff' ;SELECT r, x FROM t1 WHERE a=27 ;SELECT a FROM t1 WHERE r > 36028797018963967 ORDER BY a ;SELECT a FROM t1 WHERE r > 36028797018963967 ORDER BY a DESC ;SELECT a FROM t1 WHERE r > 36028797018963967 ORDER BY r ;SELECT a FROM t1 WHERE r > 36028797018963967 ORDER BY r DESC ;SELECT a FROM t1 WHERE r > 36028797018963967 ORDER BY x ;SELECT a FROM t1 WHERE r >= 36028797018963967 ORDER BY a ;SELECT a FROM t1 WHERE r >= 36028797018963967 ORDER BY a DESC ;SELECT a FROM t1 WHERE r >= 36028797018963967 ORDER BY r ;SELECT a FROM t1 WHERE r >= 36028797018963967 ORDER BY r DESC ;SELECT a FROM t1 WHERE r >= 36028797018963967 ORDER BY x ;SELECT a FROM t1 WHERE r < 36028797018963967 ORDER BY a ;SELECT a FROM t1 WHERE r < 36028797018963967 ORDER BY a DESC ;SELECT a FROM t1 WHERE r < 36028797018963967 ORDER BY r ;SELECT a FROM t1 WHERE r < 36028797018963967 ORDER BY r DESC ;SELECT a FROM t1 WHERE r < 36028797018963967 ORDER BY x ;SELECT a FROM t1 WHERE r <= 36028797018963967 ORDER BY a ;SELECT a FROM t1 WHERE r <= 36028797018963967 ORDER BY a DESC ;SELECT a FROM t1 WHERE r <= 36028797018963967 ORDER BY r ;SELECT a FROM t1 WHERE r <= 36028797018963967 ORDER BY r DESC ;SELECT a FROM t1 WHERE r <= 36028797018963967 ORDER BY x ;SELECT * FROM t1 WHERE r=4398046511104 ;SELECT r, a FROM t1 WHERE x='0000040000000000' ;SELECT r, x FROM t1 WHERE a=56 ;SELECT a FROM t1 WHERE r > 4398046511104 ORDER BY a ;SELECT a FROM t1 WHERE r > 4398046511104 ORDER BY a DESC ;SELECT a FROM t1 WHERE r > 4398046511104 ORDER BY r ;SELECT a FROM t1 WHERE r > 4398046511104 ORDER BY r DESC ;SELECT a FROM t1 WHERE r > 4398046511104 ORDER BY x ;SELECT a FROM t1 WHERE r >= 4398046511104 ORDER BY a ;SELECT a FROM t1 WHERE r >= 4398046511104 ORDER BY a DESC ;SELECT a FROM t1 WHERE r >= 4398046511104 ORDER BY r ;SELECT a FROM t1 WHERE r >= 4398046511104 ORDER BY r DESC ;SELECT a FROM t1 WHERE r >= 4398046511104 ORDER BY x ;SELECT a FROM t1 WHERE r < 4398046511104 ORDER BY a ;SELECT a FROM t1 WHERE r < 4398046511104 ORDER BY a DESC ;SELECT a FROM t1 WHERE r < 4398046511104 ORDER BY r ;SELECT a FROM t1 WHERE r < 4398046511104 ORDER BY r DESC ;SELECT a FROM t1 WHERE r < 4398046511104 ORDER BY x ;SELECT a FROM t1 WHERE r <= 4398046511104 ORDER BY a ;SELECT a FROM t1 WHERE r <= 4398046511104 ORDER BY a DESC ;SELECT a FROM t1 WHERE r <= 4398046511104 ORDER BY r ;SELECT a FROM t1 WHERE r <= 4398046511104 ORDER BY r DESC ;SELECT a FROM t1 WHERE r <= 4398046511104 ORDER BY x ;SELECT * FROM t1 WHERE r=1 ;SELECT r, a FROM t1 WHERE x='0000000000000001' ;SELECT r, x FROM t1 WHERE a=60 ;SELECT a FROM t1 WHERE r > 1 ORDER BY a ;SELECT a FROM t1 WHERE r > 1 ORDER BY a DESC ;SELECT a FROM t1 WHERE r > 1 ORDER BY r ;SELECT a FROM t1 WHERE r > 1 ORDER BY r DESC ;SELECT a FROM t1 WHERE r > 1 ORDER BY x ;SELECT a FROM t1 WHERE r >= 1 ORDER BY a ;SELECT a FROM t1 WHERE r >= 1 ORDER BY a DESC ;SELECT a FROM t1 WHERE r >= 1 ORDER BY r ;SELECT a FROM t1 WHERE r >= 1 ORDER BY r DESC ;SELECT a FROM t1 WHERE r >= 1 ORDER BY x ;SELECT a FROM t1 WHERE r < 1 ORDER BY a ;SELECT a FROM t1 WHERE r < 1 ORDER BY a DESC ;SELECT a FROM t1 WHERE r < 1 ORDER BY r ;SELECT a FROM t1 WHERE r < 1 ORDER BY r DESC ;SELECT a FROM t1 WHERE r < 1 ORDER BY x ;SELECT a FROM t1 WHERE r <= 1 ORDER BY a ;SELECT a FROM t1 WHERE r <= 1 ORDER BY a DESC ;SELECT a FROM t1 WHERE r <= 1 ORDER BY r ;SELECT a FROM t1 WHERE r <= 1 ORDER BY r DESC ;SELECT a FROM t1 WHERE r <= 1 ORDER BY x ;SELECT * FROM t1 WHERE r=36028797018963968 ;SELECT r, a FROM t1 WHERE x='0080000000000000' ;SELECT r, x FROM t1 WHERE a=45 ;SELECT a FROM t1 WHERE r > 36028797018963968 ORDER BY a ;SELECT a FROM t1 WHERE r > 36028797018963968 ORDER BY a DESC ;SELECT a FROM t1 WHERE r > 36028797018963968 ORDER BY r ;SELECT a FROM t1 WHERE r > 36028797018963968 ORDER BY r DESC ;SELECT a FROM t1 WHERE r > 36028797018963968 ORDER BY x ;SELECT a FROM t1 WHERE r >= 36028797018963968 ORDER BY a ;SELECT a FROM t1 WHERE r >= 36028797018963968 ORDER BY a DESC ;SELECT a FROM t1 WHERE r >= 36028797018963968 ORDER BY r ;SELECT a FROM t1 WHERE r >= 36028797018963968 ORDER BY r DESC ;SELECT a FROM t1 WHERE r >= 36028797018963968 ORDER BY x ;SELECT a FROM t1 WHERE r < 36028797018963968 ORDER BY a ;SELECT a FROM t1 WHERE r < 36028797018963968 ORDER BY a DESC ;SELECT a FROM t1 WHERE r < 36028797018963968 ORDER BY r ;SELECT a FROM t1 WHERE r < 36028797018963968 ORDER BY r DESC ;SELECT a FROM t1 WHERE r < 36028797018963968 ORDER BY x ;SELECT a FROM t1 WHERE r <= 36028797018963968 ORDER BY a ;SELECT a FROM t1 WHERE r <= 36028797018963968 ORDER BY a DESC ;SELECT a FROM t1 WHERE r <= 36028797018963968 ORDER BY r;