datacontroller-discuss team mailing list archive

[Francis Lavalliere <support@xxxxxxxxxxxxxxxxxx>]

Fixed in build 1.05

** Also affects: datacontroller/datacontroller
   Importance: Undecided
       Status: New

** Also affects: datacontroller/mysql5.1
   Importance: Low
     Assignee: Francis Lavalliere (datacontroller)
       Status: Confirmed

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

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

** Changed in: datacontroller/datacontroller
   Importance: Undecided => Medium

** Changed in: datacontroller/datacontroller
       Status: Confirmed => Fix Released

** Changed in: datacontroller/mysql5.1
   Importance: Low => Medium

** Changed in: datacontroller/mysql5.1
       Status: Confirmed => Fix Released

-- 
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: Fix Released
Status in DataController datacontroller series: Fix Released
Status in DataController mysql5.1 series: Fix Released

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.