diff options
author | unknown <msvensson@neptunus.(none)> | 2006-08-03 09:32:58 +0200 |
---|---|---|
committer | unknown <msvensson@neptunus.(none)> | 2006-08-03 09:32:58 +0200 |
commit | ed44a2ee51d7ed34bc98178cd03b3260342c5c06 (patch) | |
tree | ef70ce093b8f53435eb03a5e77c0f0c6b76b7b77 /mysql-test/t/func_group.test | |
parent | 695c534d76c68ce0b8afa9c261e41ab9a24d93b2 (diff) | |
parent | 3c8150b79bf5302879897e0d1ebd594798bb419e (diff) | |
download | mariadb-git-ed44a2ee51d7ed34bc98178cd03b3260342c5c06.tar.gz |
Merge neptunus.(none):/home/msvensson/mysql/mysql-5.0
into neptunus.(none):/home/msvensson/mysql/mysql-5.0-maint
client/mysql.cc:
Auto merged
client/mysqltest.c:
Auto merged
mysql-test/mysql-test-run.pl:
Auto merged
mysql-test/r/date_formats.result:
Auto merged
mysql-test/r/union.result:
Auto merged
mysql-test/t/union.test:
Auto merged
sql/field.cc:
Auto merged
sql/item.cc:
Auto merged
sql/item_func.cc:
Auto merged
sql/item_func.h:
Auto merged
sql/item_strfunc.cc:
Auto merged
sql/item_strfunc.h:
Auto merged
sql/item_subselect.cc:
Auto merged
sql/item_sum.cc:
Auto merged
sql/sql_yacc.yy:
Auto merged
mysql-test/r/func_group.result:
Merge manually
mysql-test/t/func_group.test:
Merge manually
Diffstat (limited to 'mysql-test/t/func_group.test')
-rw-r--r-- | mysql-test/t/func_group.test | 18 |
1 files changed, 17 insertions, 1 deletions
diff --git a/mysql-test/t/func_group.test b/mysql-test/t/func_group.test index ff8f7eb2d72..c2dd77e662a 100644 --- a/mysql-test/t/func_group.test +++ b/mysql-test/t/func_group.test @@ -661,6 +661,22 @@ 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; + +# # Bug #10966: Variance functions return wrong data type # @@ -670,4 +686,4 @@ drop table t1; create table t1 select stddev(0); show create table t1; drop table t1; -
\ No newline at end of file + |