diff options
| author | unknown <timour@askmonty.org> | 2010-09-16 16:49:20 +0300 |
|---|---|---|
| committer | unknown <timour@askmonty.org> | 2010-09-16 16:49:20 +0300 |
| commit | 35f0faf4c7cd5d0b6270855f274027f85c5aca72 (patch) | |
| tree | 7375b4789aaa50fcaf351de41f224aa229bb75a2 /mysql-test/r/subselect3.result | |
| parent | 22a2cce37790fbbd7f847407013ce15d7aa8ed86 (diff) | |
| download | mariadb-git-35f0faf4c7cd5d0b6270855f274027f85c5aca72.tar.gz | |
MWL#89: Cost-based choice between Materialization and IN->EXISTS transformation
- Corrected a wrong result that was recorded by the MySQL fix for BUG#39069.
- Removed Item_func_isnull::cached_value and all the logic around this custom-made
caching of the NULL result because MWL#89 optimizes subqueries before the outer
query is being executed, and this cache cannot be made easily to work for all
kinds of Items (specifically Item_sum_sum, but others too).
Diffstat (limited to 'mysql-test/r/subselect3.result')
| -rw-r--r-- | mysql-test/r/subselect3.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/subselect3.result b/mysql-test/r/subselect3.result index 665bb9a2bde..cfc18413ee0 100644 --- a/mysql-test/r/subselect3.result +++ b/mysql-test/r/subselect3.result @@ -843,8 +843,8 @@ x ROW(11, 12) = (SELECT MAX(x), 22) ROW(11, 12) IN (SELECT MAX(x), 22) # 2nd and 3rd columns should be same for x == 11 only SELECT a AS x, ROW(11, 12) = (SELECT MAX(x), 12), ROW(11, 12) IN (SELECT MAX(x), 12) FROM t1; x ROW(11, 12) = (SELECT MAX(x), 12) ROW(11, 12) IN (SELECT MAX(x), 12) -1 0 1 -2 0 1 +1 0 0 +2 0 0 11 1 1 DROP TABLE t1; # both columns should be same |