diff options
| -rw-r--r-- | mysql-test/r/innodb.result | 5 | ||||
| -rw-r--r-- | mysql-test/r/range.result | 2 |
2 files changed, 4 insertions, 3 deletions
diff --git a/mysql-test/r/innodb.result b/mysql-test/r/innodb.result index b07a6b03c8a..838e02c3a89 100644 --- a/mysql-test/r/innodb.result +++ b/mysql-test/r/innodb.result @@ -1721,12 +1721,13 @@ count(*) 0 explain select count(*) from t1 where x > -16; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range PRIMARY PRIMARY 8 NULL 1 Using where; Using index +1 SIMPLE t1 index PRIMARY PRIMARY 8 NULL 2 Using where; Using index select count(*) from t1 where x > -16; count(*) -1 +2 select * from t1 where x > -16; x +18446744073709551600 18446744073709551601 select count(*) from t1 where x = 18446744073709551601; count(*) diff --git a/mysql-test/r/range.result b/mysql-test/r/range.result index 16bf9a8247a..ae7d0474e24 100644 --- a/mysql-test/r/range.result +++ b/mysql-test/r/range.result @@ -544,7 +544,7 @@ count(*) 1 select count(*) from t2 where x > -16; count(*) -2 +1 select count(*) from t2 where x = 18446744073709551601; count(*) 0 |