diff options
Diffstat (limited to 'mysql-test/suite/engines/iuds/r/insert_number.result')
-rw-r--r-- | mysql-test/suite/engines/iuds/r/insert_number.result | 16 |
1 files changed, 0 insertions, 16 deletions
diff --git a/mysql-test/suite/engines/iuds/r/insert_number.result b/mysql-test/suite/engines/iuds/r/insert_number.result index 1355812649a..564ce8d3401 100644 --- a/mysql-test/suite/engines/iuds/r/insert_number.result +++ b/mysql-test/suite/engines/iuds/r/insert_number.result @@ -34324,12 +34324,8 @@ c1 c2 c3 c4 c5 c6 c7 0 -9223372036854775808 31 32 33 34 35 SELECT * FROM t3 WHERE c2 IN (-9223372036854775809,9223372036854775808) ORDER BY c2,c7; c1 c2 c3 c4 c5 c6 c7 -0 -9223372036854775808 1 2 3 4 5 -0 -9223372036854775808 31 32 33 34 35 SELECT * FROM t3 WHERE c2 IN (-9223372036854775809,9223372036854775808) ORDER BY c2,c7 LIMIT 2; c1 c2 c3 c4 c5 c6 c7 -0 -9223372036854775808 1 2 3 4 5 -0 -9223372036854775808 31 32 33 34 35 SELECT * FROM t3 WHERE c2 >= -9223372036854775809 AND c2 < 9223372036854775808 AND c7 = 35 ORDER BY c2,c7; c1 c2 c3 c4 c5 c6 c7 0 -9223372036854775808 31 32 33 34 35 @@ -34491,12 +34487,8 @@ c1 c2 c3 c4 c5 c6 c7 0 -9223372036854775808 1 2 3 4 5 SELECT * FROM t3 WHERE c2 IN (-9223372036854775809,9223372036854775808) ORDER BY c2,c7 DESC; c1 c2 c3 c4 c5 c6 c7 -0 -9223372036854775808 31 32 33 34 35 -0 -9223372036854775808 1 2 3 4 5 SELECT * FROM t3 WHERE c2 IN (-9223372036854775809,9223372036854775808) ORDER BY c2,c7 DESC LIMIT 2; c1 c2 c3 c4 c5 c6 c7 -0 -9223372036854775808 31 32 33 34 35 -0 -9223372036854775808 1 2 3 4 5 SELECT * FROM t3 WHERE c2 >= -9223372036854775809 AND c2 < 9223372036854775808 AND c7 = 35 ORDER BY c2,c7 DESC; c1 c2 c3 c4 c5 c6 c7 0 -9223372036854775808 31 32 33 34 35 @@ -34751,12 +34743,8 @@ c1 c2 c3 c4 c5 c6 c7 0 -9223372036854775808 31 32 33 34 35 SELECT * FROM t3 WHERE c2 IN (-9223372036854775809,9223372036854775808) ORDER BY c2,c7; c1 c2 c3 c4 c5 c6 c7 -0 -9223372036854775808 1 2 3 4 5 -0 -9223372036854775808 31 32 33 34 35 SELECT * FROM t3 WHERE c2 IN (-9223372036854775809,9223372036854775808) ORDER BY c2,c7 LIMIT 2; c1 c2 c3 c4 c5 c6 c7 -0 -9223372036854775808 1 2 3 4 5 -0 -9223372036854775808 31 32 33 34 35 SELECT * FROM t3 WHERE c2 >= -9223372036854775809 AND c2 < 9223372036854775808 AND c7 = 35 ORDER BY c2,c7; c1 c2 c3 c4 c5 c6 c7 0 -9223372036854775808 31 32 33 34 35 @@ -34918,12 +34906,8 @@ c1 c2 c3 c4 c5 c6 c7 0 -9223372036854775808 1 2 3 4 5 SELECT * FROM t3 WHERE c2 IN (-9223372036854775809,9223372036854775808) ORDER BY c2,c7 DESC; c1 c2 c3 c4 c5 c6 c7 -0 -9223372036854775808 31 32 33 34 35 -0 -9223372036854775808 1 2 3 4 5 SELECT * FROM t3 WHERE c2 IN (-9223372036854775809,9223372036854775808) ORDER BY c2,c7 DESC LIMIT 2; c1 c2 c3 c4 c5 c6 c7 -0 -9223372036854775808 31 32 33 34 35 -0 -9223372036854775808 1 2 3 4 5 SELECT * FROM t3 WHERE c2 >= -9223372036854775809 AND c2 < 9223372036854775808 AND c7 = 35 ORDER BY c2,c7 DESC; c1 c2 c3 c4 c5 c6 c7 0 -9223372036854775808 31 32 33 34 35 |