[Commits] 385f431: Corrected the test case of MDEV-25714 in order to have the same EXPLAIN output as in 10.3

IgorBabaev igor at mariadb.com
Fri Jun 4 06:43:04 EEST 2021


revision-id: 385f4316c3b8250943383145c115000ee153e3de (mariadb-10.4.11-639-g385f431)
parent(s): 0b797130c674a4dd8b8dcf35d3ade38353e19284
author: Igor Babaev
committer: Igor Babaev
timestamp: 2021-06-03 20:43:04 -0700
message:

Corrected the test case of MDEV-25714 in order to have the same EXPLAIN output as in 10.3

---
 mysql-test/main/derived_split_innodb.result | 4 ++++
 mysql-test/main/derived_split_innodb.test   | 4 ++++
 2 files changed, 8 insertions(+)

diff --git a/mysql-test/main/derived_split_innodb.result b/mysql-test/main/derived_split_innodb.result
index 6119145..63db8c9 100644
--- a/mysql-test/main/derived_split_innodb.result
+++ b/mysql-test/main/derived_split_innodb.result
@@ -190,6 +190,8 @@ id int not null, itemid int not null, userid int not null, primary key (id),
 index idx1 (userid, itemid), index idx2 (itemid)
 ) engine innodb;
 insert into t3 values (1,1,1), (2,1,1), (3,2,1), (4,2,1), (5,3,1);
+set use_stat_tables='never';
+set optimizer_use_condition_selectivity=1;
 analyze table t1,t2,t3;
 Table	Op	Msg_type	Msg_text
 test.t1	analyze	status	OK
@@ -235,4 +237,6 @@ id	itemid	id	id
 4	2	4	2
 drop table t1,t2,t3;
 set optimizer_switch='split_materialized=default';
+set use_stat_tables=default;
+set optimizer_use_condition_selectivity=default;
 # End of 10.3 tests
diff --git a/mysql-test/main/derived_split_innodb.test b/mysql-test/main/derived_split_innodb.test
index 6f33c71..22793b4 100644
--- a/mysql-test/main/derived_split_innodb.test
+++ b/mysql-test/main/derived_split_innodb.test
@@ -166,6 +166,8 @@ create table t3 (
   index idx1 (userid, itemid), index idx2 (itemid)
 ) engine innodb;
 insert into t3 values (1,1,1), (2,1,1), (3,2,1), (4,2,1), (5,3,1);
+set use_stat_tables='never';
+set optimizer_use_condition_selectivity=1;
 analyze table t1,t2,t3;
 
 let $q=
@@ -185,5 +187,7 @@ eval $q;
 
 drop table t1,t2,t3;
 set optimizer_switch='split_materialized=default';
+set use_stat_tables=default;
+set optimizer_use_condition_selectivity=default;
 
 --echo # End of 10.3 tests


More information about the commits mailing list