00001 # 00002 # Simple test of the serial event log for autocommit behaviour. 00003 # 00004 00005 --disable_warnings 00006 DROP TABLE IF EXISTS t1; 00007 --enable_warnings 00008 00009 SET AUTOCOMMIT= 0; 00010 00011 CREATE TABLE t1 ( 00012 id INT NOT NULL PRIMARY KEY 00013 , padding VARCHAR(200) NOT NULL 00014 ); 00015 00016 INSERT INTO t1 VALUES (1, "I love testing."); 00017 INSERT INTO t1 VALUES (2, "I hate testing."); 00018 00019 COMMIT; 00020 DROP TABLE t1; 00021 00022 # Try the same thing with auto_commit turned on 00023 # This should produce a commit between inserts... 00024 00025 SET AUTOCOMMIT= 1; 00026 00027 CREATE TABLE t1 ( 00028 id INT NOT NULL PRIMARY KEY 00029 , padding VARCHAR(200) NOT NULL 00030 ); 00031 00032 INSERT INTO t1 VALUES (1, "I love testing."); 00033 INSERT INTO t1 VALUES (2, "I hate testing."); 00034 00035 DROP TABLE t1;