diff options
Diffstat (limited to 'mysql-test/suite/gcol/inc/gcol_select.inc')
-rw-r--r-- | mysql-test/suite/gcol/inc/gcol_select.inc | 37 |
1 files changed, 23 insertions, 14 deletions
diff --git a/mysql-test/suite/gcol/inc/gcol_select.inc b/mysql-test/suite/gcol/inc/gcol_select.inc index efaffd5168d..1f54b2bb3ae 100644 --- a/mysql-test/suite/gcol/inc/gcol_select.inc +++ b/mysql-test/suite/gcol/inc/gcol_select.inc @@ -1,17 +1,22 @@ -################################################################################ -# inc/gcol_select.inc # -# # -# Purpose: # -# Testing different SELECTs. # -# # -# # -#------------------------------------------------------------------------------# -# Original Author: Andrey Zhakov # -# Original Date: 2008-09-18 # -# Change Author: # -# Change Date: # -# Change: # -################################################################################ +############################################################################## +# inc/gcol_select.inc # +# # +# Purpose: # +# Testing different SELECTs. # +# # +# # +#----------------------------------------------------------------------------# +# Original Author: Andrey Zhakov # +# Original Date: 2008-09-18 # +# Change Author: # +# Change Date: # +# Change: # +############################################################################## + +--disable_query_log +set @local_optimizer_switch=@@optimizer_switch; +set optimizer_switch='derived_merge=off,join_cache_hashed=off'; +--enable_query_log # Table t1 is used below to test: # - Join type of ALL (sequential scan of the entire table) @@ -1161,3 +1166,7 @@ eval EXPLAIN $query; eval $query; DROP TABLE t1, t2, t3, t4; + +--disable_query_log +set @@optimizer_switch=@local_optimizer_switch; +--enable_query_log |