summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGalina Shalygina <galina.shalygina@mariadb.com>2017-12-17 21:25:48 +0200
committerGalina Shalygina <galina.shalygina@mariadb.com>2017-12-18 15:51:27 +0200
commit3791d0cfcf62b49b6f6f1f5aae7cd52f2bf9adcd (patch)
tree4f145f1c5b903dcc2957b7f59469295b17199a3c
parent86308aa9953a72d94efde2381de98cb10f18ca09 (diff)
downloadmariadb-git-bb-10.3-mdev14579.tar.gz
Test result changedbb-10.3-mdev14579
-rw-r--r--mysql-test/r/derived_cond_pushdown.result4
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);