Drizzled Public API Documentation

auto_commit.inc
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;