Description
SQL query whose WHERE clause contains ORed conditions is sent down to custom translator as IN clause even when the custom translator doesn' support IN clause.
public class EWSExecutionFactory extends
ExecutionFactory<ConnectionFactory, EWSConnection> {
...
@Override
public boolean supportsInCriteria()
@Override
public boolean supportsInCriteriaSubquery()
{ return false; }
}
SELECT COUNT FROM Storage.MVDETAIL WHERE Storage.MVDETAIL.CUA = '2D03' OR Storage.MVDETAIL.CUA = '2D07'
is translated to
SELECT COUNT FROM Storage.MVDETAIL WHERE Storage.MVDETAIL.CUA IN ('2D03', '2D07')