1619.3.1
by Stewart Smith
add basic handler_write status variable test. Amazingly enough, this was *never* tested. |
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';
|
|
1619.3.2
by Stewart Smith
add handler_write status variable test for when statement was rolled back |
15 |
begin;
|
16 |
insert into t1 values (42);
|
|
17 |
rollback;
|
|
18 |
SHOW STATUS LIKE 'Handler_write';
|
|
1619.3.1
by Stewart Smith
add basic handler_write status variable test. Amazingly enough, this was *never* tested. |
19 |
DROP TABLE t1, t2;
|
20 |
SHOW STATUS LIKE 'Handler_write';
|
|
21 |
FLUSH STATUS;
|