diff options
| author | unknown <igor@olga.mysql.com> | 2007-04-20 17:47:14 -0700 |
|---|---|---|
| committer | unknown <igor@olga.mysql.com> | 2007-04-20 17:47:14 -0700 |
| commit | f335e7e4bbbcedd4e3e5b6b10b661472db960381 (patch) | |
| tree | e71f0cd1a66eb8f133c2c9834c8860c619e061d7 /mysql-test/r/subselect3.result | |
| parent | efe42b3857359d904786caff45d3cc226858935f (diff) | |
| download | mariadb-git-f335e7e4bbbcedd4e3e5b6b10b661472db960381.tar.gz | |
Post-merge fix.
Diffstat (limited to 'mysql-test/r/subselect3.result')
| -rw-r--r-- | mysql-test/r/subselect3.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/subselect3.result b/mysql-test/r/subselect3.result index 981f59e9787..657d95b7ee3 100644 --- a/mysql-test/r/subselect3.result +++ b/mysql-test/r/subselect3.result @@ -698,10 +698,10 @@ INSERT INTO t1 VALUES (1), (NULL), (4); INSERT INTO t2 VALUES (3), (1),(2), (5), (4), (7), (6); EXPLAIN EXTENDED SELECT a FROM t1, t2 WHERE a=b AND (b NOT IN (SELECT a FROM t1)); -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t1 ALL NULL NULL NULL NULL 3 Using where -1 PRIMARY t2 eq_ref PRIMARY PRIMARY 4 test.t1.a 1 Using index -2 DEPENDENT SUBQUERY t1 ALL NULL NULL NULL NULL 3 Using where +id select_type table type possible_keys key key_len ref rows filtered Extra +1 PRIMARY t1 ALL NULL NULL NULL NULL 3 100.00 Using where +1 PRIMARY t2 eq_ref PRIMARY PRIMARY 4 test.t1.a 1 100.00 Using index +2 DEPENDENT SUBQUERY t1 ALL NULL NULL NULL NULL 3 100.00 Using where Warnings: Note 1003 select `test`.`t1`.`a` AS `a` from `test`.`t1` join `test`.`t2` where ((`test`.`t2`.`b` = `test`.`t1`.`a`) and (not(<in_optimizer>(`test`.`t1`.`a`,<exists>(select 1 AS `Not_used` from `test`.`t1` where ((<cache>(`test`.`t2`.`b`) = `test`.`t1`.`a`) or isnull(`test`.`t1`.`a`)) having <is_not_null_test>(`test`.`t1`.`a`)))))) SELECT a FROM t1, t2 WHERE a=b AND (b NOT IN (SELECT a FROM t1)); |