diff options
Diffstat (limited to 'mysql-test/t/func_default.test')
-rw-r--r-- | mysql-test/t/func_default.test | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/mysql-test/t/func_default.test b/mysql-test/t/func_default.test index 6ae9f088f92..963d069fdd2 100644 --- a/mysql-test/t/func_default.test +++ b/mysql-test/t/func_default.test @@ -16,4 +16,13 @@ explain select * from t1 where str <> default(str); #show create table from t1; #insert into t2 select select default(str), default(strnull), default(intg), default(rel) from t1; -drop table t1;
\ No newline at end of file +drop table t1; + +# +# Bug #11314 (HAVING DEFAULT() hangs) +# +CREATE TABLE t1 (s varchar(20), id int(11)); +INSERT INTO t1 VALUES (1, 'one'), (2, 'two'), (3, 'three'); +SELECT s, 32 AS mi FROM t1 GROUP BY s HAVING DEFAULT(mi) IS NULL; +DROP TABLE t1; + |