diff options
Diffstat (limited to 'mysql-test/main/olap.result')
| -rw-r--r-- | mysql-test/main/olap.result | 24 |
1 files changed, 23 insertions, 1 deletions
diff --git a/mysql-test/main/olap.result b/mysql-test/main/olap.result index 6fdbe008016..1931fac6029 100644 --- a/mysql-test/main/olap.result +++ b/mysql-test/main/olap.result @@ -767,7 +767,29 @@ NULL DROP TABLE t1, t2; End of 5.0 tests # -# Start of 10.3 tests +# End of 10.0 tests +# +# +# MDEV-16190 Server crashes in Item_null_result::field_type on SELECT with time field, ROLLUP and HAVING +# +CREATE TABLE t1 (t TIME) ENGINE=MyISAM; +INSERT INTO t1 VALUES ('12:12:12'); +SELECT t, COUNT(*) FROM t1 GROUP BY t WITH ROLLUP HAVING t > '00:00:00'; +t COUNT(*) +12:12:12 1 +DROP TABLE t1; +CREATE TABLE t1 (t TIME) ENGINE=MyISAM; +INSERT INTO t1 VALUES ('12:12:12'),('12:12:13'); +SELECT t, COUNT(*) FROM t1 GROUP BY t WITH ROLLUP HAVING t > '00:00:00'; +t COUNT(*) +12:12:12 1 +12:12:13 1 +DROP TABLE t1; +# +# End of 10.1 tests +# +# +# End of 10.2 tests # # # MDEV-12886 Different default for INT and BIGINT column in a VIEW for a SELECT with ROLLUP |