diff options
| author | evgen@moonbone.local <> | 2005-09-05 17:58:29 +0400 |
|---|---|---|
| committer | evgen@moonbone.local <> | 2005-09-05 17:58:29 +0400 |
| commit | 7493f615d883fa6b97efb43372aa7c35a5eacee6 (patch) | |
| tree | 1203e59ad489ac40c287ffd7ba00352b1716cc1d /mysql-test/r/func_gconcat.result | |
| parent | 0f34207606c5e7240d05f27b5324ed98d5a894db (diff) | |
| download | mariadb-git-7493f615d883fa6b97efb43372aa7c35a5eacee6.tar.gz | |
func_gconcat.test, func_gconcat.result:
Test case for bug #12859 group_concat in subquery cause incorrect not null.
Diffstat (limited to 'mysql-test/r/func_gconcat.result')
| -rw-r--r-- | mysql-test/r/func_gconcat.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/func_gconcat.result b/mysql-test/r/func_gconcat.result index a6c25fcd26c..12bc5ca2582 100644 --- a/mysql-test/r/func_gconcat.result +++ b/mysql-test/r/func_gconcat.result @@ -551,3 +551,12 @@ DROP TABLE t1,t2; select * from (select group_concat('c') from DUAL) t; group_concat('c') NULL +create table t1 ( a int not null default 0); +select * from (select group_concat(a) from t1) t2; +group_concat(a) +NULL +select group_concat('x') UNION ALL select 1; +group_concat('x') +NULL +1 +drop table t1; |