← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/regression/r/682563.result

  • 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/r/682563.result
30
30
a
31
31
1
32
32
2
 
33
COMMIT;
33
34
DROP TABLE t1;
34
35
SET AUTOCOMMIT= 0;
35
36
SHOW STATUS LIKE 'Handler_commit%';
39
40
SHOW STATUS LIKE 'Handler_commit%';
40
41
Variable_name   Value
41
42
Handler_commit  0
 
43
COMMIT;
42
44
DROP SCHEMA IF EXISTS boundaries;
43
45
Warnings:
44
46
Note    1008    Can't drop schema 'boundaries'; schema doesn't exist
54
56
Variable_name   Value
55
57
Handler_commit  1
56
58
BEGIN;
 
59
COMMIT;
57
60
DROP SCHEMA IF EXISTS boundaries;
58
61
Warnings:
59
62
Note    1008    Can't drop schema 'boundaries'; schema doesn't exist
60
 
COMMIT;
61
63
SHOW STATUS LIKE 'Handler_commit%';
62
64
Variable_name   Value
63
65
Handler_commit  2
110
112
SHOW STATUS LIKE 'Handler_commit%';
111
113
Variable_name   Value
112
114
Handler_commit  4
 
115
COMMIT;
113
116
drop table commit_test;
114
117
SHOW STATUS LIKE 'Handler_commit%';
115
118
Variable_name   Value
155
158
FROM t1_trx
156
159
INNER JOIN t1_non_trx ON t1_trx.k = t1_non_trx.k;
157
160
k       v
 
161
COMMIT;
158
162
DROP TABLE t1_trx;
159
163
DROP TABLE t1_non_trx;