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