datacontroller-discuss team mailing list archive

[Francis Lavalliere <support@xxxxxxxxxxxxxxxxxx>]

We have been able to reproduce in our environment and found the section
of code about it.

Thank you for the submission, this will be fixed in the next release.

** Changed in: datacontroller
     Assignee: (unassigned) => Francis Lavalliere (datacontroller)

** Changed in: datacontroller
   Importance: Undecided => Low

** Changed in: datacontroller
       Status: New => Confirmed

-- 
Missing where statement *only if* joinning two DataController Federated Table
https://bugs.launchpad.net/bugs/572728
You received this bug notification because you are a member of
DataController Discussions, which is subscribed to DataController.

Status in DataController, a MySQL Plugin for multiple Database Integration and Business Intelligence tool: Confirmed

Bug description:
This looks to be Independent of Oracle / MS Sql or MySQL.

select a.*, b.* from tablea a, table b b where a.id=b.table_id and a.name="testa" and b.name="testb"

It does looks to perform two full table scans.

select * from tablea;

and 

select * from table b.

The where clause is properly taken in consideration if there's no joins.

Like : 

select a.* from tablea a where a.name="testa";

and

select b.* from tableb b and b.name="testb";

These two are properly querying the remote server.


Thanks.