← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/storage_engine_api_tester/tests/r/transaction_noautocommit_restart.result

  • Committer: Stewart Smith
  • Date: 2011-02-07 08:29:23 UTC
  • mto: (2154.1.1 build)
  • mto: This revision was merged to the branch mainline in revision 2155.
  • Revision ID: stewart@flamingspork.com-20110207082923-li4wy2hne4mnnych
be sure to start a transaction with a startTransaction call on the first statement when autocommit is OFF. The only statements that DO NOT do this are a) DDL and b) SELECT without a table (e.g. SELECT DATABASE() and SHOW STATUS.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/storage_engine_api_tester/tests/r/transaction_noautocommit_restart.result
 
1
create table t1 (a int) engine=storage_engine_api_tester;
 
2
set autocommit=off;
 
3
insert into t1 values (1);
 
4
rollback;
 
5
select * from t1;
 
6
a
 
7
START TRANSACTION;
 
8
Warnings:
 
9
Warning 1747    There is already a transaction in progress
 
10
ROLLBACK;
 
11
drop table t1;