diff options
| author | unknown <mhansson/martin@linux-st28.site> | 2008-01-11 19:00:26 +0100 |
|---|---|---|
| committer | unknown <mhansson/martin@linux-st28.site> | 2008-01-11 19:00:26 +0100 |
| commit | 7bd7e988122864c1a86b65cdcd1de900ab82745f (patch) | |
| tree | 21f2ef5e2bbd17ae2970f14bad81c06f55fd4325 /mysql-test/r/group_by.result | |
| parent | 84762ce2cb01d352858dfff14afa9debffd14d8a (diff) | |
| parent | df8e9fc234234958ee0cb6195b724657b2cd128c (diff) | |
| download | mariadb-git-7bd7e988122864c1a86b65cdcd1de900ab82745f.tar.gz | |
Merge mhansson@bk-internal:/home/bk/mysql-5.0-opt
into linux-st28.site:/home/martin/mysql/src/bug31797/my50-bug31797-pushee
sql/item.cc:
Auto merged
mysql-test/r/group_by.result:
Bug#31797: Manual merge
mysql-test/t/group_by.test:
Bug#31797: Manual merge
Diffstat (limited to 'mysql-test/r/group_by.result')
| -rw-r--r-- | mysql-test/r/group_by.result | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 1693fa646eb..7574aa916ae 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -1177,4 +1177,40 @@ id c1 c2 4 2 3 1 5 1 DROP TABLE t1; +CREATE TABLE t1 ( a INT, b INT ); +SELECT b c, (SELECT a FROM t1 WHERE b = c) +FROM t1; +c (SELECT a FROM t1 WHERE b = c) +SELECT b c, (SELECT a FROM t1 WHERE b = c) +FROM t1 +HAVING b = 10; +c (SELECT a FROM t1 WHERE b = c) +SELECT MAX(b) c, (SELECT a FROM t1 WHERE b = c) +FROM t1 +HAVING b = 10; +ERROR 42S22: Reference 'c' not supported (reference to group function) +SET @old_sql_mode = @@sql_mode; +SET @@sql_mode='ONLY_FULL_GROUP_BY'; +SELECT b c, (SELECT a FROM t1 WHERE b = c) +FROM t1; +c (SELECT a FROM t1 WHERE b = c) +SELECT b c, (SELECT a FROM t1 WHERE b = c) +FROM t1 +HAVING b = 10; +ERROR 42000: non-grouping field 'b' is used in HAVING clause +SELECT MAX(b) c, (SELECT a FROM t1 WHERE b = c) +FROM t1 +HAVING b = 10; +ERROR 42S22: Reference 'c' not supported (reference to group function) +INSERT INTO t1 VALUES (1, 1); +SELECT b c, (SELECT a FROM t1 WHERE b = c) +FROM t1; +c (SELECT a FROM t1 WHERE b = c) +1 1 +INSERT INTO t1 VALUES (2, 1); +SELECT b c, (SELECT a FROM t1 WHERE b = c) +FROM t1; +ERROR 21000: Subquery returns more than 1 row +DROP TABLE t1; +SET @@sql_mode = @old_sql_mode; End of 5.0 tests |