diff options
| author | Tor Didriksen <tor.didriksen@oracle.com> | 2011-05-05 08:13:22 +0200 |
|---|---|---|
| committer | Tor Didriksen <tor.didriksen@oracle.com> | 2011-05-05 08:13:22 +0200 |
| commit | 6848f6c0d6e8c4bb5aa1ad2d39cd536860bd7e0b (patch) | |
| tree | cd172df35bbbc323a22f426774bc859ed6080cb5 /mysql-test/r/explain.result | |
| parent | 2da8ba6404bbba119d5d90575411978ace0f6ee6 (diff) | |
| parent | e257fb3319ea6919de0a3c74c7025d4f9a218fed (diff) | |
| download | mariadb-git-6848f6c0d6e8c4bb5aa1ad2d39cd536860bd7e0b.tar.gz | |
merge 5.1 => 5.5 : Bug#12329653
Diffstat (limited to 'mysql-test/r/explain.result')
| -rw-r--r-- | mysql-test/r/explain.result | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/mysql-test/r/explain.result b/mysql-test/r/explain.result index b8f791b27f4..887fb319adc 100644 --- a/mysql-test/r/explain.result +++ b/mysql-test/r/explain.result @@ -176,10 +176,12 @@ SELECT @@session.sql_mode INTO @old_sql_mode; SET SESSION sql_mode='ONLY_FULL_GROUP_BY'; EXPLAIN EXTENDED SELECT 1 FROM t1 WHERE f1 > ALL( SELECT t.f1 FROM t1,t1 AS t ); -ERROR 42000: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause -SHOW WARNINGS; -Level Code Message -Error 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause +id select_type table type possible_keys key key_len ref rows filtered Extra +1 PRIMARY NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +2 SUBQUERY t1 system NULL NULL NULL NULL 0 0.00 const row not found +2 SUBQUERY t system NULL NULL NULL NULL 0 0.00 const row not found +Warnings: +Note 1003 select 1 AS `1` from `test`.`t1` where 0 SET SESSION sql_mode=@old_sql_mode; DROP TABLE t1; End of 5.0 tests. |