diff options
| author | unknown <timour@askmonty.org> | 2011-11-21 16:56:32 +0200 |
|---|---|---|
| committer | unknown <timour@askmonty.org> | 2011-11-21 16:56:32 +0200 |
| commit | f0d9908fc3582cf08db7e0376f0e243b1e754ad5 (patch) | |
| tree | c05ad7a90dcb96d7d31452311085480a8b06dd5c /mysql-test/r/myisam_icp.result | |
| parent | 9cde33f9ef139f7511db66393694bbc3af6a863f (diff) | |
| parent | 32d230d67bce5c4b19e25392c74b2fe8c9419248 (diff) | |
| download | mariadb-git-f0d9908fc3582cf08db7e0376f0e243b1e754ad5.tar.gz | |
Merge enabling of materialization=on by default with main tree.
Diffstat (limited to 'mysql-test/r/myisam_icp.result')
| -rw-r--r-- | mysql-test/r/myisam_icp.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/myisam_icp.result b/mysql-test/r/myisam_icp.result index b73e98e2aea..f357247d384 100644 --- a/mysql-test/r/myisam_icp.result +++ b/mysql-test/r/myisam_icp.result @@ -763,8 +763,8 @@ t2.b NOT IN (SELECT t4.b FROM t3 STRAIGHT_JOIN t4 WHERE t4.b <= 2 AND t4.c = t3. id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 2 1 PRIMARY t2 ALL NULL NULL NULL NULL 2 Using where -2 DEPENDENT SUBQUERY t3 ALL NULL NULL NULL NULL 2 -2 DEPENDENT SUBQUERY t4 ref_or_null b b 5 func 2 Using where; Full scan on NULL key +2 SUBQUERY t3 ALL NULL NULL NULL NULL 2 +2 SUBQUERY t4 range b b 5 NULL 1 Using index condition; Using where; Rowid-ordered scan; Using join buffer (flat, BNL join) SELECT * FROM t1 LEFT JOIN t2 ON t1.c=t2.b WHERE t2.b NOT IN (SELECT t4.b FROM t3 STRAIGHT_JOIN t4 WHERE t4.b <= 2 AND t4.c = t3.c); |