diff options
author | Vicențiu Ciorbaru <vicentiu@mariadb.org> | 2018-03-15 03:45:28 +0200 |
---|---|---|
committer | Vicențiu Ciorbaru <vicentiu@mariadb.org> | 2018-03-15 03:45:28 +0200 |
commit | 8152c52e1af608da5d288a4e6fc82e2d804e64cd (patch) | |
tree | 8ff56cdb8c9766b04b015f0c5c896a202122abb1 /mysql-test/t/func_time.test | |
parent | 782fb1e016e0342074ca9938e412a14d20d6f793 (diff) | |
parent | 3d5dff6cae5cdefe376583f811c9af109ea08080 (diff) | |
download | mariadb-git-8152c52e1af608da5d288a4e6fc82e2d804e64cd.tar.gz |
Merge remote-tracking branch '10.0' into 10.1
Diffstat (limited to 'mysql-test/t/func_time.test')
-rw-r--r-- | mysql-test/t/func_time.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/func_time.test b/mysql-test/t/func_time.test index bc553e6f049..38082213004 100644 --- a/mysql-test/t/func_time.test +++ b/mysql-test/t/func_time.test @@ -1762,6 +1762,22 @@ SELECT ADDDATE(DATE'0000-01-01', INTERVAL '3652423:0:0:315569433559' DAY_SECOND) SELECT ADDDATE(DATE'0000-01-01', INTERVAL '0:87658175:0:315569433559' DAY_SECOND); SELECT ADDDATE(DATE'0000-01-01', INTERVAL '0:0:5259490559:315569433599' DAY_SECOND); +--echo # +--echo # MDEV-13202 Assertion `ltime->neg == 0' failed in date_to_datetime +--echo # + +CREATE TABLE t1 (i INT, d DATE); +INSERT INTO t1 VALUES (1, '1970-01-01'); +SELECT MAX(NULLIF(i,1)) FROM t1 ORDER BY DATE_SUB(d,INTERVAL 17300000 HOUR); +DROP TABLE t1; + +CREATE TABLE t1 (i INT, d DATE); +INSERT INTO t1 VALUES (1, '1970-01-01'); +SELECT CONCAT(DATE_SUB(d, INTERVAL 17300000 HOUR)) FROM t1; +DROP TABLE t1; + +SELECT CONCAT(DATE_SUB(TIMESTAMP'1970-01-01 00:00:00', INTERVAL 17300000 HOUR)); + --echo # --echo # End of 10.0 tests |