6 Replies Latest reply on Sep 30, 2010 4:07 PM by Steven Hawkins

    Passing WHERE expression to translator (col1 + col2) > value

    Charles E Simon Newbie

      I can't figure out how to get Teiid to pass a WHERE expression to my translator when it contains any arithmetic.

       

      The example I am trying is a single table with two numeric columns and my client program wants to ask for rows like the following:

       

         select col1, col2 from table where (col1 + col2) > 1000;

       

      I cannot get Teiid to pass this WHERE clause to my translator.  What does my ExecutionFactory need to say it supports.  I already say I support the numeric operators and it also returns true for:

         supportsCompareCriteriaEquals()

         supportsCompareCriteriaOrdered()

         supportsIsNullCriteria()

         supportsNotCriteria()

       

      What am I missing?