diff options
| author | Tatiana A. Nurnberg <azundris@mysql.com> | 2010-02-19 19:06:47 +0000 |
|---|---|---|
| committer | Tatiana A. Nurnberg <azundris@mysql.com> | 2010-02-19 19:06:47 +0000 |
| commit | 60a114d838278797bce949be4fd7b8acc9f7ef64 (patch) | |
| tree | ca01d689dff2d01fe5f03cdac4803c238a0a93d5 /mysql-test/t/func_gconcat.test | |
| parent | 141bb7d144e093c860f2183abf220875ee681930 (diff) | |
| parent | 1fc1f462b6d469d7b1f2bb94ba99f4554ced1cd5 (diff) | |
| download | mariadb-git-60a114d838278797bce949be4fd7b8acc9f7ef64.tar.gz | |
manual merge
Diffstat (limited to 'mysql-test/t/func_gconcat.test')
| -rw-r--r-- | mysql-test/t/func_gconcat.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/func_gconcat.test b/mysql-test/t/func_gconcat.test index e92f3e96303..cfb4cdc9ecd 100644 --- a/mysql-test/t/func_gconcat.test +++ b/mysql-test/t/func_gconcat.test @@ -693,4 +693,19 @@ SELECT 1 FROM t1 WHERE t1.a NOT IN DROP TABLE t1, t2; +# +# Bug #49487: crash with explain extended and group_concat in a derived table +# + +CREATE TABLE t1 (f1 INT); +INSERT INTO t1 VALUES (),(); + +EXPLAIN EXTENDED SELECT 1 FROM + (SELECT DISTINCT GROUP_CONCAT(td.f1) FROM t1,t1 AS td GROUP BY td.f1) AS d,t1; + +SELECT 1 FROM + (SELECT DISTINCT GROUP_CONCAT(td.f1) FROM t1,t1 AS td GROUP BY td.f1) AS d,t1; + +DROP TABLE t1; + --echo End of 5.0 tests |