datacontroller-discuss team mailing list archive

[jmartel <josee_martel@xxxxxxxxxxx>]

Public bug reported:

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.

** Affects: datacontroller
     Importance: Undecided
         Status: New

-- 
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: New

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.