← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/heap.result

  • Committer: Brian Aker
  • Date: 2010-02-19 01:53:48 UTC
  • mto: (1273.13.97 build)
  • mto: This revision was merged to the branch mainline in revision 1309.
  • Revision ID: brian@gaz-20100219015348-t1dv74unmbje8ndj
First pass through show indexs.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/heap.result
2
2
create temporary table t1 (a int not null,b int not null, primary key (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 keys from t1;
6
 
Table   Non_unique      Key_name        Seq_in_index    Column_name     Collation       Cardinality     Sub_part        Packed  Null    Index_type      Comment Index_Comment
7
 
t1      0       PRIMARY 1       a       NULL    3       NULL    NULL            HASH            
8
5
select * from t1;
9
6
a       b
10
7
2       2