Description:
First of all it is not mentioned how tables should be listed in UNION TABLES: by comma, by space etc.
If I specify tables by comma I get the following SQL statement during export:
CREATE TABLE `test`.`total` (
`id` INT UNSIGNED NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE = Merge
UNION = t1, t2
INSERT_METHOD = LAST
INSERT_METHOD = LAST
CHARACTER SET latin1 COLLATE latin1_swedish_ci;
and this is wrong because tables should be placed into brackets:
UNION = (t1, t2)
BTW: the same applies to QB and MA, but they even don't allow to type underlying tables during creation. You can only do it by editing existing merge table.
How to repeat:
1. create 2 identical tables MyISAM t1 and t2 with one int column non auto_increment
2. create MERGE table with the same int column
3. Go to Table Options tab and list t1 and t2 tables in the UNION Tables.
4. 'Apply changes'
5. Export SQL Create script.