~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/savepoints.result

  • Committer: Stewart Smith
  • Date: 2010-12-29 04:36:52 UTC
  • mto: (2099.1.3 build)
  • mto: This revision was merged to the branch mainline in revision 2100.
  • Revision ID: stewart@flamingspork.com-20101229043652-li2mk1evdtvtxz3s
use explicit COMMITs in savepoints test instead of implicit COMMITs in DROP TABLE statement

Show diffs side-by-side

added added

removed removed

Lines of Context:
5
5
UPDATE t1 SET id = 2 WHERE id != 2 LIMIT 0;
6
6
SAVEPOINT A;
7
7
End Test of Bug 534806
 
8
COMMIT;
8
9
DROP TABLE t1;
9
10
CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY);
10
11
START TRANSACTION;
45
46
2
46
47
3
47
48
4
 
49
COMMIT;
48
50
DROP TABLE t1;
49
51
Start Test of Bug 542299
50
52
CREATE TABLE t1 (a int,id integer auto_increment,b int,/*Indices*/key (a ),primary key (id)) ENGINE=innodb;
57
59
INSERT INTO t1 ( a, b ) VALUES ( 1 , 9 );
58
60
ROLLBACK TO SAVEPOINT A;
59
61
End Test of Bug 542299
 
62
COMMIT;
60
63
DROP TABLE t1;