diff options
| author | Alexander Barkov <bar@mariadb.org> | 2016-04-22 16:04:20 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2016-04-22 16:04:20 +0400 |
| commit | 3f0d07e55b0a2ab8c7bdc1209d55ec2f66542830 (patch) | |
| tree | c4ca33dd7d12bef5a7060901128a0e4be0fb94fc /mysql-test/t/bigint.test | |
| parent | 0991e19e9d38f7475390276c0557c2390e4d93c9 (diff) | |
| download | mariadb-git-3f0d07e55b0a2ab8c7bdc1209d55ec2f66542830.tar.gz | |
MDEV-9372 select 100 between 1 and 9223372036854775808 returns false
Integer comparison of INT expressions with different signess in BETWEEN
is not safe. Switching to DECIMAL comparison in case if INT arguments
have different signess.
Diffstat (limited to 'mysql-test/t/bigint.test')
| -rw-r--r-- | mysql-test/t/bigint.test | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/t/bigint.test b/mysql-test/t/bigint.test index 41f33b8a7f2..fb18d60edd9 100644 --- a/mysql-test/t/bigint.test +++ b/mysql-test/t/bigint.test @@ -409,3 +409,8 @@ SELECT * FROM t1 WHERE a=0.9; SELECT * FROM t1 WHERE a IN (0.8,0.9); DROP TABLE t1; + +--echo # +--echo # MDEV-9372 select 100 between 1 and 9223372036854775808 returns false +--echo # +SELECT 100 BETWEEN 1 AND 9223372036854775808; |