diff options
| author | unknown <sanja@askmonty.org> | 2011-07-15 11:36:36 +0300 |
|---|---|---|
| committer | unknown <sanja@askmonty.org> | 2011-07-15 11:36:36 +0300 |
| commit | af284b55f0206d1b921692fa10a6374745d1d2eb (patch) | |
| tree | 1e89c7bf52a648d295cfbdd892af931ed26314ef /mysql-test/r/join_outer_jcl6.result | |
| parent | bf2844980300376262de43ae198d7aedfe9fae8e (diff) | |
| download | mariadb-git-af284b55f0206d1b921692fa10a6374745d1d2eb.tar.gz | |
Make subquery cache off by default.
mysql-test/r/subselect_scache.result:
Test with subquery cache on.
mysql-test/t/subselect_scache.test:
Test with subquery cache on.
Diffstat (limited to 'mysql-test/r/join_outer_jcl6.result')
| -rw-r--r-- | mysql-test/r/join_outer_jcl6.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/join_outer_jcl6.result b/mysql-test/r/join_outer_jcl6.result index 5aee435ad79..fdbc6021400 100644 --- a/mysql-test/r/join_outer_jcl6.result +++ b/mysql-test/r/join_outer_jcl6.result @@ -1446,7 +1446,7 @@ id select_type table type possible_keys key key_len ref rows filtered Extra 2 DEPENDENT SUBQUERY t4 eq_ref PRIMARY PRIMARY 4 test.t3.pk 1 100.00 Using where; Using index Warnings: Note 1276 Field or reference 'test.t2.pk' of SELECT #2 was resolved in SELECT #1 -Note 1003 select `test`.`t2`.`pk` AS `pk`,<expr_cache><`test`.`t2`.`pk`>((select (`test`.`t3`.`pk` + if(isnull(`test`.`t4`.`pk`),0,`test`.`t4`.`pk`)) from `test`.`t3` left join `test`.`t4` on((`test`.`t4`.`pk` = `test`.`t3`.`pk`)) where (`test`.`t3`.`pk` = (`test`.`t2`.`pk` + 1000)) limit 1)) AS `t` from `test`.`t1` join `test`.`t2` where ((`test`.`t2`.`pk` = (`test`.`t1`.`pk` + 1000)) and (`test`.`t1`.`pk` > 1000)) group by `test`.`t2`.`pk` +Note 1003 select `test`.`t2`.`pk` AS `pk`,(select (`test`.`t3`.`pk` + if(isnull(`test`.`t4`.`pk`),0,`test`.`t4`.`pk`)) from `test`.`t3` left join `test`.`t4` on((`test`.`t4`.`pk` = `test`.`t3`.`pk`)) where (`test`.`t3`.`pk` = (`test`.`t2`.`pk` + 1000)) limit 1) AS `t` from `test`.`t1` join `test`.`t2` where ((`test`.`t2`.`pk` = (`test`.`t1`.`pk` + 1000)) and (`test`.`t1`.`pk` > 1000)) group by `test`.`t2`.`pk` select t2.pk, (select t3.pk+if(isnull(t4.pk),0,t4.pk) from t3 left join t4 on t4.pk=t3.pk |