1
--- tbl_opt_union.result 2013-01-22 22:05:05.246633000 +0400
2
+++ tbl_opt_union.reject 2013-01-23 02:51:05.375430573 +0400
6
`a` int(11) DEFAULT NULL
7
-) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 UNION=(`child1`)
8
+) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 INSERT_METHOD=LAST UNION=(`child1`)
9
ALTER TABLE t1 UNION = (child1,child2);
12
t1 CREATE TABLE `t1` (
13
`a` int(11) DEFAULT NULL
14
-) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 UNION=(`child1`,`child2`)
15
+) ENGINE=<STORAGE_ENGINE> DEFAULT CHARSET=latin1 INSERT_METHOD=LAST UNION=(`child1`,`child2`)
16
DROP TABLE t1, child1, child2;