--disable_warnings
drop database if exists bug25038;
create database bug25038;
--enable_warnings

--connect (conn1,localhost,root,,bug25038)

CREATE TABLE `foo1` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `foo` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 


CREATE TABLE `foo2` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `foo` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 


CREATE TABLE `foo_merge` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `foo` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MRG_MyISAM DEFAULT CHARSET=latin1 UNION=(`foo1`,`foo2`); 

--disable_query_log
let $1=100000;
while ($1)
{
 insert into foo1(foo) values ('foo1');
 insert into foo2(foo) values ('foo2');
 dec $1;
}
--enable_query_log

--disable_result_log
SELECT * FROM foo_merge;
--enable_result_log

SELECT 1;

--sleep 100

TRUNCATE TABLE foo1;

--disable_warnings
drop database bug25038;
--enable_warnings