← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/subselect_mat.result

  • Committer: Brian Aker
  • Date: 2010-02-03 21:54:38 UTC
  • mto: This revision was merged to the branch mainline in revision 1281.
  • Revision ID: brian@gaz-20100203215438-9ixkp214vio85mub
Fixing test cases/removed dead optimizer switches.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/subselect_mat.result
29
29
insert into t1i select * from t1;
30
30
insert into t2i select * from t2;
31
31
insert into t3i select * from t3;
32
 
set @@optimizer_switch=no_semijoin;
33
32
/********************************************************************
34
33
* Simple tests.
35
34
********************************************************************/
432
431
Test that BLOBs are not materialized (except when arguments of some functions).
433
432
*/
434
433
# force materialization to be always considered
435
 
set @@optimizer_switch=no_semijoin;
436
434
set @prefix_len = 6;
437
435
set @blob_len = 16;
438
436
set @suffix_len = @blob_len - @prefix_len;
842
840
/******************************************************************************
843
841
* Test the cache of the left operand of IN.
844
842
******************************************************************************/
845
 
set @@optimizer_switch=no_semijoin;
 
843
# Test that default values of Cached_item are not used for comparison
846
844
create temporary table t1 (s1 int) ENGINE=MyISAM;
847
845
create temporary table t2 (s2 int) ENGINE=MyISAM;
848
846
insert into t1 values (5),(1),(0);