I attempted to create a merge table across two identical InnoDB tables and it seemed to work without error. But when I went to use the table I got a file not found my_table.MRG (error number 2) error. The file does in fact exist, but it is only 54 bytes.
I'm guessing that I can only create a merge table with MyISAM tables. Is this correct? The manual says that a merge table is a collection of MyISAM tables but it doesn't explicitly state that it doesn't work with other types. John A. McCaskey