diff options
| author | unknown <sanja@askmonty.org> | 2010-08-31 16:16:10 +0300 |
|---|---|---|
| committer | unknown <sanja@askmonty.org> | 2010-08-31 16:16:10 +0300 |
| commit | 97199ad56d7eeb69c54ad66a5a0ed675567b5e8d (patch) | |
| tree | 67ae0af544af7f42ee614d1f6e6d4b27e2fd5df0 /mysql-test/r/compare.result | |
| parent | f5ecf70819978199c7dfdfcf3dfbdfb1988f3089 (diff) | |
| download | mariadb-git-97199ad56d7eeb69c54ad66a5a0ed675567b5e8d.tar.gz | |
LP BUG#615752 fix. Expression cache added to EXPLAIN EXTENDED output.
mysql-test/r/compare.result:
Expression cache added to EXPLAIN EXTENDED output.
mysql-test/r/explain.result:
Expression cache added to EXPLAIN EXTENDED output.
mysql-test/r/group_by.result:
Expression cache added to EXPLAIN EXTENDED output.
mysql-test/r/subselect.result:
Expression cache added to EXPLAIN EXTENDED output.
mysql-test/r/subselect3.result:
Expression cache added to EXPLAIN EXTENDED output.
mysql-test/r/subselect3_jcl6.result:
Expression cache added to EXPLAIN EXTENDED output.
mysql-test/r/subselect4.result:
Expression cache added to EXPLAIN EXTENDED output.
mysql-test/r/subselect_mat.result:
Expression cache added to EXPLAIN EXTENDED output.
mysql-test/r/subselect_no_mat.result:
Expression cache added to EXPLAIN EXTENDED output.
mysql-test/r/subselect_no_opts.result:
Expression cache added to EXPLAIN EXTENDED output.
mysql-test/r/subselect_no_semijoin.result:
Expression cache added to EXPLAIN EXTENDED output.
mysql-test/r/subselect_sj.result:
Expression cache added to EXPLAIN EXTENDED output.
mysql-test/r/subselect_sj_jcl6.result:
Expression cache added to EXPLAIN EXTENDED output.
sql/item.h:
Expression cache added to EXPLAIN EXTENDED output.
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..ffebc0c2772 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>((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()); |