Bug #59702 FEDERATED results different from direct select
Submitted: 24 Jan 2011 17:46 Modified: 3 Mar 2011 1:19
Reporter: Jonathan Hartley Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Federated storage engine Severity:S3 (Non-critical)
Version:5.1.40 enterprise OS:Linux (Suse 11.1)
Assigned to: CPU Architecture:Any
Tags: federated, results, SELECT

[24 Jan 2011 17:46] Jonathan Hartley 
Description:
When selecting direct and selecting by FEDERATED table the results do not match:

TABLE on server 101 is federated to 137, see file for creates, when running query direct from 137 to 101 you get 1 result, running through FEDERATED link you get a totally different result.

I have pulled the general_log for the 2 connections and the query is different

How to repeat:
CREATE tables as in attachment and run the query attached

Suggested fix:
?
[24 Jan 2011 17:48] Valeriy Kravchuk 
Please, check if the same problem happens with a newer version, 5.1.54. 

Also I do not see any attachment yet.
[24 Jan 2011 19:16] Jonathan Hartley 
create Statements and queries

Attachment: bug59702.txt (text/plain), 2.54 KiB.
[3 Feb 2011 1:19] MySQL Verification Team 
Are you tried 5.1.54?. Thanks in advance.
[4 Mar 2011 0:01] 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".