diff options
| author | Alexander Barkov <bar@mariadb.org> | 2014-07-23 14:59:23 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2014-07-23 14:59:23 +0400 |
| commit | 07cb53c58b87f1b6bc54df6f49125d9686ddcf9b (patch) | |
| tree | 5be57ede7d760f424f7ecbc9f7be2c0830b045ed /mysql-test/r/func_time.result | |
| parent | be00265557410cdf273a5992b46cf62ce06ebbd3 (diff) | |
| parent | 80708da138913deb3a096da0e761ff247766bf96 (diff) | |
| download | mariadb-git-07cb53c58b87f1b6bc54df6f49125d9686ddcf9b.tar.gz | |
Merge 5.3->5.5
Diffstat (limited to 'mysql-test/r/func_time.result')
| -rw-r--r-- | mysql-test/r/func_time.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/func_time.result b/mysql-test/r/func_time.result index f71b27d1a2a..995b5f702e2 100644 --- a/mysql-test/r/func_time.result +++ b/mysql-test/r/func_time.result @@ -2416,3 +2416,18 @@ c1 c2 9923-03-10 22:47:10.0 NULL Warnings: Warning 1292 Truncated incorrect DECIMAL value: '2000000000000000000.0' +# +# MDEV-5750 Assertion `ltime->year == 0' fails on a query with EXTRACT DAY_MINUTE and TIME column +# +CREATE TABLE t1 ( d DATE, t TIME ); +INSERT INTO t1 VALUES ('2008-12-05','22:34:09'),('2005-03-27','14:26:02'); +SELECT EXTRACT(DAY_MINUTE FROM GREATEST(t,d)), GREATEST(t,d) FROM t1; +EXTRACT(DAY_MINUTE FROM GREATEST(t,d)) GREATEST(t,d) +342259 838:59:59 +342259 838:59:59 +Warnings: +Warning 1292 Truncated incorrect time value: '9336:00:00' +Warning 1292 Truncated incorrect time value: '9336:00:00' +Warning 1292 Truncated incorrect time value: '2952:00:00' +Warning 1292 Truncated incorrect time value: '2952:00:00' +DROP TABLE t1; |