diff options
| author | Tor Didriksen <tor.didriksen@oracle.com> | 2011-05-04 17:12:45 +0200 |
|---|---|---|
| committer | Tor Didriksen <tor.didriksen@oracle.com> | 2011-05-04 17:12:45 +0200 |
| commit | e257fb3319ea6919de0a3c74c7025d4f9a218fed (patch) | |
| tree | 4b2a82480afbf07a0e4ba4447dbf4f3a51761bbe /mysql-test/t/explain.test | |
| parent | b96d97fd7f25ad7570688cf38b10b4b77a648871 (diff) | |
| parent | 1cf483aa588cf47383af49db6d7304b911ee92db (diff) | |
| download | mariadb-git-e257fb3319ea6919de0a3c74c7025d4f9a218fed.tar.gz | |
merge 5.0 => 5.1 : Bug#12329653
Diffstat (limited to 'mysql-test/t/explain.test')
| -rw-r--r-- | mysql-test/t/explain.test | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/mysql-test/t/explain.test b/mysql-test/t/explain.test index c6c30b58341..e764ee80578 100644 --- a/mysql-test/t/explain.test +++ b/mysql-test/t/explain.test @@ -1,5 +1,5 @@ # -# Test of different EXPLAIN's +# Test of different EXPLAINs --disable_warnings drop table if exists t1; @@ -157,11 +157,12 @@ CREATE TABLE t1 (f1 INT); SELECT @@session.sql_mode INTO @old_sql_mode; SET SESSION sql_mode='ONLY_FULL_GROUP_BY'; -# EXPLAIN EXTENDED (with subselect). used to crash. should give NOTICE. ---error ER_MIX_OF_GROUP_FUNC_AND_FIELDS +# EXPLAIN EXTENDED (with subselect). used to crash. +# This is actually a valid query for this sql_mode, +# but it was transformed in such a way that it failed, see +# Bug#12329653 - EXPLAIN, UNION, PREPARED STATEMENT, CRASH, SQL_FULL_GROUP_BY EXPLAIN EXTENDED SELECT 1 FROM t1 WHERE f1 > ALL( SELECT t.f1 FROM t1,t1 AS t ); -SHOW WARNINGS; SET SESSION sql_mode=@old_sql_mode; |