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

create table `t1` (
  `id` int(10) unsigned not null auto_increment,
  primary key  (`id`)
) engine=myisam; 


create table `t2` (
  `id` int(10) unsigned not null auto_increment,
  `t1id` int(10) unsigned,
  `foo` mediumtext,
  primary key  (`id`),
  key `foo` (`foo`(200)),
  key `t1id` (`t1id`)
) engine=myisam;

insert into t1 values (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);

insert into t2 (`t1id`, `foo`) values (1, 'castle of the earl'), (2, 'castle number two'), (3, 'mickey mouse'), (4, 'tom and jerry'), (5, 'tom & jerry');

select distinct t1.id from t1 left join t2 on (t1.id=t2.t1id) where match (`t2`.`foo`) against ('castle*' in boolean mode);

--disable_warnings
drop database bug25729;
--enable_warnings