diff options
| author | Alexander Barkov <bar@mariadb.org> | 2015-09-23 20:42:28 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2015-09-23 20:42:28 +0400 |
| commit | 3ad035f66b74284f515b2786f7d4553dba5c14a2 (patch) | |
| tree | 4112fdc64b1dd77aa31389e6a92e0bda7cbaba49 /mysql-test/t/type_date.test | |
| parent | b9da3ba45e6a6bad152203f56af47abe79e550ad (diff) | |
| download | mariadb-git-3ad035f66b74284f515b2786f7d4553dba5c14a2.tar.gz | |
MDEV-8658 DATE(zerofill_column) and DATE(COALESCE(zerofill_column)) return different results
MDEV-8660 TIME(int_zerofill_column) returns a wrong result
Diffstat (limited to 'mysql-test/t/type_date.test')
| -rw-r--r-- | mysql-test/t/type_date.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/type_date.test b/mysql-test/t/type_date.test index 56036c4c7ba..34437df2f2c 100644 --- a/mysql-test/t/type_date.test +++ b/mysql-test/t/type_date.test @@ -539,6 +539,22 @@ INSERT INTO t1 VALUES ('2001-01-01'),('2001-01-02'); EXPLAIN EXTENDED SELECT * FROM t1 WHERE COALESCE(a)=DATE'2001-01-01' AND COALESCE(a)>=DATE'2001-01-01'; DROP TABLE t1; +--echo # +--echo # MDEV-8658 DATE(zerofill_column) and DATE(COALESCE(zerofill_column)) return different results +--echo # +CREATE TABLE t1 (a INT(6) ZEROFILL, b DECIMAL(6) ZEROFILL, c DOUBLE(6,0) ZEROFILL); +INSERT INTO t1 VALUES (1,1,1); +INSERT INTO t1 VALUES (10101,10101,10101); +SELECT DATE(a), DATE(b), DATE(c) FROM t1; +SELECT DATE(COALESCE(a)), DATE(COALESCE(b)), DATE(COALESCE(c)) FROM t1; +DROP TABLE t1; +CREATE TABLE t1 (a INT(6), b DECIMAL(6), c DOUBLE(6,0)); +INSERT INTO t1 VALUES (1,1,1); +INSERT INTO t1 VALUES (10101,10101,10101); +SELECT DATE(a), DATE(b), DATE(c) FROM t1; +SELECT DATE(COALESCE(a)), DATE(COALESCE(b)), DATE(COALESCE(c)) FROM t1; +DROP TABLE t1; + --echo # --echo # End of 10.1 tests |