1 Case
1: create table t1
,test for SET AUTOCOMMIT OFF and some records
2 [Parser
: syntax error
] SET
3 [Parser
: syntax error
] commiter
4 [Parser
: syntax error
] rollbacked
5 [Parser
: syntax error
] show
6 [Parser
: syntax error
] SET
7 echo create table t1
(f1 int
,f2 int
);
9 echo check
for SET AUTOCOMMIT OFF
;
10 Statement prepare failed with error
-19
11 echo insert some record
;
12 Statement Executed
: Rows Affected
= 1
13 Statement Executed
: Rows Affected
= 1
14 Statement Executed
: Rows Affected
= 1
15 Statement Executed
: Rows Affected
= 1
16 Statement Executed
: Rows Affected
= 1
18 echo select * from t1
;
19 ---------------------------------------------------------
21 ---------------------------------------------------------
28 AUTOCOMMIT Mode is
set to OFF
29 Statement Executed
: Rows Affected
= 1
30 Statement Executed
: Rows Affected
= 1
31 Statement Executed
: Rows Affected
= 1
32 Statement Executed
: Rows Affected
= 1
33 Statement Executed
: Rows Affected
= 1
34 Statement Executed
: Rows Affected
= 1
35 Statement Executed
: Rows Affected
= 1
36 Statement Executed
: Rows Affected
= 1
37 Statement Executed
: Rows Affected
= 1
38 Statement Executed
: Rows Affected
= 1
40 Statement prepare failed with error
-19
41 ---------------------------------------------------------
43 ---------------------------------------------------------
50 echo test for rollback
;
51 echo insert
5 records
;
52 Statement Executed
: Rows Affected
= 1
53 Statement Executed
: Rows Affected
= 1
54 Statement Executed
: Rows Affected
= 1
55 Statement Executed
: Rows Affected
= 1
56 Statement Executed
: Rows Affected
= 1
57 Statement prepare failed with error
-19
58 ---------------------------------------------------------
60 ---------------------------------------------------------
72 echo check
for show tables
;
73 Statement prepare failed with error
-19
74 echo check
for SET AUTOCOMMIT ON
;
75 Statement prepare failed with error
-19
76 echo insert some records
;
77 Statement Executed
: Rows Affected
= 1
78 Statement Executed
: Rows Affected
= 1
79 Statement Executed
: Rows Affected
= 1
80 Statement Executed
: Rows Affected
= 1
81 Statement Executed
: Rows Affected
= 1
82 ---------------------------------------------------------
84 ---------------------------------------------------------