Bug #28459 Unable to query table on Windows slave from Linux master
Submitted: 15 May 2007 23:45 Modified: 16 Jun 2007 8:35
Reporter: Twang Li Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Replication Severity:S1 (Critical)
Version:5.0.41 OS:Windows (XP)
Assigned to: CPU Architecture:Any

[15 May 2007 23:45] Twang Li 
Description:
The Linux master is version 5.0.38 and the Window slave is 5.0.41. I understand this issue of the case insensitivity of Windows; however, i cannot even query a table with a name that's already lower case.
ERROR 1146 (42S02): Table 'database.tablename' doesn't exist

I can create a table locally with upper or lower case and query that fine though. These are InnoDB tables.

Any help would be much appreciated.

How to repeat:
Install MySQL 5.0.38 on Gentoo Linux and configure it as master. Install MySQL 5.0.41 on Windows XP and configure it as slave. tar up the existing database on the master and untar it on the slave. Setup replication between the two.
Run a SELECT statement on any database from the master. Fail.
[16 May 2007 8:35] Sveta Smirnova 
Thank you for the report.

But is not clear what "to query table on Windows slave from Linux master" means.

On which server do you run SELECT statements which broke? Where have you seen errors: as output in the command line client, in the SHOW SLAVE STATUS output or in the error log?
[16 Jun 2007 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".