← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/include/index_merge2.inc

  • Committer: Stewart Smith
  • Date: 2009-06-16 03:01:29 UTC
  • mto: This revision was merged to the branch mainline in revision 1094.
  • Revision ID: stewart@flamingspork.com-20090616030129-rgsuzf31x56wmkho
Fix index_merge2.inc for myisam temp only. Needs to be non-myisam table as there are queries which require opening the table multiple times

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/include/index_merge2.inc
112
112
  index i1(key1a, key1b),
113
113
  index i2(key2a, key2b),
114
114
  index i3(key3a, key3b)
115
 
) ENGINE=myisam;
 
115
);
116
116
 
117
117
create table t2 (a int);
118
118
insert into t2 values (0),(1),(2),(3),(4),(NULL);
126
126
analyze table t1;
127
127
select count(*) from t1;
128
128
 
 
129
--replace_column 9 #
129
130
explain select count(*) from t1 where
130
131
  key1a = 2 and key1b is null and  key2a = 2 and key2b is null;
131
132
 
132
133
select count(*) from t1 where
133
134
  key1a = 2 and key1b is null and key2a = 2 and key2b is null;
134
135
 
 
136
--replace_column 9 #
135
137
explain select count(*) from t1 where
136
138
  key1a = 2 and key1b is null and key3a = 2 and key3b is null;
137
139