|
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 |
Variable_name Value
|
|
4 |
Handler_write 0
|
|
5 |
CREATE TABLE t1 (a int);
|
|
6 |
SHOW STATUS LIKE 'Handler_write';
|
|
7 |
Variable_name Value
|
|
8 |
Handler_write 0
|
|
9 |
INSERT INTO t1 VALUES (1);
|
|
10 |
SHOW STATUS LIKE 'Handler_write';
|
|
11 |
Variable_name Value
|
|
12 |
Handler_write 1
|
|
13 |
INSERT INTO t1 VALUES (1);
|
|
14 |
SHOW STATUS LIKE 'Handler_write';
|
|
15 |
Variable_name Value
|
|
16 |
Handler_write 2
|
|
17 |
INSERT INTO t1 VALUES (1),(2),(3),(4),(5);
|
|
18 |
SHOW STATUS LIKE 'Handler_write';
|
|
19 |
Variable_name Value
|
|
20 |
Handler_write 7
|
|
21 |
CREATE TABLE t2 LIKE t1;
|
|
22 |
SHOW STATUS LIKE 'Handler_write';
|
|
23 |
Variable_name Value
|
|
24 |
Handler_write 7
|
|
25 |
INSERT INTO t2 SELECT * FROM t1;
|
|
26 |
SHOW STATUS LIKE 'Handler_write';
|
|
27 |
Variable_name Value
|
|
28 |
Handler_write 14
|
|
|
1619.3.2
by Stewart Smith
add handler_write status variable test for when statement was rolled back |
29 |
begin;
|
30 |
insert into t1 values (42);
|
|
31 |
rollback;
|
|
32 |
SHOW STATUS LIKE 'Handler_write';
|
|
33 |
Variable_name Value
|
|
34 |
Handler_write 15
|
|
|
1619.3.1
by Stewart Smith
add basic handler_write status variable test. Amazingly enough, this was *never* tested. |
35 |
DROP TABLE t1, t2;
|
36 |
SHOW STATUS LIKE 'Handler_write';
|
|
37 |
Variable_name Value
|
|
|
1619.3.2
by Stewart Smith
add handler_write status variable test for when statement was rolled back |
38 |
Handler_write 15
|
|
1619.3.1
by Stewart Smith
add basic handler_write status variable test. Amazingly enough, this was *never* tested. |
39 |
FLUSH STATUS;
|