Bug #8858 MysqlDump will dump data from MERGE table
Submitted: 1 Mar 2005 11:01 Modified: 24 May 2005 14:27
Reporter: Varoqui Stephane Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S2 (Serious)
Version:4.1 OS:Windows (Windows)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any

[1 Mar 2005 11:01] Varoqui Stephane 
Description:
MysqlDump will dump data from MERGE table

How to repeat:
MysqlDump on merge table
[1 Mar 2005 14:58] MySQL Verification Team 
Please clarify version number, how exactly you dumped table etc, because I wasn't able reproduce it, mysqldump dumps data only for sub-tables of merge table.
[1 Mar 2005 15:14] Varoqui Stephane 
Hi,

We get this bug with the 4.1.9 GA at a training session in paris 
The dump was optained with the backup feature of the Mysql Administrator and with option "delete table if exist" restoring the data was impossible.
looking closer into the script i saw a bunch of insert into mrgtable ....

we try a lot tricky features and manipulations during this session, so apologize if you can not reproduce. 

Regards
[20 Apr 2005 10:55] Jani Tolonen 
mysqldump is not affected. This is presumably a bug in
MySQL Administrator only.

mysqldump.c has a special check for MERGE tables, see function
check_if_ignore_table() for an example. MySQL Administartor should
do a similar check.

Reassigning to GUI team..
[24 May 2005 14:27] Vladimir Kolesnikov 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html