diff options
| author | Igor Babaev <igor@askmonty.org> | 2017-06-22 00:41:44 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2017-06-22 22:06:03 -0700 |
| commit | 9f3622191df074d9f4e512320effe86f06b250fb (patch) | |
| tree | 16aadc76e982cb17349df79a381af23fec27b2f8 /mysql-test/r/derived.result | |
| parent | a8131e71f9504a7399bc9a7f312b14ed6700d099 (diff) | |
| download | mariadb-git-9f3622191df074d9f4e512320effe86f06b250fb.tar.gz | |
Fixed the bug mdev-12845.
This patch fills in a serious flaw in the
code that supports condition pushdown into
materialized views / derived tables.
If a predicate happened to contain a reference
to a mergeable view / derived table and it does
not depended directly on the target materialized
view / derived table then the predicate was not
considered as a subject to pusdown to this view
/ derived table.
Diffstat (limited to 'mysql-test/r/derived.result')
| -rw-r--r-- | mysql-test/r/derived.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index 8a7422ba5ec..722ff76e556 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -554,7 +554,7 @@ EXPLAIN SELECT * FROM (SELECT * FROM t1) AS table1, id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 system NULL NULL NULL NULL 1 1 PRIMARY <derived3> ref key0 key0 5 const 0 -3 DERIVED t2 ALL NULL NULL NULL NULL 2 Using temporary +3 DERIVED t2 ALL NULL NULL NULL NULL 2 Using where; Using temporary Warnings: Note 1249 Select 4 was reduced during optimization DROP TABLE t1, t2; |