diff options
| author | unknown <hf@deer.(none)> | 2005-06-14 17:43:51 +0500 |
|---|---|---|
| committer | unknown <hf@deer.(none)> | 2005-06-14 17:43:51 +0500 |
| commit | 0473ce99fa1f9ed6ab2f37a3b043013dcd38c53e (patch) | |
| tree | 7c282b77876ef0ab3ed7b6a25adad2ed6a5cdd44 /mysql-test/t/func_default.test | |
| parent | ff40f3034917957fef5bb7f80e556d4835bc3410 (diff) | |
| download | mariadb-git-0473ce99fa1f9ed6ab2f37a3b043013dcd38c53e.tar.gz | |
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
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; + |