Bug #19761 Workbench generates wrong SQL for MERGE tables
Submitted: 12 May 2006 9:26
Reporter: Victoria Reznichenko Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Workbench Preview Severity:S3 (Non-critical)
Version:1.0.6 OS:Windows (windows)
Assigned to: CPU Architecture:Any

[12 May 2006 9:26] Victoria Reznichenko
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.