3 Replies Latest reply on Feb 21, 2013 10:03 AM by Steven Hawkins

    Optimize out SELECT in the face of deterministic functions in WHERE clause

    Mark Addleman Master

      The query SELECT c FROM t WHERE c='a' AND ucase(c)='b' is gauranteed to be an empty result.  It seems like the optimizer could thread the constrained value of c through any deterministic function to know that the where clause will always be false.

       

      Is this a particularly difficult change to make to the optimizer?  If you can give me a push in the right direction, I'll try to strengthen my Teiid fu