diff options
| author | unknown <sanja@askmonty.org> | 2010-09-06 15:34:24 +0300 |
|---|---|---|
| committer | unknown <sanja@askmonty.org> | 2010-09-06 15:34:24 +0300 |
| commit | d6a9b52269c2f64a8f793c4680eed9adece0a716 (patch) | |
| tree | a5f6b2b18651a0641556d5c1d6a0e7f3908e8f09 /mysql-test/r/group_by.result | |
| parent | 08d1de3732e50529318d533d5d83811b910ab9e9 (diff) | |
| download | mariadb-git-d6a9b52269c2f64a8f793c4680eed9adece0a716.tar.gz | |
Fixed LP BUG#615760: Check on double cache assignment added into the transformation methods.
Cache parameters print added in EXPLAIN EXTENDED output.
mysql-test/r/compare.result:
Cache parameters print added in EXPLAIN EXTENDED output.
mysql-test/r/group_by.result:
Cache parameters print added in EXPLAIN EXTENDED output.
mysql-test/r/subselect.result:
Cache parameters print added in EXPLAIN EXTENDED output.
mysql-test/r/subselect3.result:
Cache parameters print added in EXPLAIN EXTENDED output.
mysql-test/r/subselect3_jcl6.result:
Cache parameters print added in EXPLAIN EXTENDED output.
mysql-test/r/subselect4.result:
Cache parameters print added in EXPLAIN EXTENDED output.
mysql-test/r/subselect_cache.result:
Added test suite for LP BUG#615760
mysql-test/r/subselect_mat.result:
Cache parameters print added in EXPLAIN EXTENDED output.
mysql-test/r/subselect_no_mat.result:
Cache parameters print added in EXPLAIN EXTENDED output.
mysql-test/r/subselect_no_opts.result:
Cache parameters print added in EXPLAIN EXTENDED output.
mysql-test/r/subselect_no_semijoin.result:
Cache parameters print added in EXPLAIN EXTENDED output.
mysql-test/r/subselect_sj.result:
Cache parameters print added in EXPLAIN EXTENDED output.
mysql-test/r/subselect_sj_jcl6.result:
Cache parameters print added in EXPLAIN EXTENDED output.
mysql-test/suite/pbxt/r/subselect.result:
Cache parameters print added in EXPLAIN EXTENDED output.
mysql-test/t/subselect_cache.test:
Cache parameters print added in EXPLAIN EXTENDED output.
sql/item.cc:
Item::set_expr_cache result fixed according to its description.
Cache parameters print added in EXPLAIN EXTENDED output.
sql/item.h:
Cache parameters print added in EXPLAIN EXTENDED output.
sql/item_cmpfunc.cc:
Check on double cache assignment added into the transformation methods.
sql/item_cmpfunc.h:
Check on double cache assignment added into the transformation methods.
sql/item_subselect.cc:
Check on double cache assignment added into the transformation methods.
sql/item_subselect.h:
Check on double cache assignment added into the transformation methods.
sql/sql_expression_cache.cc:
Cache parameters print added.
sql/sql_expression_cache.h:
Cache parameters print added.
sql/sql_select.cc:
Removed unused method (now it is impossible to make double transformation with the cache).
sql/sql_select.h:
Removed unused method.
Diffstat (limited to 'mysql-test/r/group_by.result')
| -rw-r--r-- | mysql-test/r/group_by.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 33ce0b034e6..d6f8c2d1e44 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -1742,7 +1742,7 @@ id select_type table type possible_keys key key_len ref rows filtered Extra 2 DEPENDENT SUBQUERY NULL NULL NULL NULL NULL NULL NULL NULL No tables used Warnings: Note 1276 Field or reference 'test.t1.a' of SELECT #2 was resolved in SELECT #1 -Note 1003 select <expr_cache>((select `test`.`t1`.`a`)) AS `aa`,count(distinct `test`.`t1`.`b`) AS `COUNT(DISTINCT b)` from `test`.`t1` group by (<expr_cache>((select `test`.`t1`.`a`)) + 0) +Note 1003 select <expr_cache><`test`.`t1`.`a`>((select `test`.`t1`.`a`)) AS `aa`,count(distinct `test`.`t1`.`b`) AS `COUNT(DISTINCT b)` from `test`.`t1` group by (<expr_cache><`test`.`t1`.`a`>((select `test`.`t1`.`a`)) + 0) EXPLAIN EXTENDED SELECT (SELECT t1.a) aa, COUNT(DISTINCT b) FROM t1 GROUP BY -aa; id select_type table type possible_keys key key_len ref rows filtered Extra @@ -1750,7 +1750,7 @@ id select_type table type possible_keys key key_len ref rows filtered Extra 2 DEPENDENT SUBQUERY NULL NULL NULL NULL NULL NULL NULL NULL No tables used Warnings: Note 1276 Field or reference 'test.t1.a' of SELECT #2 was resolved in SELECT #1 -Note 1003 select <expr_cache>((select `test`.`t1`.`a`)) AS `aa`,count(distinct `test`.`t1`.`b`) AS `COUNT(DISTINCT b)` from `test`.`t1` group by -(<expr_cache>((select `test`.`t1`.`a`))) +Note 1003 select <expr_cache><`test`.`t1`.`a`>((select `test`.`t1`.`a`)) AS `aa`,count(distinct `test`.`t1`.`b`) AS `COUNT(DISTINCT b)` from `test`.`t1` group by -(<expr_cache><`test`.`t1`.`a`>((select `test`.`t1`.`a`))) # should return only one record SELECT (SELECT tt.a FROM t1 tt LIMIT 1) aa, COUNT(DISTINCT b) FROM t1 GROUP BY aa; |