--- autoincrement.result 2013-01-22 22:05:05.246633000 +0400 +++ autoincrement.reject 2013-01-23 02:50:12.848090932 +0400 @@ -6,7 +6,7 @@ `a` int(11) NOT NULL AUTO_INCREMENT, `b` char(8) DEFAULT NULL, KEY `a` (`a`) -) ENGINE= DEFAULT CHARSET=latin1 +) ENGINE= DEFAULT CHARSET=latin1 INSERT_METHOD=LAST UNION=(`mrg`.`t1`) INSERT INTO t1 (b) VALUES ('a'),('b'); SELECT a,b FROM t1 ORDER BY a; a b @@ -52,14 +52,14 @@ SET sql_mode = ''; SHOW TABLE STATUS FROM test LIKE 't1'; Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary -t1 # # # # # # # # 6 # # # # # # # # N +t1 # # # # # # # # 0 # # # # # # # # N INSERT INTO t1 (a,b) VALUES (6,'g'),(7,'h'); SELECT LAST_INSERT_ID(); LAST_INSERT_ID() 5 SHOW TABLE STATUS FROM test LIKE 't1'; Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary -t1 # # # # # # # # # 8 # # # # # # # # N +t1 # # # # # # # # # 0 # # # # # # # # N INSERT INTO t1 (a,b) VALUES (NULL,'i'),(9,'j'); SELECT a,b FROM t1 ORDER BY a; a b @@ -78,11 +78,11 @@ 8 SHOW TABLE STATUS FROM test LIKE 't1'; Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary -t1 # # # # # # # # # 10 # # # # # # # # N +t1 # # # # # # # # # 0 # # # # # # # # N INSERT INTO t1 (a,b) VALUES (20,'k'); SHOW TABLE STATUS FROM test LIKE 't1'; Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary -t1 # # # # # # # # # 21 # # # # # # # # N +t1 # # # # # # # # # 0 # # # # # # # # N INSERT INTO t1 (a,b) VALUES (NULL,'l'); SELECT a,b FROM t1 ORDER BY a; a b @@ -103,7 +103,7 @@ 21 SHOW TABLE STATUS FROM test LIKE 't1'; Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary -t1 # # # # # # # # # 22 # # # # # # # # N +t1 # # # # # # # # # 0 # # # # # # # # N INSERT INTO t1 (a,b) VALUES (-5,'m'); SELECT a,b FROM t1 ORDER BY a; a b @@ -125,9 +125,9 @@ INSERT INTO t1 (a,b) VALUES (NULL,'a'),(NULL,'b'); SELECT a,b FROM t1; a b -100 a -101 b +1 a +2 b SELECT LAST_INSERT_ID(); LAST_INSERT_ID() -100 +1 DROP TABLE t1;