diff options
Diffstat (limited to '')
| -rw-r--r-- | mysql-test/include/icp_tests.inc | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/mysql-test/include/icp_tests.inc b/mysql-test/include/icp_tests.inc index d7fa6b5d..e42645fa 100644 --- a/mysql-test/include/icp_tests.inc +++ b/mysql-test/include/icp_tests.inc @@ -487,7 +487,7 @@ CREATE TABLE t1 ( ); INSERT INTO t1 VALUES (1,9),(2,7),(3,6),(4,3),(5,1); - +insert into t1 select seq,seq from seq_100_to_110; EXPLAIN SELECT pk, c1 FROM t1 WHERE (pk<3 or pk>3); SET SESSION optimizer_switch='index_condition_pushdown=off'; @@ -724,7 +724,6 @@ DROP TABLE t1; CREATE TABLE t1 (b int NOT NULL, c int, a varchar(1024), PRIMARY KEY (b)); INSERT INTO t1 VALUES (1,4,'Ill'); -insert into t1 select seq+100,5,seq from seq_1_to_100; CREATE TABLE t2 (a varchar(1024), KEY (a(512))); INSERT INTO t2 VALUES @@ -858,6 +857,8 @@ ANALYZE TABLE t1,t2; SET @save_optimize_switch=@@optimizer_switch; SET optimizer_switch='materialization=on'; +set @save_optimizer_where_cost=@@optimizer_where_cost; +set @@optimizer_where_cost=1; EXPLAIN SELECT COUNT(*) FROM t1 AS t, t2 @@ -875,6 +876,7 @@ WHERE c = g OR a = 0 AND h < 'z' ); SET optimizer_switch=@save_optimizer_switch; +set @@optimizer_where_cost=@save_optimizer_where_cost; DROP TABLE t1,t2; |