diff options
| author | unknown <sergefp@mysql.com> | 2004-08-17 02:59:24 +0400 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2004-08-17 02:59:24 +0400 |
| commit | 5a7dd14edf990e6b23312ad305a92d05874be04c (patch) | |
| tree | c15d08efcfe7345961ad895b97c4a32a10069dda /mysql-test/r/range.result | |
| parent | b37a73611024d78de35145c5f6cb394a7c3f225c (diff) | |
| download | mariadb-git-5a7dd14edf990e6b23312ad305a92d05874be04c.tar.gz | |
Fix for bug#4488: sign-aware equality check
mysql-test/r/range.result:
Fix for bug#4488: more tests
mysql-test/t/range.test:
Fix for bug#4488: more tests
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; |