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;