From 5168730f6bd6b4832ddb208c7f1a1af58ff3c678 Mon Sep 17 00:00:00 2001 From: unknown Date: Mon, 5 Sep 2005 17:58:29 +0400 Subject: func_gconcat.test, func_gconcat.result: Test case for bug #12859 group_concat in subquery cause incorrect not null. mysql-test/r/func_gconcat.result: Test case for bug #12859 group_concat in subquery cause incorrect not null. mysql-test/t/func_gconcat.test: Test case for bug #12859 group_concat in subquery cause incorrect not null. --- mysql-test/t/func_gconcat.test | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'mysql-test/t/func_gconcat.test') diff --git a/mysql-test/t/func_gconcat.test b/mysql-test/t/func_gconcat.test index 827a2813718..9e003d19ab9 100644 --- a/mysql-test/t/func_gconcat.test +++ b/mysql-test/t/func_gconcat.test @@ -348,4 +348,12 @@ DROP TABLE t1,t2; # select * from (select group_concat('c') from DUAL) t; +# +# Bug #12859 group_concat in subquery cause incorrect not null +# +create table t1 ( a int not null default 0); +select * from (select group_concat(a) from t1) t2; +select group_concat('x') UNION ALL select 1; +drop table t1; + # End of 4.1 tests -- cgit v1.2.1