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/r/bigint.result | |
| 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/r/bigint.result')
| -rw-r--r-- | mysql-test/r/bigint.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/bigint.result b/mysql-test/r/bigint.result index 505d655b6bb..b06ec5805a0 100644 --- a/mysql-test/r/bigint.result +++ b/mysql-test/r/bigint.result @@ -502,3 +502,9 @@ a SELECT * FROM t1 WHERE a IN (0.8,0.9); a DROP TABLE t1; +# +# MDEV-9372 select 100 between 1 and 9223372036854775808 returns false +# +SELECT 100 BETWEEN 1 AND 9223372036854775808; +100 BETWEEN 1 AND 9223372036854775808 +1 |