← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/handler_write.test

  • Committer: Brian Aker
  • Date: 2010-10-08 16:11:47 UTC
  • mto: This revision was merged to the branch mainline in revision 1834.
  • Revision ID: brian@tangent.org-20101008161147-o3us2a8itszsaycx
Typdef our lock type.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/handler_write.test
 
1
FLUSH STATUS;
 
2
SHOW STATUS LIKE 'Handler_write';
 
3
CREATE TABLE t1 (a int);
 
4
SHOW STATUS LIKE 'Handler_write';
 
5
INSERT INTO t1 VALUES (1);
 
6
SHOW STATUS LIKE 'Handler_write';
 
7
INSERT INTO t1 VALUES (1);
 
8
SHOW STATUS LIKE 'Handler_write';
 
9
INSERT INTO t1 VALUES (1),(2),(3),(4),(5);
 
10
SHOW STATUS LIKE 'Handler_write';
 
11
CREATE TABLE t2 LIKE t1;
 
12
SHOW STATUS LIKE 'Handler_write';
 
13
INSERT INTO t2 SELECT * FROM t1;
 
14
SHOW STATUS LIKE 'Handler_write';
 
15
begin;
 
16
insert into t1 values (42);
 
17
rollback;
 
18
SHOW STATUS LIKE 'Handler_write';
 
19
DROP TABLE t1, t2;
 
20
SHOW STATUS LIKE 'Handler_write';
 
21
FLUSH STATUS;