diff options
| author | evgen@sunlight.local <> | 2006-07-30 00:33:24 +0400 |
|---|---|---|
| committer | evgen@sunlight.local <> | 2006-07-30 00:33:24 +0400 |
| commit | ef4f14953640962c405e7df7fdb803daaa878128 (patch) | |
| tree | 7459ead6708231c323be75b3f99c455341370348 /mysql-test/t/func_group.test | |
| parent | 8cd88a91794e37ec05509ef5ea121bcb69eef0c9 (diff) | |
| parent | 3ca575dc896753f9dd52f45eaf983219d5cbd899 (diff) | |
| download | mariadb-git-ef4f14953640962c405e7df7fdb803daaa878128.tar.gz | |
Merge sunlight.local:/local_work/tmp_merge-5.0-opt-mysql
into sunlight.local:/local_work/tmp_merge-5.1-opt-mysql
Diffstat (limited to 'mysql-test/t/func_group.test')
| -rw-r--r-- | mysql-test/t/func_group.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/func_group.test b/mysql-test/t/func_group.test index 760745dc14e..2806ffb5ae0 100644 --- a/mysql-test/t/func_group.test +++ b/mysql-test/t/func_group.test @@ -667,3 +667,18 @@ SELECT SUM(a) FROM t1 GROUP BY b/c; DROP TABLE t1; set div_precision_increment= @sav_dpi; +# +# Bug #20868: Client connection is broken on SQL query error +# +CREATE TABLE t1 (a INT PRIMARY KEY, b INT); +INSERT INTO t1 VALUES (1,1), (2,2); + +CREATE TABLE t2 (a INT PRIMARY KEY, b INT); +INSERT INTO t2 VALUES (1,1), (3,3); + +SELECT SQL_NO_CACHE + (SELECT SUM(c.a) FROM t1 ttt, t2 ccc + WHERE ttt.a = ccc.b AND ttt.a = t.a GROUP BY ttt.a) AS minid +FROM t1 t, t2 c WHERE t.a = c.b; + +DROP TABLE t1,t2; |