diff options
author | Alexander Barkov <bar@mariadb.com> | 2018-12-12 10:39:06 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2018-12-12 10:39:06 +0400 |
commit | c353b2a8fc10e16107ee6c7e26877f4243d4eaef (patch) | |
tree | 6bb3d15613d83be28e8720f25ba4072bdbe0582f /mysql-test/main/timezone2.result | |
parent | 4abb8216a054e14afbeb81e8529e02bab6fa14ac (diff) | |
download | mariadb-git-c353b2a8fc10e16107ee6c7e26877f4243d4eaef.tar.gz |
--echo #
--echo # MDEV-17979 Assertion `0' failed in Item::val_native upon SELECT with timestamp, NULLIF, GROUP BY
--echo #
Diffstat (limited to 'mysql-test/main/timezone2.result')
-rw-r--r-- | mysql-test/main/timezone2.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/main/timezone2.result b/mysql-test/main/timezone2.result index a58a0ee632f..dd137045d1a 100644 --- a/mysql-test/main/timezone2.result +++ b/mysql-test/main/timezone2.result @@ -542,5 +542,18 @@ SELECT * FROM t1 WHERE a IN ((SELECT MAX(b) FROM t1), (SELECT MIN(b) FROM t1)); a b DROP TABLE t1; # +# MDEV-17979 Assertion `0' failed in Item::val_native upon SELECT with timestamp, NULLIF, GROUP BY +# +SET time_zone='+00:00'; +CREATE TABLE t1 (a INT, ts TIMESTAMP) ENGINE=MyISAM; +INSERT INTO t1 VALUES (1, FROM_UNIXTIME(1288481126) /*winter time in Moscow*/); +SET time_zone='Europe/Moscow'; +CREATE TABLE t2 AS SELECT ts, COALESCE(ts) AS cts FROM t1 GROUP BY cts; +SELECT ts, cts, UNIX_TIMESTAMP(ts) AS uts, UNIX_TIMESTAMP(cts) AS ucts FROM t2; +ts cts uts ucts +2010-10-31 02:25:26 2010-10-31 02:25:26 1288481126 1288481126 +DROP TABLE t1,t2; +SET time_zone=DEFAULT; +# # End of 10.4 tests # |