diff options
| author | Alexander Barkov <bar@mariadb.com> | 2019-04-19 21:04:44 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.com> | 2019-04-19 21:04:44 +0400 |
| commit | f4b27400185bab217da11f8781eebb09a8502304 (patch) | |
| tree | 820d0cf08d6946a8347927774d0ba852a3e0b619 /mysql-test/t | |
| parent | 056b6fe1d59b515a6380e50783b3c4ad0f93959f (diff) | |
| download | mariadb-git-f4b27400185bab217da11f8781eebb09a8502304.tar.gz | |
MDEV-17299 Assertion `maybe_null' failed in make_sortkey
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/type_date.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/type_date.test b/mysql-test/t/type_date.test index 8248386a93f..554542f9dd3 100644 --- a/mysql-test/t/type_date.test +++ b/mysql-test/t/type_date.test @@ -585,6 +585,20 @@ INSERT INTO t1 VALUES ('1985-05-13'),('1989-12-24'); SELECT d, COUNT(*) FROM t1 GROUP BY d WITH ROLLUP HAVING CASE d WHEN '2017-05-25' THEN 0 ELSE 1 END; DROP TABLE t1; +--echo # +--echo # MDEV-17299 Assertion `maybe_null' failed in make_sortkey +--echo # + +CREATE TABLE t1 (pk int NOT NULL, d1 date, d2 date NOT NULL); +INSERT INTO t1 values (1,'2018-06-22','2018-06-22'),(2,'2018-07-11','2018-07-11'); +CREATE VIEW v1 AS SELECT * FROM t1; +SELECT group_concat(d1/(CASE 'b' WHEN 'j' THEN 'c' END)) + FROM v1 GROUP BY greatest(pk, 0, d2); +CREATE TABLE t2 AS SELECT greatest(pk, 0, d2) AS c1 FROM t1 LIMIT 0; +SHOW CREATE TABLE t2; +DROP TABLE t2; +DROP VIEW v1; +DROP TABLE t1; --echo # --echo # End of 10.1 tests |