← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/include/mix2.inc

  • 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/include/mix2.inc
565
565
drop table t1;
566
566
 
567
567
#
568
 
# Test lock tables
569
 
#
570
 
 
571
 
eval 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=$engine_type;
572
 
insert into t1 values (0,0,0,'ABCDEFGHIJ'),(2,2,2,'BCDEFGHIJK'),(1,1,1,'CDEFGHIJKL');
573
 
LOCK TABLES t1 WRITE;
574
 
--error ER_DUP_ENTRY
575
 
insert into t1 values (99,1,2,'D'),(1,1,2,'D');
576
 
select id from t1;
577
 
select id from t1;
578
 
UNLOCK TABLES;
579
 
DROP TABLE t1;
580
 
 
581
 
eval 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=$engine_type;
582
 
insert into t1 values (0,0,0,'ABCDEFGHIJ'),(2,2,2,'BCDEFGHIJK'),(1,1,1,'CDEFGHIJKL');
583
 
LOCK TABLES t1 WRITE;
584
 
begin;
585
 
--error ER_DUP_ENTRY
586
 
insert into t1 values (99,1,2,'D'),(1,1,2,'D');
587
 
select id from t1;
588
 
insert ignore into t1 values (100,1,2,'D'),(1,1,99,'D');
589
 
commit;
590
 
select id,id3 from t1;
591
 
UNLOCK TABLES;
592
 
DROP TABLE t1;
593
 
 
594
 
#
595
568
# Test prefix key
596
569
#
597
570
eval create table t1 (a char(20), unique (a(5))) engine=$engine_type;