diff options
Diffstat (limited to 'mysql-test/t/type_datetime.test')
-rw-r--r-- | mysql-test/t/type_datetime.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/type_datetime.test b/mysql-test/t/type_datetime.test index e2ac9122a10..e44b190def0 100644 --- a/mysql-test/t/type_datetime.test +++ b/mysql-test/t/type_datetime.test @@ -466,10 +466,12 @@ DROP TABLE t1; # # MDEV-4281 Assertion `maybe_null && item->null_value' fails in make_sortkey on CASE with different return types, GROUP_CONCAT, GROUP BY # +SET timestamp=UNIX_TIMESTAMP('2001-01-01 10:20:30'); create table t1 (d date, t time) engine=myisam; insert into t1 values ('2000-12-03','22:55:23'),('2008-05-03','10:19:31'); select case when d = '2012-12-12' then d else t end as cond, group_concat( d ) from t1 group by cond; drop table t1; +SET timestamp=DEFAULT; --echo # --echo # Semantics of the condition <non-nullable datetime field> IS NULL |