diff options
author | unknown <jimw@mysql.com> | 2005-04-04 23:03:56 -0700 |
---|---|---|
committer | unknown <jimw@mysql.com> | 2005-04-04 23:03:56 -0700 |
commit | 66e6808ed0b31f085eab4187fa835cb1168e8aa9 (patch) | |
tree | 6ad8acc6094f563caca17989c7e15c8f1d599987 /mysql-test/t/join_outer.test | |
parent | 2cb2374b78b8bab2655a3f45d9e4f657c2250336 (diff) | |
parent | 682baee2316f194108587ce0da4aa44ea1a481ab (diff) | |
download | mariadb-git-66e6808ed0b31f085eab4187fa835cb1168e8aa9.tar.gz |
Merge
mysql-test/r/join_outer.result:
Auto merged
mysql-test/t/join_outer.test:
Auto merged
sql-common/client.c:
Auto merged
sql/mysqld.cc:
Auto merged
Diffstat (limited to 'mysql-test/t/join_outer.test')
-rw-r--r-- | mysql-test/t/join_outer.test | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/mysql-test/t/join_outer.test b/mysql-test/t/join_outer.test index 38b5ef6151f..25344af55b4 100644 --- a/mysql-test/t/join_outer.test +++ b/mysql-test/t/join_outer.test @@ -651,4 +651,13 @@ SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.a WHERE not(0+(t1.a=30 and t2.b=1)); DROP TABLE t1,t2; - +# Bug #8681: Bad warning message when group_concat() exceeds max length +set group_concat_max_len=5; +create table t1 (a int, b varchar(20)); +create table t2 (a int, c varchar(20)); +insert into t1 values (1,"aaaaaaaaaa"),(2,"bbbbbbbbbb"); +insert into t2 values (1,"cccccccccc"),(2,"dddddddddd"); +select group_concat(t1.b,t2.c) from t1 left join t2 using(a) group by t1.a; +select group_concat(t1.b,t2.c) from t1 inner join t2 using(a) group by t1.a; +drop table t1, t2; +set group_concat_max_len=default; |