--- alter_table.result 2013-01-22 22:05:05.246633000 +0400 +++ alter_table.reject 2013-01-23 02:50:10.652118538 +0400 @@ -8,7 +8,7 @@ `a` int(11) DEFAULT NULL, `c` char(8) DEFAULT NULL, `b` int(11) DEFAULT NULL -) ENGINE= DEFAULT CHARSET=latin1 +) ENGINE= DEFAULT CHARSET=latin1 INSERT_METHOD=LAST UNION=(`mrg`.`t1`) ALTER TABLE t1 ALTER COLUMN a SET DEFAULT '0'; SHOW CREATE TABLE t1; Table Create Table @@ -16,7 +16,7 @@ `a` int(11) DEFAULT '0', `c` char(8) DEFAULT NULL, `b` int(11) DEFAULT NULL -) ENGINE= DEFAULT CHARSET=latin1 +) ENGINE= DEFAULT CHARSET=latin1 INSERT_METHOD=LAST UNION=(`mrg`.`t1`) ALTER TABLE t1 ALTER a DROP DEFAULT; SHOW CREATE TABLE t1; Table Create Table @@ -24,7 +24,7 @@ `a` int(11), `c` char(8) DEFAULT NULL, `b` int(11) DEFAULT NULL -) ENGINE= DEFAULT CHARSET=latin1 +) ENGINE= DEFAULT CHARSET=latin1 INSERT_METHOD=LAST UNION=(`mrg`.`t1`) ALTER TABLE t1 CHANGE COLUMN b b1 FIRST; SHOW CREATE TABLE t1; Table Create Table @@ -32,7 +32,7 @@ `b1` char(8) DEFAULT NULL, `a` int(11), `c` char(8) DEFAULT NULL -) ENGINE= DEFAULT CHARSET=latin1 +) ENGINE= DEFAULT CHARSET=latin1 INSERT_METHOD=LAST UNION=(`mrg`.`t1`) ALTER TABLE t1 CHANGE b1 b AFTER c; SHOW CREATE TABLE t1; Table Create Table @@ -40,7 +40,7 @@ `a` int(11), `c` char(8) DEFAULT NULL, `b` int(11) DEFAULT NULL -) ENGINE= DEFAULT CHARSET=latin1 +) ENGINE= DEFAULT CHARSET=latin1 INSERT_METHOD=LAST UNION=(`mrg`.`t1`) ALTER TABLE t1 CHANGE b b ; SHOW CREATE TABLE t1; Table Create Table @@ -48,7 +48,7 @@ `a` int(11), `c` char(8) DEFAULT NULL, `b` char(8) DEFAULT NULL -) ENGINE= DEFAULT CHARSET=latin1 +) ENGINE= DEFAULT CHARSET=latin1 INSERT_METHOD=LAST UNION=(`mrg`.`t1`) ALTER TABLE t1 MODIFY COLUMN b ; SHOW CREATE TABLE t1; Table Create Table @@ -56,7 +56,7 @@ `a` int(11), `c` char(8) DEFAULT NULL, `b` int(11) DEFAULT NULL -) ENGINE= DEFAULT CHARSET=latin1 +) ENGINE= DEFAULT CHARSET=latin1 INSERT_METHOD=LAST UNION=(`mrg`.`t1`) ALTER TABLE t1 MODIFY COLUMN b FIRST; SHOW CREATE TABLE t1; Table Create Table @@ -64,7 +64,7 @@ `b` char(8) DEFAULT NULL, `a` int(11), `c` char(8) DEFAULT NULL -) ENGINE= DEFAULT CHARSET=latin1 +) ENGINE= DEFAULT CHARSET=latin1 INSERT_METHOD=LAST UNION=(`mrg`.`t1`) ALTER TABLE t1 MODIFY COLUMN b AFTER a; SHOW CREATE TABLE t1; Table Create Table @@ -72,14 +72,14 @@ `a` int(11), `b` int(11) DEFAULT NULL, `c` char(8) DEFAULT NULL -) ENGINE= DEFAULT CHARSET=latin1 +) ENGINE= DEFAULT CHARSET=latin1 INSERT_METHOD=LAST UNION=(`mrg`.`t1`) ALTER TABLE t1 DROP COLUMN b; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11), `c` char(8) DEFAULT NULL -) ENGINE= DEFAULT CHARSET=latin1 +) ENGINE= DEFAULT CHARSET=latin1 INSERT_METHOD=LAST UNION=(`mrg`.`t1`) ALTER TABLE t1 RENAME TO t2; SHOW CREATE TABLE t1; ERROR 42S02: Table 'test.t1' doesn't exist @@ -88,7 +88,7 @@ t2 CREATE TABLE `t2` ( `a` int(11), `c` char(8) DEFAULT NULL -) ENGINE= DEFAULT CHARSET=latin1 +) ENGINE= DEFAULT CHARSET=latin1 INSERT_METHOD=LAST UNION=(`mrg`.`t2`) DROP TABLE t2; CREATE TABLE t1 (a , b ) ENGINE= ; INSERT INTO t1 (a,b) VALUES (1,5),(2,2),(4,3); @@ -97,14 +97,14 @@ t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL -) ENGINE= DEFAULT CHARSET=latin1 +) ENGINE= DEFAULT CHARSET=latin1 INSERT_METHOD=LAST UNION=(`mrg`.`t1`) ALTER TABLE t1 ORDER BY b ASC, a DESC; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL -) ENGINE= DEFAULT CHARSET=latin1 +) ENGINE= DEFAULT CHARSET=latin1 INSERT_METHOD=LAST UNION=(`mrg`.`t1`) SELECT a,b FROM t1; a b 2 2 @@ -119,7 +119,7 @@ `a` int(11) DEFAULT NULL, `b` char(8) COLLATE latin1_general_cs DEFAULT NULL, `c` char(8) COLLATE latin1_general_cs DEFAULT NULL -) ENGINE= DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs +) ENGINE= DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs INSERT_METHOD=LAST UNION=(`mrg`.`t1`) ALTER TABLE t1 CONVERT TO CHARACTER SET utf8; SHOW CREATE TABLE t1; Table Create Table @@ -127,7 +127,7 @@ `a` int(11) DEFAULT NULL, `b` char(8) DEFAULT NULL, `c` char(8) DEFAULT NULL -) ENGINE= DEFAULT CHARSET=utf8 +) ENGINE= DEFAULT CHARSET=utf8 INSERT_METHOD=LAST UNION=(`mrg`.`t1`) ALTER TABLE t1 DEFAULT CHARACTER SET = latin1 COLLATE latin1_general_ci; SHOW CREATE TABLE t1; Table Create Table @@ -135,7 +135,7 @@ `a` int(11) DEFAULT NULL, `b` char(8) CHARACTER SET utf8 DEFAULT NULL, `c` char(8) CHARACTER SET utf8 DEFAULT NULL -) ENGINE= DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci +) ENGINE= DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci INSERT_METHOD=LAST UNION=(`mrg`.`t1`) ALTER TABLE t1 FORCE; SHOW CREATE TABLE t1; Table Create Table @@ -143,5 +143,5 @@ `a` int(11) DEFAULT NULL, `b` char(8) CHARACTER SET utf8 DEFAULT NULL, `c` char(8) CHARACTER SET utf8 DEFAULT NULL -) ENGINE= DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci +) ENGINE= DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci INSERT_METHOD=LAST UNION=(`mrg`.`t1`) DROP TABLE t1;