1# This tests the functionality of the Myisam engine
2# These testcases also exist in InnoDB engine
3# All tests are required to run with Myisam
4# Hence MTR starts mysqld with MyISAM as default
5
6--source include/force_myisam_default.inc
7--source include/have_myisam.inc
8
9#
10# MRR/MyISAM tests.
11# (Turns off all other 6.0 optimizer switches than MRR)
12#
13
14--source include/have_mrr.inc
15
16set optimizer_switch='mrr=on,mrr_cost_based=off';
17
18--disable_query_log
19if (`select locate('semijoin', @@optimizer_switch) > 0`)
20{
21  set optimizer_switch='semijoin=off';
22}
23if (`select locate('materialization', @@optimizer_switch) > 0`)
24{
25  set optimizer_switch='materialization=off';
26}
27if (`select locate('index_condition_pushdown', @@optimizer_switch) > 0`)
28{
29  set optimizer_switch='index_condition_pushdown=off';
30}
31--enable_query_log
32
33set @read_rnd_buffer_size_save= @@read_rnd_buffer_size;
34set read_rnd_buffer_size=79;
35select @@read_rnd_buffer_size;
36
37-- source include/mrr_tests.inc
38
39set @@read_rnd_buffer_size= @read_rnd_buffer_size_save;
40set optimizer_switch=default;
41
42