← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/innodb.test

  • Committer: Brian Aker
  • Date: 2009-06-05 23:10:06 UTC
  • mto: This revision was merged to the branch mainline in revision 1055.
  • Revision ID: brian@gaz-20090605231006-01nyw7pfpj2z2v8p
Remove guts in parser for LOCK TABLE.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/innodb.test
482
482
drop table t1;
483
483
 
484
484
#
485
 
# Test lock tables
486
 
#
487
 
 
488
 
create table t1 (id int NOT NULL,id2 int NOT NULL,id3 int NOT NULL,dummy1 char(30),primary key (id,id2),index index_id3 (id3)) engine=innodb;
489
 
insert into t1 values (0,0,0,'ABCDEFGHIJ'),(2,2,2,'BCDEFGHIJK'),(1,1,1,'CDEFGHIJKL');
490
 
LOCK TABLES t1 WRITE;
491
 
--error ER_DUP_ENTRY
492
 
insert into t1 values (99,1,2,'D'),(1,1,2,'D');
493
 
select id from t1;
494
 
select id from t1;
495
 
UNLOCK TABLES;
496
 
DROP TABLE t1;
497
 
 
498
 
create table t1 (id int NOT NULL,id2 int NOT NULL,id3 int NOT NULL,dummy1 char(30),primary key (id,id2),index index_id3 (id3)) engine=innodb;
499
 
insert into t1 values (0,0,0,'ABCDEFGHIJ'),(2,2,2,'BCDEFGHIJK'),(1,1,1,'CDEFGHIJKL');
500
 
LOCK TABLES t1 WRITE;
501
 
begin;
502
 
--error ER_DUP_ENTRY
503
 
insert into t1 values (99,1,2,'D'),(1,1,2,'D');
504
 
select id from t1;
505
 
insert ignore into t1 values (100,1,2,'D'),(1,1,99,'D');
506
 
commit;
507
 
select id,id3 from t1;
508
 
UNLOCK TABLES;
509
 
DROP TABLE t1;
510
 
 
511
 
#
512
485
# Test prefix key
513
486
#
514
487
create table t1 (a char(20), unique (a(5))) engine=innodb;