Re: [Maria-developers] [Commits] 9ed264a391b160ef84121c8699bb3ff61c0059ce Fixed bug mdev-11072. In a general case the conditions with outer fields cannot be pushed into materialized views / derived tables. However if the outer field in the condition refers to a single row table then the condition may be pushable. In this case a special care should be taken for outer fields when pushing the condition into a materialized view / derived table.

15 Nov 2016


      Hi, Igor!

On 11/15/2016 08:23 AM, Igor Babaev wrote:
...
commit 9ed264a391b160ef84121c8699bb3ff61c0059ce
Author: Igor Babaev <igor@askmonty.org>
Commit: Igor Babaev <igor@askmonty.org>
Fixed bug mdev-11072.
     In a general case the conditions with outer fields cannot
     be pushed into materialized views / derived tables.
     However if the outer field in the condition refers to a
     single row table then the condition may be pushable.
     In this case a special care should be taken for outer
     fields when pushing the condition into a materialized view /
     derived table.
Thank you a lot, OK to push!

[skip]

Oleksandr Byelkin