[ https://issues.jboss.org/browse/TEIID-3573?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3573: ------------------------------------ I changed support for IsNULL to false. In the data, there are 4 rows that have <null> in the intNum column Query: select intKey,intNum from smallA where intKey <> 23 - teiid pushes the criteria down and <null> values are returned in the result set Query (adding Is Null): select intKey,intNum from smalla where intNum <> 23 and intNum is Null - teiid changes the criteria to WHERE 1 = 0 and returns no rows Query (adding Is Not Null): select intKey,intNum from smalla where intNum <> 23 and intNum is Not Null - teiid pushed down: WHERE g_0.intNum <> 23 and teiid handles the Not Null check, the results do not have the <null> values -- This message was sent by Atlassian JIRA (v6.3.15#6346)