1# The include statement below is a temp one for tests that are yet to 2#be ported to run with InnoDB, 3#but needs to be kept for tests that would need MyISAM in future. 4--source include/force_myisam_default.inc 5--source include/no_valgrind_without_big.inc 6 7# 8# Run order_by.inc without any of the socalled 6.0 features. 9# 10 11--disable_query_log 12if (`select locate('semijoin', @@optimizer_switch) > 0`) 13{ 14 set optimizer_switch='semijoin=off'; 15} 16if (`select locate('materialization', @@optimizer_switch) > 0`) 17{ 18 set optimizer_switch='materialization=off'; 19} 20if (`select locate('index_condition_pushdown', @@optimizer_switch) > 0`) 21{ 22 set optimizer_switch='index_condition_pushdown=off'; 23} 24if (`select locate('mrr', @@optimizer_switch) > 0`) 25{ 26 set optimizer_switch='mrr=off'; 27} 28--enable_query_log 29 30--source include/order_by.inc 31 32set optimizer_switch=default; 33 34