← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/heap_hash.test

  • Committer: Brian Aker
  • Date: 2008-10-02 19:18:43 UTC
  • mto: (438.4.1 drizzle-clean-code)
  • mto: This revision was merged to the branch mainline in revision 435.
  • Revision ID: brian@tangent.org-20081002191843-tw3nnufik8qwf9rz
Removed UNSIGNED from parser.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/heap_hash.test
65
65
select * from t1 where a=1;
66
66
drop table t1;
67
67
 
68
 
create table t1 (id int unsigned not null, primary key  using HASH (id)) engine=HEAP;
 
68
create table t1 (id int not null, primary key  using HASH (id)) engine=HEAP;
69
69
insert into t1 values(1);
70
70
select max(id) from t1; 
71
71
insert into t1 values(2);
196
196
 
197
197
# Btree and hash index use costs. 
198
198
create table t1 (
199
 
  id int unsigned not null primary key auto_increment, 
 
199
  id int not null primary key auto_increment, 
200
200
  name varchar(20) not null,
201
201
  index heap_idx(name),
202
202
  index btree_idx using btree(name)
203
203
) engine=heap;
204
204
 
205
205
create table t2 (
206
 
  id int unsigned not null primary key auto_increment, 
 
206
  id int not null primary key auto_increment, 
207
207
  name varchar(20) not null,
208
208
  index btree_idx using btree(name),
209
209
  index heap_idx(name)