|
1324.1.1
by Jay Pipes
Fixes Bug #535296 by only incrementing ha_commit_count when its a normal transaction commit. |
1 |
SET AUTOCOMMIT= 0;
|
2 |
SHOW STATUS LIKE 'Handler_commit%';
|
|
3 |
Variable_name Value
|
|
4 |
Handler_commit 0
|
|
5 |
BEGIN;
|
|
6 |
SHOW STATUS LIKE 'Handler_commit%';
|
|
7 |
Variable_name Value
|
|
8 |
Handler_commit 0
|
|
9 |
DROP SCHEMA IF EXISTS boundaries;
|
|
10 |
Warnings:
|
|
|
1354.1.1
by Brian Aker
Modify ptr to reference. |
11 |
Note 1008 Can't drop database 'boundaries'; database doesn't exist
|
|
1324.1.1
by Jay Pipes
Fixes Bug #535296 by only incrementing ha_commit_count when its a normal transaction commit. |
12 |
SHOW STATUS LIKE 'Handler_commit%';
|
13 |
Variable_name Value
|
|
14 |
Handler_commit 1
|
|
15 |
COMMIT;
|
|
16 |
SHOW STATUS LIKE 'Handler_commit%';
|
|
17 |
Variable_name Value
|
|
18 |
Handler_commit 1
|
|
|
1339
by Brian Aker
Jay + extended test case. |
19 |
SET AUTOCOMMIT= 1;
|
20 |
SHOW STATUS LIKE 'Handler_commit%';
|
|
21 |
Variable_name Value
|
|
22 |
Handler_commit 1
|
|
23 |
BEGIN;
|
|
24 |
DROP SCHEMA IF EXISTS boundaries;
|
|
25 |
Warnings:
|
|
|
1354.1.1
by Brian Aker
Modify ptr to reference. |
26 |
Note 1008 Can't drop database 'boundaries'; database doesn't exist
|
|
1339
by Brian Aker
Jay + extended test case. |
27 |
COMMIT;
|
28 |
SHOW STATUS LIKE 'Handler_commit%';
|
|
29 |
Variable_name Value
|
|
30 |
Handler_commit 2
|
|
31 |
CREATE TABLE commit_test (a int);
|
|
32 |
SHOW STATUS LIKE 'Handler_commit%';
|
|
33 |
Variable_name Value
|
|
34 |
Handler_commit 2
|
|
35 |
INSERT into commit_test VALUES (10);
|
|
36 |
SHOW STATUS LIKE 'Handler_commit%';
|
|
37 |
Variable_name Value
|
|
38 |
Handler_commit 2
|
|
39 |
INSERT into commit_test VALUES (10), (20);
|
|
40 |
SHOW STATUS LIKE 'Handler_commit%';
|
|
41 |
Variable_name Value
|
|
42 |
Handler_commit 2
|
|
43 |
INSERT into commit_test VALUES (10);
|
|
44 |
SHOW STATUS LIKE 'Handler_commit%';
|
|
45 |
Variable_name Value
|
|
46 |
Handler_commit 2
|
|
47 |
BEGIN;
|
|
48 |
INSERT into commit_test VALUES (10);
|
|
49 |
SHOW STATUS LIKE 'Handler_commit%';
|
|
50 |
Variable_name Value
|
|
51 |
Handler_commit 2
|
|
52 |
COMMIT;
|
|
53 |
SHOW STATUS LIKE 'Handler_commit%';
|
|
54 |
Variable_name Value
|
|
55 |
Handler_commit 3
|
|
56 |
BEGIN;
|
|
57 |
INSERT into commit_test VALUES (10);
|
|
58 |
SHOW STATUS LIKE 'Handler_commit%';
|
|
59 |
Variable_name Value
|
|
60 |
Handler_commit 3
|
|
61 |
ROLLBACK;
|
|
62 |
SHOW STATUS LIKE 'Handler_commit%';
|
|
63 |
Variable_name Value
|
|
64 |
Handler_commit 3
|
|
65 |
BEGIN;
|
|
66 |
INSERT into commit_test VALUES (10);
|
|
67 |
SHOW STATUS LIKE 'Handler_commit%';
|
|
68 |
Variable_name Value
|
|
69 |
Handler_commit 3
|
|
70 |
COMMIT;
|
|
71 |
SHOW STATUS LIKE 'Handler_commit%';
|
|
72 |
Variable_name Value
|
|
73 |
Handler_commit 4
|
|
74 |
SET AUTOCOMMIT= 0;
|
|
75 |
INSERT into commit_test VALUES (10);
|
|
76 |
INSERT into commit_test VALUES (10);
|
|
77 |
SHOW STATUS LIKE 'Handler_commit%';
|
|
78 |
Variable_name Value
|
|
79 |
Handler_commit 4
|
|
80 |
drop table commit_test;
|
|
81 |
SHOW STATUS LIKE 'Handler_commit%';
|
|
82 |
Variable_name Value
|
|
83 |
Handler_commit 5
|