5 Replies Latest reply on Sep 3, 2014 7:23 AM by Steven Hawkins

    pushing down multiple IN claus

    Michael Davies Newbie

      Hi,

       

      I am writing a translator and want teiid to push down IN clauses with multiple columns, such as the example below:

       

      SELECT a,b,c FROM tab WHERE (a,b) IN (('x','y'))

       

      Can you let me know if this is supported?

       

      I have supportsInCriteria set to true in my ExecutionFactory and single column INs are passed down OK. When I have multiple columns in the IN clause teiid is not pushing down the predicate to the translator.

       

      I am using Teiid 8.7.

       

      Any help appreciated.

       

      Thanks

       

      Mick