← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/regression/t/682563.test

  • Committer: Lee Bieber
  • Date: 2011-01-21 19:31:02 UTC
  • mto: This revision was merged to the branch mainline in revision 2101.
  • Revision ID: kalebral@gmail.com-20110121193102-zj242zr9fvvx66ld
Update test for regression.682563 to add now needed COMMIT statements

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/regression/t/682563.test
36
36
BEGIN;
37
37
SELECT * from t1 order by a;
38
38
 
 
39
COMMIT;
39
40
DROP TABLE t1;
40
41
 
41
42
disconnect a;
59
60
 
60
61
SHOW STATUS LIKE 'Handler_commit%';
61
62
 
 
63
COMMIT;
62
64
DROP SCHEMA IF EXISTS boundaries;
63
65
 
64
66
# Expect 1 commit count since above DROP SCHEMA
82
84
 
83
85
SHOW STATUS LIKE 'Handler_commit%';
84
86
BEGIN;
 
87
COMMIT;
85
88
DROP SCHEMA IF EXISTS boundaries;
86
 
COMMIT;
87
89
 
88
90
SHOW STATUS LIKE 'Handler_commit%';
89
91
CREATE TABLE commit_test (a int);
126
128
 
127
129
 
128
130
SHOW STATUS LIKE 'Handler_commit%';
 
131
COMMIT;
129
132
drop table commit_test;
130
133
SHOW STATUS LIKE 'Handler_commit%';
131
134
# Tests a number of things related to transactions:
182
185
FROM t1_trx
183
186
INNER JOIN t1_non_trx ON t1_trx.k = t1_non_trx.k;
184
187
 
 
188
COMMIT;
185
189
DROP TABLE t1_trx;
186
190
DROP TABLE t1_non_trx;