diff options
Diffstat (limited to 'mysql-test/r/range.result')
| -rw-r--r-- | mysql-test/r/range.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/range.result b/mysql-test/r/range.result index e66a3de0049..4ca96316800 100644 --- a/mysql-test/r/range.result +++ b/mysql-test/r/range.result @@ -500,6 +500,9 @@ count(*) select count(*) from t1 where x > -16; count(*) 2 +select count(*) from t1 where x = 18446744073709551601; +count(*) +1 create table t2 (x bigint not null); insert into t2(x) values (0xfffffffffffffff0); insert into t2(x) values (0xfffffffffffffff1); @@ -525,6 +528,9 @@ count(*) select count(*) from t2 where x > -16; count(*) 1 +select count(*) from t2 where x = 18446744073709551601; +count(*) +0 drop table t1; create table t1 (x bigint unsigned not null primary key) engine=innodb; insert into t1(x) values (0xfffffffffffffff0); @@ -551,4 +557,7 @@ count(*) select count(*) from t1 where x > -16; count(*) 1 +select count(*) from t1 where x = 18446744073709551601; +count(*) +1 drop table t1; |