diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2018-11-15 17:20:26 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2018-11-15 17:20:26 +0100 |
| commit | a77f80b79eab4f7d9740086425fbf8d1f684e11b (patch) | |
| tree | ef732b9ff7ec67034ef87609cd7bc43575b080da /mysql-test/t | |
| parent | 9e23171c70b57c2af40a976fcd62bdbac6b26349 (diff) | |
| parent | a84d87fde8c0bc325c8e00f06ea02bcd84a75d55 (diff) | |
| download | mariadb-git-a77f80b79eab4f7d9740086425fbf8d1f684e11b.tar.gz | |
Merge branch '10.0' into 10.1
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/bigint.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/bigint.test b/mysql-test/t/bigint.test index fb18d60edd9..71fef813a8d 100644 --- a/mysql-test/t/bigint.test +++ b/mysql-test/t/bigint.test @@ -414,3 +414,12 @@ DROP TABLE t1; --echo # MDEV-9372 select 100 between 1 and 9223372036854775808 returns false --echo # SELECT 100 BETWEEN 1 AND 9223372036854775808; + +--echo # +--echo # MDEV-17724 Wrong result for BETWEEN 0 AND 18446744073709551615 +--echo # + +CREATE TABLE t1 (c1 bigint(20) unsigned NOT NULL); +INSERT INTO t1 VALUES (0),(101),(255); +SELECT * FROM t1 WHERE c1 BETWEEN 0 AND 18446744073709551615 ORDER BY c1; +DROP TABLE t1; |