diff options
| author | unknown <sanja@askmonty.org> | 2011-10-05 18:18:00 +0300 |
|---|---|---|
| committer | unknown <sanja@askmonty.org> | 2011-10-05 18:18:00 +0300 |
| commit | 54caeee5d6bc06be4cc451aef49ee0a4f7655ce2 (patch) | |
| tree | 6c73d0fa9a55cd2f205b2fb58cc4c4f8325f45f7 /mysql-test/r/compare.result | |
| parent | f40f0ff679471948a6366ddfad9377b83abdf345 (diff) | |
| download | mariadb-git-54caeee5d6bc06be4cc451aef49ee0a4f7655ce2.tar.gz | |
Making subquery cache on by default.
Diffstat (limited to 'mysql-test/r/compare.result')
| -rw-r--r-- | mysql-test/r/compare.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/compare.result b/mysql-test/r/compare.result index 796821a87bd..75a6a38fadc 100644 --- a/mysql-test/r/compare.result +++ b/mysql-test/r/compare.result @@ -88,7 +88,7 @@ id select_type table type possible_keys key key_len ref rows filtered Extra Warnings: Note 1276 Field or reference 'test.t2.a' of SELECT #2 was resolved in SELECT #1 Note 1276 Field or reference 'test.t2.a' of SELECT #2 was resolved in SELECT #1 -Note 1003 select `test`.`t2`.`a` AS `a`,(select count(0) from `test`.`t1` where ((`test`.`t1`.`b` = `test`.`t2`.`a`) and (concat(`test`.`t1`.`b`,`test`.`t1`.`c`) = concat('0',`test`.`t2`.`a`,'01')))) AS `x` from `test`.`t2` order by `test`.`t2`.`a` +Note 1003 select `test`.`t2`.`a` AS `a`,<expr_cache><`test`.`t2`.`a`>((select count(0) from `test`.`t1` where ((`test`.`t1`.`b` = `test`.`t2`.`a`) and (concat(`test`.`t1`.`b`,`test`.`t1`.`c`) = concat('0',`test`.`t2`.`a`,'01'))))) AS `x` from `test`.`t2` order by `test`.`t2`.`a` DROP TABLE t1,t2; CREATE TABLE t1 (a TIMESTAMP); INSERT INTO t1 VALUES (NOW()),(NOW()),(NOW()); |