Missing where statement *only if* joinning two DataController Federated Table

[jmartel]

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.

[Francis Lavalliere (datacontroller)]

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.

[Francis Lavalliere (datacontroller)]

Fixed in build 1.05