[ https://issues.jboss.org/browse/TEIID-3573?page=com.atlassian.jira.plugin... ] Van Halbert edited comment on TEIID-3573 at 7/27/15 9:03 PM: ------------------------------------------------------------- Kept IsNull = false, changed supportNot = FALSE Query: select intKey,intNum from smallA where intNum <> 23 * teiid doesn't push down criteria and doesn't include the <null> value rows Query (adding Is Null): select intKey,intNum from smalla where intNum <> 23 and intNum is Null * no criteria pushed down, and returned no rows Query: select intKey,intNum, stringNum, floatnum from smalla where intNum Is Null * no criteria pushed down, and returns on the 4 rows that have <null> value Query: select intKey,intNum, stringNum, floatnum from smalla where intNum Is Not Null * returned the correct results was (Author: van.halbert): Kept IsNull = false, changed supportNot = FALSE Query: select intKey,intNum from smallA where intNum <> 23 * teiid doesn't push down criteria and doesn't include the <null> value rows Didn't need to test this query because of results above: (adding Is Null): select intKey,intNum from smalla where intNum <> 23 and intNum is Null Query: select intKey,intNum, stringNum, floatnum from smalla where intNum Is Null * no criteria pushed down, and returns on the 4 rows that have <null> value Query: select intKey,intNum, stringNum, floatnum from smalla where intNum Is Not Null * returned the correct results -- This message was sent by Atlassian JIRA (v6.3.15#6346)