T1 is filled with 4545 rows containing various id's, names and surnames.
When issuing the query:
The result is:
Now accessing the same table via FEDERATED:
0 lines are retrieved from the query:
The bug occurs in create_where_from_key that construct the query:
The above query is wrong but should anyway return all the 'PHILIPPE' for names above 'HEROS'.
Using the CONNECT engine the constructed query is made in MakeKeyWhere. It is different but also wrong:
Also logically returning no rows.
Because FEDERATED and CONNECT use a different construction program, I can take care of the problem in CONNECT but not in FEDERATED.