diff options
| author | Alexander Barkov <bar@mnogosearch.org> | 2013-09-16 13:03:49 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mnogosearch.org> | 2013-09-16 13:03:49 +0400 |
| commit | 6c9d98328716795bc9ce04d7c3e013de345ee784 (patch) | |
| tree | 1d04ddfb2b06dfc23006fde5ca2d4266367b8f14 | |
| parent | 5d7b97b89ec2073bd8dffead6adb895cf1b15adc (diff) | |
| download | mariadb-git-6c9d98328716795bc9ce04d7c3e013de345ee784.tar.gz | |
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
| -rw-r--r-- | mysql-test/r/func_time.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/func_time.test | 6 |
2 files changed, 12 insertions, 0 deletions
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); + |