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

    pushing down multiple IN claus

    Michael Davies Newbie



      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.