From 0473ce99fa1f9ed6ab2f37a3b043013dcd38c53e Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 14 Jun 2005 17:43:51 +0500 Subject: Fix for bug #11314 (HAVING DEFAULT() hangs) mysql-test/t/func_default.test: test result fixed sql/item.cc: code simplified using real_item() method, error returning added --- mysql-test/t/func_default.test | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) (limited to 'mysql-test/t/func_default.test') 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; + -- cgit v1.2.1