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/r | |
parent | c5922c5701e68bf6d1d2efa974bb21b1af53fa47 (diff) | |
download | mariadb-git-a4e5902039db10e5661c8475790aff84e67dff09.tar.gz |
MDEV-8862 Wrong field type for MAX(COALESCE(datetime_column))
Diffstat (limited to 'mysql-test/r')
-rw-r--r-- | mysql-test/r/type_time.result | 9 |
1 files changed, 9 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 # |