26 lines
750 B
Plaintext
26 lines
750 B
Plaintext
# This tests the functionality of the Myisam engine
|
|
# These testcases also exist in InnoDB engine
|
|
# All tests are required to run with Myisam
|
|
# Hence MTR starts mysqld with MyISAM as default
|
|
|
|
--source include/force_myisam_default.inc
|
|
--source include/have_myisam.inc
|
|
|
|
#
|
|
# MRR/MyISAM tests.
|
|
# (Runs with all 6.0 optimizer switches on)
|
|
#
|
|
|
|
set optimizer_switch='semijoin=on,materialization=on,firstmatch=on,loosescan=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=off';
|
|
|
|
set @read_rnd_buffer_size_save= @@read_rnd_buffer_size;
|
|
set read_rnd_buffer_size=79;
|
|
select @@read_rnd_buffer_size;
|
|
|
|
-- source include/mrr_tests.inc
|
|
-- source include/mrr_myisam_tests.inc
|
|
|
|
set @@read_rnd_buffer_size= @read_rnd_buffer_size_save;
|
|
set optimizer_switch=default;
|
|
|