diff options
| author | unknown <lenz@mysql.com> | 2004-06-15 14:41:23 +0200 |
|---|---|---|
| committer | unknown <lenz@mysql.com> | 2004-06-15 14:41:23 +0200 |
| commit | c488fe233c8bc72301549a39229b6ede42e498cc (patch) | |
| tree | 0bf9cf02da7e5b37648fec022155052ed4fc8830 /mysql-test/t/func_gconcat.test | |
| parent | 40b08dce0b6b5cfa1e02d79b07b1a203242ef682 (diff) | |
| parent | 0f83847940dfa10ba641230607e52321f27df3a8 (diff) | |
| download | mariadb-git-c488fe233c8bc72301549a39229b6ede42e498cc.tar.gz | |
Merge lgrimmer@build.mysql.com:/home/bk/mysql-4.1
into mysql.com:/space/my/mysql-4.1
Diffstat (limited to 'mysql-test/t/func_gconcat.test')
| -rw-r--r-- | mysql-test/t/func_gconcat.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/func_gconcat.test b/mysql-test/t/func_gconcat.test index 2448a1d3209..5ddc93e767b 100644 --- a/mysql-test/t/func_gconcat.test +++ b/mysql-test/t/func_gconcat.test @@ -189,3 +189,15 @@ INSERT INTO t1 VALUES (1), (2); INSERT INTO t2 VALUES (1), (2); SELECT GROUP_CONCAT(t1.a*t2.a ORDER BY t2.a) FROM t1, t2 GROUP BY t1.a; DROP TABLE t1, t2; + +# +# Bug #4035: group_concat() and HAVING +# + +CREATE TABLE t1 (a char(4)); +INSERT INTO t1 VALUES ('John'), ('Anna'), ('Bill'); +SELECT GROUP_CONCAT(a SEPARATOR '||') AS names FROM t1 + HAVING names LIKE '%An%'; +SELECT GROUP_CONCAT(a SEPARATOR '###') AS names FROM t1 + HAVING LEFT(names, 1) ='J'; +DROP TABLE t1; |