diff options
| author | Bernt M. Johnsen <bernt.johnsen@sun.com> | 2009-02-26 18:17:06 +0100 |
|---|---|---|
| committer | Bernt M. Johnsen <bernt.johnsen@sun.com> | 2009-02-26 18:17:06 +0100 |
| commit | 2cca1991bd25fe9a085ccb4d66ed39d1e054d495 (patch) | |
| tree | 97f3c55d9d25c853bb06b607c83b886030e08451 /mysql-test/r/group_by.result | |
| parent | cd5744db13a186add2814da0aed0719817ac075b (diff) | |
| download | mariadb-git-2cca1991bd25fe9a085ccb4d66ed39d1e054d495.tar.gz | |
Prepared for push (BUG#42567)
Diffstat (limited to 'mysql-test/r/group_by.result')
| -rw-r--r-- | mysql-test/r/group_by.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 48f97aeb428..742d4b90807 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -1691,3 +1691,15 @@ FROM t1; ERROR 21000: Subquery returns more than 1 row DROP TABLE t1; SET @@sql_mode = @old_sql_mode; +SET @old_sql_mode = @@sql_mode; +SET @@sql_mode='ONLY_FULL_GROUP_BY'; +CREATE TABLE t1(i INT); +INSERT INTO t1 VALUES (1), (10); +SELECT COUNT(i) FROM t1; +COUNT(i) +2 +SELECT COUNT(i) FROM t1 WHERE i > 1; +COUNT(i) +1 +DROP TABLE t1; +SET @@sql_mode = @old_sql_mode; |