Bug #23597 where-like clause don't work with merged table
Submitted: 24 Oct 2006 21:32 Modified: 25 Oct 2006 8:58
Reporter: Steven Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.21 OS:Windows (Win XP Home)
Assigned to: CPU Architecture:Any

[24 Oct 2006 21:32] Steven
I have a Merge table for 9 underlying tables.  I have a column called subject with a unique index and a fulltext index on it.  If I do a query like this.
select * from alltables where `subject` like 'A%';
It will return no results.  It should return all results that start with an A.

How to repeat:
Create 2 tables with a text column and do a merge on them.  Then run the above query.
[25 Oct 2006 8:58] Sveta Smirnova
Thank you for the report.

I can not repeat the problem using MySQL 5.0.25 and current BK sources.