From 6c9d98328716795bc9ce04d7c3e013de345ee784 Mon Sep 17 00:00:00 2001 From: Alexander Barkov Date: Mon, 16 Sep 2013 13:03:49 +0400 Subject: MDEV-4869 Wrong result of MAKETIME(0, 0, -0.1) Adding a test case only. The problem was fixed by: MDEV-4724 Some temporal functions do not preserve microseconds modified: mysql-test/r/func_time.result mysql-test/t/func_time.test --- mysql-test/r/func_time.result | 6 ++++++ mysql-test/t/func_time.test | 6 ++++++ 2 files changed, 12 insertions(+) diff --git a/mysql-test/r/func_time.result b/mysql-test/r/func_time.result index c85002d93f0..eec9a4e7ea3 100644 --- a/mysql-test/r/func_time.result +++ b/mysql-test/r/func_time.result @@ -2241,3 +2241,9 @@ SELECT * FROM t1; TIMESTAMP('00:00:00','10:10:10') TIMESTAMP(TIME('00:00:00'),'10:10:10') NULL NULL DROP TABLE t1; +# +# MDEV-4869 Wrong result of MAKETIME(0, 0, -0.1) +# +SELECT MAKETIME(0, 0, -0.1); +MAKETIME(0, 0, -0.1) +NULL diff --git a/mysql-test/t/func_time.test b/mysql-test/t/func_time.test index 4a3d74317c4..87be964cd7e 100644 --- a/mysql-test/t/func_time.test +++ b/mysql-test/t/func_time.test @@ -1357,3 +1357,9 @@ CREATE TABLE t1 AS SELECT SHOW COLUMNS FROM t1; SELECT * FROM t1; DROP TABLE t1; + +--echo # +--echo # MDEV-4869 Wrong result of MAKETIME(0, 0, -0.1) +--echo # +SELECT MAKETIME(0, 0, -0.1); + -- cgit v1.2.1