diff options
Diffstat (limited to 'mysql-test/main/olap.test')
-rw-r--r-- | mysql-test/main/olap.test | 25 |
1 files changed, 23 insertions, 2 deletions
diff --git a/mysql-test/main/olap.test b/mysql-test/main/olap.test index 74dbe8ba10b..3756712b49d 100644 --- a/mysql-test/main/olap.test +++ b/mysql-test/main/olap.test @@ -406,7 +406,29 @@ DROP TABLE t1, t2; --echo End of 5.0 tests --echo # ---echo # Start of 10.3 tests +--echo # End of 10.0 tests +--echo # + +--echo # +--echo # MDEV-16190 Server crashes in Item_null_result::field_type on SELECT with time field, ROLLUP and HAVING +--echo # +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'; +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'; +DROP TABLE t1; + + +--echo # +--echo # End of 10.1 tests +--echo # + +--echo # +--echo # End of 10.2 tests --echo # --echo # @@ -462,5 +484,4 @@ SELECT NULLIF( CAST( 'foo' AS DATE ), NULL & 'bar' ) AS f FROM t1 GROUP BY f WIT --enable_warnings DROP TABLE t1; - --echo # End of 10.3 Tests |