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:






      What am I missing?