-- original: boundary2.test -- credit: http://www.sqlite.org/src/tree?ci=trunk&name=test SELECT a FROM t1 WHERE r <= -32768 ORDER BY a DESC ;SELECT a FROM t1 WHERE r <= -32768 ORDER BY r ;SELECT a FROM t1 WHERE r <= -32768 ORDER BY r DESC ;SELECT a FROM t1 WHERE r <= -32768 ORDER BY x ;SELECT * FROM t1 WHERE r=2147483647 ;SELECT r, a FROM t1 WHERE x='000000007fffffff' ;SELECT r, x FROM t1 WHERE a=20 ;SELECT a FROM t1 WHERE r > 2147483647 ORDER BY a ;SELECT a FROM t1 WHERE r > 2147483647 ORDER BY a DESC ;SELECT a FROM t1 WHERE r > 2147483647 ORDER BY r ;SELECT a FROM t1 WHERE r > 2147483647 ORDER BY r DESC ;SELECT a FROM t1 WHERE r > 2147483647 ORDER BY x ;SELECT a FROM t1 WHERE r >= 2147483647 ORDER BY a ;SELECT a FROM t1 WHERE r >= 2147483647 ORDER BY a DESC ;SELECT a FROM t1 WHERE r >= 2147483647 ORDER BY r ;SELECT a FROM t1 WHERE r >= 2147483647 ORDER BY r DESC ;SELECT a FROM t1 WHERE r >= 2147483647 ORDER BY x ;SELECT a FROM t1 WHERE r < 2147483647 ORDER BY a ;SELECT a FROM t1 WHERE r < 2147483647 ORDER BY a DESC ;SELECT a FROM t1 WHERE r < 2147483647 ORDER BY r ;SELECT a FROM t1 WHERE r < 2147483647 ORDER BY r DESC ;SELECT a FROM t1 WHERE r < 2147483647 ORDER BY x ;SELECT a FROM t1 WHERE r <= 2147483647 ORDER BY a ;SELECT a FROM t1 WHERE r <= 2147483647 ORDER BY a DESC ;SELECT a FROM t1 WHERE r <= 2147483647 ORDER BY r ;SELECT a FROM t1 WHERE r <= 2147483647 ORDER BY r DESC ;SELECT a FROM t1 WHERE r <= 2147483647 ORDER BY x ;SELECT * FROM t1 WHERE r=-129 ;SELECT r, a FROM t1 WHERE x='ffffffffffffff7f' ;SELECT r, x FROM t1 WHERE a=54 ;SELECT a FROM t1 WHERE r > -129 ORDER BY a ;SELECT a FROM t1 WHERE r > -129 ORDER BY a DESC ;SELECT a FROM t1 WHERE r > -129 ORDER BY r ;SELECT a FROM t1 WHERE r > -129 ORDER BY r DESC ;SELECT a FROM t1 WHERE r > -129 ORDER BY x ;SELECT a FROM t1 WHERE r >= -129 ORDER BY a ;SELECT a FROM t1 WHERE r >= -129 ORDER BY a DESC ;SELECT a FROM t1 WHERE r >= -129 ORDER BY r ;SELECT a FROM t1 WHERE r >= -129 ORDER BY r DESC ;SELECT a FROM t1 WHERE r >= -129 ORDER BY x ;SELECT a FROM t1 WHERE r < -129 ORDER BY a ;SELECT a FROM t1 WHERE r < -129 ORDER BY a DESC ;SELECT a FROM t1 WHERE r < -129 ORDER BY r ;SELECT a FROM t1 WHERE r < -129 ORDER BY r DESC ;SELECT a FROM t1 WHERE r < -129 ORDER BY x ;SELECT a FROM t1 WHERE r <= -129 ORDER BY a ;SELECT a FROM t1 WHERE r <= -129 ORDER BY a DESC ;SELECT a FROM t1 WHERE r <= -129 ORDER BY r ;SELECT a FROM t1 WHERE r <= -129 ORDER BY r DESC ;SELECT a FROM t1 WHERE r <= -129 ORDER BY x ;SELECT * FROM t1 WHERE r=-128 ;SELECT r, a FROM t1 WHERE x='ffffffffffffff80' ;SELECT r, x FROM t1 WHERE a=53 ;SELECT a FROM t1 WHERE r > -128 ORDER BY a ;SELECT a FROM t1 WHERE r > -128 ORDER BY a DESC ;SELECT a FROM t1 WHERE r > -128 ORDER BY r ;SELECT a FROM t1 WHERE r > -128 ORDER BY r DESC ;SELECT a FROM t1 WHERE r > -128 ORDER BY x ;SELECT a FROM t1 WHERE r >= -128 ORDER BY a ;SELECT a FROM t1 WHERE r >= -128 ORDER BY a DESC ;SELECT a FROM t1 WHERE r >= -128 ORDER BY r ;SELECT a FROM t1 WHERE r >= -128 ORDER BY r DESC ;SELECT a FROM t1 WHERE r >= -128 ORDER BY x ;SELECT a FROM t1 WHERE r < -128 ORDER BY a ;SELECT a FROM t1 WHERE r < -128 ORDER BY a DESC ;SELECT a FROM t1 WHERE r < -128 ORDER BY r ;SELECT a FROM t1 WHERE r < -128 ORDER BY r DESC ;SELECT a FROM t1 WHERE r < -128 ORDER BY x ;SELECT a FROM t1 WHERE r <= -128 ORDER BY a ;SELECT a FROM t1 WHERE r <= -128 ORDER BY a DESC ;SELECT a FROM t1 WHERE r <= -128 ORDER BY r ;SELECT a FROM t1 WHERE r <= -128 ORDER BY r DESC ;SELECT a FROM t1 WHERE r <= -128 ORDER BY x ;SELECT * FROM t1 WHERE r=72057594037927936 ;SELECT r, a FROM t1 WHERE x='0100000000000000' ;SELECT r, x FROM t1 WHERE a=28 ;SELECT a FROM t1 WHERE r > 72057594037927936 ORDER BY a ;SELECT a FROM t1 WHERE r > 72057594037927936 ORDER BY a DESC ;SELECT a FROM t1 WHERE r > 72057594037927936 ORDER BY r ;SELECT a FROM t1 WHERE r > 72057594037927936 ORDER BY r DESC ;SELECT a FROM t1 WHERE r > 72057594037927936 ORDER BY x ;SELECT a FROM t1 WHERE r >= 72057594037927936 ORDER BY a ;SELECT a FROM t1 WHERE r >= 72057594037927936 ORDER BY a DESC ;SELECT a FROM t1 WHERE r >= 72057594037927936 ORDER BY r ;SELECT a FROM t1 WHERE r >= 72057594037927936 ORDER BY r DESC ;SELECT a FROM t1 WHERE r >= 72057594037927936 ORDER BY x ;SELECT a FROM t1 WHERE r < 72057594037927936 ORDER BY a ;SELECT a FROM t1 WHERE r < 72057594037927936 ORDER BY a DESC ;SELECT a FROM t1 WHERE r < 72057594037927936 ORDER BY r ;SELECT a FROM t1 WHERE r < 72057594037927936 ORDER BY r DESC ;SELECT a FROM t1 WHERE r < 72057594037927936 ORDER BY x ;SELECT a FROM t1 WHERE r <= 72057594037927936 ORDER BY a ;SELECT a FROM t1 WHERE r <= 72057594037927936 ORDER BY a DESC ;SELECT a FROM t1 WHERE r <= 72057594037927936 ORDER BY r ;SELECT a FROM t1 WHERE r <= 72057594037927936 ORDER BY r DESC ;SELECT a FROM t1 WHERE r <= 72057594037927936 ORDER BY x ;SELECT * FROM t1 WHERE r=2147483648 ;SELECT r, a FROM t1 WHERE x='0000000080000000' ;SELECT r, x FROM t1 WHERE a=51 ;SELECT a FROM t1 WHERE r > 2147483648 ORDER BY a;