diff options
| author | Alexander Barkov <bar@mariadb.org> | 2015-09-28 19:12:05 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2015-09-28 19:12:05 +0400 |
| commit | a4e5902039db10e5661c8475790aff84e67dff09 (patch) | |
| tree | 2063a20346d230ec526aa17dd07b33cb010f0ff4 /mysql-test | |
| parent | c5922c5701e68bf6d1d2efa974bb21b1af53fa47 (diff) | |
| download | mariadb-git-a4e5902039db10e5661c8475790aff84e67dff09.tar.gz | |
MDEV-8862 Wrong field type for MAX(COALESCE(datetime_column))
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/type_time.result | 9 | ||||
| -rw-r--r-- | mysql-test/t/type_time.test | 8 |
2 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/type_time.result b/mysql-test/r/type_time.result index 59de00fa416..bdcffc8d824 100644 --- a/mysql-test/r/type_time.result +++ b/mysql-test/r/type_time.result @@ -1206,5 +1206,14 @@ Warning 1292 Incorrect time value: '9000000' for column 'b' at row 4 Warning 1292 Incorrect time value: '9000000' for column 'c' at row 4 DROP TABLE t1; # +# MDEV-8862 Wrong field type for MAX(COALESCE(datetime_column)) +# +CREATE TABLE t1 (a TIME); +INSERT INTO t1 VALUES ('10:10:10'),('10:20:30'); +SELECT MAX(a), MAX(COALESCE(a)) FROM t1; +MAX(a) MAX(COALESCE(a)) +10:20:30 10:20:30 +DROP TABLE t1; +# # End of 10.1 tests # diff --git a/mysql-test/t/type_time.test b/mysql-test/t/type_time.test index b257aa4f455..27679b9ec5a 100644 --- a/mysql-test/t/type_time.test +++ b/mysql-test/t/type_time.test @@ -716,5 +716,13 @@ SELECT a, TIME(a),TIME(b),TIME(c) FROM t1 ORDER BY a; DROP TABLE t1; --echo # +--echo # MDEV-8862 Wrong field type for MAX(COALESCE(datetime_column)) +--echo # +CREATE TABLE t1 (a TIME); +INSERT INTO t1 VALUES ('10:10:10'),('10:20:30'); +SELECT MAX(a), MAX(COALESCE(a)) FROM t1; +DROP TABLE t1; + +--echo # --echo # End of 10.1 tests --echo # |