← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/heap_hash.result

  • Committer: Brian Aker
  • Date: 2010-02-23 22:10:47 UTC
  • mto: (1273.13.97 build)
  • mto: This revision was merged to the branch mainline in revision 1309.
  • Revision ID: brian@gaz-20100223221047-uehdt5fcwx1z3c9p
Enabled more tests.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/heap_hash.result
2
2
create temporary table t1 (a int not null,b int not null, primary key using HASH (a)) engine=MEMORY comment="testing heaps";
3
3
insert into t1 values(1,1),(2,2),(3,3),(4,4);
4
4
delete from t1 where a=1 or a=0;
 
5
show table status like "t1";
 
6
Name    Engine  Version Row_format      Rows    Avg_row_length  Data_length     Max_data_length Index_length    Data_free       Auto_increment  Create_time     Update_time     Check_time      Collation       Checksum        Create_options  Comment
 
7
t1      MEMORY  0       DEFAULT 0       0       0       0       0       0       0       0       0       0       utf8_general_ci 0               
 
8
show keys from t1;
 
9
Table   Key_name        Seq_in_index    Column_name
 
10
t1      PRIMARY 0       a
5
11
select * from t1;
6
12
a       b
7
13
2       2
29
35
create temporary table t1 (a int not null,b int not null, primary key using HASH (a)) engine=MEMORY comment="testing heaps";
30
36
insert into t1 values(1,1),(2,2),(3,3),(4,4);
31
37
alter table t1 modify a int not null auto_increment, engine=innodb, comment="new innodb table";
 
38
show table status like "t1";
 
39
Name    Engine  Version Row_format      Rows    Avg_row_length  Data_length     Max_data_length Index_length    Data_free       Auto_increment  Create_time     Update_time     Check_time      Collation       Checksum        Create_options  Comment
 
40
t1      InnoDB  0       DEFAULT 0       0       0       0       0       0       0       0       0       0       utf8_general_ci 0               
32
41
select * from t1;
33
42
a       b
34
43
1       1
316
325
explain select * from t1 ignore index (btree_idx) where name='matt';
317
326
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
318
327
1       SIMPLE  t1      ref     heap_idx        heap_idx        82      const   9       Using where
 
328
show index from t1;
 
329
Table   Key_name        Seq_in_index    Column_name
 
330
t1      PRIMARY 0       id
 
331
t1      heap_idx        0       name
 
332
t1      btree_idx       0       name
 
333
show index from t1;
 
334
Table   Key_name        Seq_in_index    Column_name
 
335
t1      PRIMARY 0       id
 
336
t1      heap_idx        0       name
 
337
t1      btree_idx       0       name
319
338
create temporary table t3
320
339
(
321
340
a varchar(20) not null,
323
342
key (a,b)
324
343
) engine=MEMORY;
325
344
insert into t3 select name, name from t1;
 
345
show index from t3;
 
346
Table   Key_name        Seq_in_index    Column_name
 
347
t3      a       0       a
 
348
t3      a       1       b
 
349
show index from t3;
 
350
Table   Key_name        Seq_in_index    Column_name
 
351
t3      a       0       a
 
352
t3      a       1       b
326
353
explain select * from t1 ignore key(btree_idx), t3 where t1.name='matt' and t3.a = concat('',t1.name) and t3.b=t1.name;
327
354
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
328
355
1       SIMPLE  t1      ref     heap_idx        heap_idx        82      const   9       Using where