00001 # 00002 # Tests changes to multiple tables within the same transaction 00003 # 00004 00005 --disable_warnings 00006 DROP TABLE IF EXISTS t1, t2; 00007 --enable_warnings 00008 00009 CREATE TABLE t1 ( 00010 id INT NOT NULL PRIMARY KEY 00011 ); 00012 00013 CREATE TABLE t2 ( 00014 id INT NOT NULL PRIMARY KEY 00015 ); 00016 00017 START TRANSACTION; 00018 INSERT INTO t1 VALUES (1); 00019 INSERT INTO t2 VALUES (1); 00020 COMMIT; 00021 00022 START TRANSACTION; 00023 UPDATE t1 SET id=2 WHERE id=1; 00024 UPDATE t2 SET id=2 WHERE id=1; 00025 COMMIT; 00026 00027 START TRANSACTION; 00028 DELETE FROM t1 WHERE id=2; 00029 DELETE FROM t2 WHERE id=2; 00030 COMMIT; 00031 00032 DROP TABLE t1, t2;