diff options
| author | unknown <jimw@mysql.com> | 2005-04-04 18:29:18 -0700 |
|---|---|---|
| committer | unknown <jimw@mysql.com> | 2005-04-04 18:29:18 -0700 |
| commit | 682baee2316f194108587ce0da4aa44ea1a481ab (patch) | |
| tree | 3272382754e3df3ca707e76b48a80bd01e39a8f5 /mysql-test | |
| parent | 52781a484c5f043bcccb1faac31f7fa3af7eaf33 (diff) | |
| parent | a728ad71cf073b9b10080d866e904c9eaa05ab32 (diff) | |
| download | mariadb-git-682baee2316f194108587ce0da4aa44ea1a481ab.tar.gz | |
Merge new tests
mysql-test/r/join_outer.result:
Update results
mysql-test/t/join_outer.test:
Merge
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/join_outer.result | 19 | ||||
| -rw-r--r-- | mysql-test/t/join_outer.test | 11 |
2 files changed, 29 insertions, 1 deletions
diff --git a/mysql-test/r/join_outer.result b/mysql-test/r/join_outer.result index b035f88da41..b6265aac4a3 100644 --- a/mysql-test/r/join_outer.result +++ b/mysql-test/r/join_outer.result @@ -864,3 +864,22 @@ a b a b 3 1 NULL NULL 4 2 NULL NULL DROP TABLE t1,t2; +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; +group_concat(t1.b,t2.c) +aaaaa +bbbbb +Warnings: +Warning 1260 2 line(s) were cut by GROUP_CONCAT() +select group_concat(t1.b,t2.c) from t1 inner join t2 using(a) group by t1.a; +group_concat(t1.b,t2.c) +aaaaa +bbbbb +Warnings: +Warning 1260 2 line(s) were cut by GROUP_CONCAT() +drop table t1, t2; +set group_concat_max_len=default; diff --git a/mysql-test/t/join_outer.test b/mysql-test/t/join_outer.test index fe9ec1e0963..d5fa1592965 100644 --- a/mysql-test/t/join_outer.test +++ b/mysql-test/t/join_outer.test @@ -614,4 +614,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; |