diff options
| author | Alexander Barkov <bar@mnogosearch.org> | 2013-12-19 12:39:40 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mnogosearch.org> | 2013-12-19 12:39:40 +0400 |
| commit | 06ebc6cc503ddd573165574775607cb23aa1143e (patch) | |
| tree | 480c0d58721c898a87a678167864ee8554e63f00 /mysql-test/r/func_time.result | |
| parent | ece71fafd61940d32c21e7a6ed179e0a29803ec0 (diff) | |
| download | mariadb-git-06ebc6cc503ddd573165574775607cb23aa1143e.tar.gz | |
MDEV-4838 Wrong metadata for DATE_ADD('string', INVERVAL)
The problem seems to be fixed by some earlier change
and is not reproducible any longer. Only adding a test case.
Diffstat (limited to 'mysql-test/r/func_time.result')
| -rw-r--r-- | mysql-test/r/func_time.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/func_time.result b/mysql-test/r/func_time.result index 4bd11aa2fc4..5b8c09cb32e 100644 --- a/mysql-test/r/func_time.result +++ b/mysql-test/r/func_time.result @@ -2374,3 +2374,11 @@ EXTRACT(HOUR FROM TIME('1 02:00:00')) EXTRACT(HOUR FROM TIME('26:00:00')) SELECT EXTRACT(DAY FROM TIME('1 02:00:00')), EXTRACT(DAY FROM TIME('26:00:00')); EXTRACT(DAY FROM TIME('1 02:00:00')) EXTRACT(DAY FROM TIME('26:00:00')) 1 1 +# +# MDEV-4838 Wrong metadata for DATE_ADD('string', INVERVAL) +# +SELECT DATE_ADD('2011-01-02 12:13:14', INTERVAL 1 MINUTE); +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def DATE_ADD('2011-01-02 12:13:14', INTERVAL 1 MINUTE) 254 19 19 Y 0 0 8 +DATE_ADD('2011-01-02 12:13:14', INTERVAL 1 MINUTE) +2011-01-02 12:14:14 |