diff options
| author | Alexander Barkov <bar@mariadb.com> | 2018-09-20 16:51:56 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.com> | 2018-09-20 16:51:56 +0400 |
| commit | 935a163dd9242457fe56e73b2c2932230579aef5 (patch) | |
| tree | d2e9ce4e9aa8d62573675c46241cec9473889c64 /mysql-test/t/func_time.test | |
| parent | 0c6455aa4658790439a58956f05df200a5e380b8 (diff) | |
| download | mariadb-git-935a163dd9242457fe56e73b2c2932230579aef5.tar.gz | |
MDEV-17244 MAKETIME(900,0,0.111) returns a wrong result
Diffstat (limited to 'mysql-test/t/func_time.test')
| -rw-r--r-- | mysql-test/t/func_time.test | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/t/func_time.test b/mysql-test/t/func_time.test index 10b2b2958c2..4497a4d9668 100644 --- a/mysql-test/t/func_time.test +++ b/mysql-test/t/func_time.test @@ -1654,6 +1654,34 @@ INSERT INTO t1 VALUES (1e30),(-1e30); SELECT MAKETIME(a,0,0) FROM t1; DROP TABLE t1; +--echo # +--echo # MDEV-17244 MAKETIME(900,0,0.111) returns a wrong result +--echo # + +SELECT MAKETIME(900,0,0); +SELECT MAKETIME(900,0,0.1); +SELECT MAKETIME(900,0,0.11); +SELECT MAKETIME(900,0,0.111); +SELECT MAKETIME(900,0,0.1111); +SELECT MAKETIME(900,0,0.11111); +SELECT MAKETIME(900,0,0.111111); +SELECT MAKETIME(900,0,0.1111111); +SELECT MAKETIME(900,0,0.11111111); +SELECT MAKETIME(900,0,0.111111111); +SELECT MAKETIME(900,0,EXP(1)); + +SELECT MAKETIME(-900,0,0); +SELECT MAKETIME(-900,0,0.1); +SELECT MAKETIME(-900,0,0.11); +SELECT MAKETIME(-900,0,0.111); +SELECT MAKETIME(-900,0,0.1111); +SELECT MAKETIME(-900,0,0.11111); +SELECT MAKETIME(-900,0,0.111111); +SELECT MAKETIME(-900,0,0.1111111); +SELECT MAKETIME(-900,0,0.11111111); +SELECT MAKETIME(-900,0,0.111111111); +SELECT MAKETIME(-900,0,EXP(1)); + --echo # --echo # End of 5.5 tests |