diff options
author | Galina Shalygina <galina.shalygina@mariadb.com> | 2017-12-17 21:25:48 +0200 |
---|---|---|
committer | Galina Shalygina <galina.shalygina@mariadb.com> | 2017-12-18 15:51:27 +0200 |
commit | 3791d0cfcf62b49b6f6f1f5aae7cd52f2bf9adcd (patch) | |
tree | 4f145f1c5b903dcc2957b7f59469295b17199a3c | |
parent | 86308aa9953a72d94efde2381de98cb10f18ca09 (diff) | |
download | mariadb-git-bb-10.3-mdev14579.tar.gz |
Test result changedbb-10.3-mdev14579
-rw-r--r-- | mysql-test/r/derived_cond_pushdown.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/derived_cond_pushdown.result b/mysql-test/r/derived_cond_pushdown.result index f7a0430f070..41c8c51a09b 100644 --- a/mysql-test/r/derived_cond_pushdown.result +++ b/mysql-test/r/derived_cond_pushdown.result @@ -10443,7 +10443,7 @@ EXPLAIN } drop view v1; create table t3 (a int, b int, c int); -insert into t3 values +insert into t3 values (1,21,345), (2,33,7), (8,33,114), (3,21,500), (1,19,107), (5,14,787), (4,33,123), (9,10,211), (11,16,207), (10,33,988), (5,27,132), (12,21,104), (6,20,309), (16,20,315), (16,21,101), (18,33,404), (19,10,800), (10,21,123), @@ -10451,7 +10451,7 @@ insert into t3 values create index i1 on t3(a); # conjunctive subformulas : pushing into WHERE # pushed condition gives range access -create view v1 as +create view v1 as select a, b, max(c) as max_c from t3 where a>0 group by a; set statement optimizer_switch='condition_pushdown_for_derived=off' for select * from v1,t2 where (v1.b=t2.b) and (v1.a<5); |