← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/subselect_mat.test

  • Committer: Monty Taylor
  • Date: 2010-02-05 08:11:15 UTC
  • mfrom: (1283 build)
  • mto: (1273.13.43 fix_is)
  • mto: This revision was merged to the branch mainline in revision 1300.
  • Revision ID: mordred@inaugust.com-20100205081115-dr82nvrwv4lvw7sd
Merged trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/subselect_mat.test
46
46
insert into t2i select * from t2;
47
47
insert into t3i select * from t3;
48
48
 
49
 
# force the use of materialization
50
 
set @@optimizer_switch=no_semijoin;
51
 
 
52
49
--echo /********************************************************************
53
50
--echo  * Simple tests.
54
51
--echo  ********************************************************************/
289
286
  Test that BLOBs are not materialized (except when arguments of some functions).
290
287
*/
291
288
# force materialization to be always considered
292
 
set @@optimizer_switch=no_semijoin;
293
289
set @prefix_len = 6;
294
290
 
295
291
# BLOB == 16 (small blobs that could be stored in MEMORY tables)
634
630
/******************************************************************************
635
631
* Test the cache of the left operand of IN.
636
632
******************************************************************************/
637
 
set @@optimizer_switch=no_semijoin;
638
 
 
639
633
# Test that default values of Cached_item are not used for comparison
640
634
create temporary table t1 (s1 int) ENGINE=MyISAM;
641
635
create temporary table t2 (s2 int) ENGINE=MyISAM;