diff options
| author | unknown <sanja@askmonty.org> | 2011-09-02 10:11:13 +0300 |
|---|---|---|
| committer | unknown <sanja@askmonty.org> | 2011-09-02 10:11:13 +0300 |
| commit | 37a8497d494ea256ff4b13a89e62150e06a17dae (patch) | |
| tree | 608813a49f5688186b2ae0dac4472c00829b11a3 /mysql-test/r/explain.result | |
| parent | 31c8c95bb204e74431412d07970a8133a352984f (diff) | |
| download | mariadb-git-37a8497d494ea256ff4b13a89e62150e06a17dae.tar.gz | |
LP BUG#823169 fix.
For ANY subqueries NULLs should be ignored (if there is other values) when finding max min.
For ALL subqueries NULLs should be saved if they found.
Optimisation for ALL suqbueries if NULL is possible in the SELECT list with max/min aggregate function switched off.
Some test changed where NULL is not used but optimization with max/min aggregate function important so NOT NULL added.
mysql-test/r/explain.result:
Forced old optimization.
mysql-test/r/subselect.result:
Forced old optimization.
New test suite.
mysql-test/t/explain.test:
Forced old optimization.
mysql-test/t/subselect.test:
Forced old optimization.
New test suite.
sql/item_subselect.cc:
Store converted subquery type.
Switch off aggregate function optimisation for ALL and nulls.
sql/sql_class.cc:
Fixed NULL comparison.
sql/sql_class.h:
Store converted subquery type.
Diffstat (limited to 'mysql-test/r/explain.result')
| -rw-r--r-- | mysql-test/r/explain.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/explain.result b/mysql-test/r/explain.result index 0ce2e7b85dc..4069ecf9028 100644 --- a/mysql-test/r/explain.result +++ b/mysql-test/r/explain.result @@ -171,7 +171,7 @@ DROP TABLE t1; # Bug#48295: # explain extended crash with subquery and ONLY_FULL_GROUP_BY sql_mode # -CREATE TABLE t1 (f1 INT); +CREATE TABLE t1 (f1 INT not null); SELECT @@session.sql_mode INTO @old_sql_mode; SET SESSION sql_mode='ONLY_FULL_GROUP_BY'; EXPLAIN EXTENDED SELECT 1 FROM t1 |