Drizzled Public API Documentation

ddl_transaction_id.inc

00001 # 
00002 # Tests ordering of transaction ID, that SELECT queries
00003 # do not increment the transaction ID, and that the proper
00004 # generation of transaction IDs is done for DDL operations.
00005 #
00006 
00007 --disable_warnings
00008 DROP TABLE IF EXISTS t1;
00009 --enable_warnings
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 SELECT * FROM t1;
00020 
00021 ALTER TABLE t1 CHANGE COLUMN padding less_padding VARCHAR(180) NOT NULL;
00022 
00023 # 
00024 # Should be no result here...
00025 #
00026 
00027 SELECT * FROM t1 WHERE id = 3;
00028 
00029 DROP TABLE t1;