maria-developers team mailing list archive

Thread
Date

Re: [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.

To: maria-developers@xxxxxxxxxxxxxxxxxxx, commits@xxxxxxxxxxx, igor@xxxxxxxxxxxx
From: Oleksandr Byelkin <sanja@xxxxxxxxxxxxxxxx>
Date: Tue, 15 Nov 2016 13:13:49 +0100
In-reply-to: <20161115072337.04E24281B49@sophia.site>
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.4.0

Hi, Igor!

On 11/15/2016 08:23 AM, Igor Babaev wrote:

commit 9ed264a391b160ef84121c8699bb3ff61c0059ce
Author: Igor Babaev <igor@xxxxxxxxxxxx>
Commit: Igor Babaev <igor@xxxxxxxxxxxx>

     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]