diff options
| author | unknown <mhansson/martin@linux-st28.site> | 2008-01-11 19:13:07 +0100 |
|---|---|---|
| committer | unknown <mhansson/martin@linux-st28.site> | 2008-01-11 19:13:07 +0100 |
| commit | ab0f3e4661f720c852e76771120127bdcce2cfea (patch) | |
| tree | f74fe73bbd210f1d1fc78e60d0f4e72cb897a196 /mysql-test/r/group_by.result | |
| parent | 666efa1c43344a0b4dbe815e57333647d4d8f2b3 (diff) | |
| parent | df8e9fc234234958ee0cb6195b724657b2cd128c (diff) | |
| download | mariadb-git-ab0f3e4661f720c852e76771120127bdcce2cfea.tar.gz | |
Merge linux-st28.site:/home/martin/mysql/src/bug31797/my50-bug31797
into linux-st28.site:/home/martin/mysql/src/bug31797/my51-bug31797
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 7498267c91d..534b06bbe67 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -1413,3 +1413,39 @@ NULL 1 2 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; |