[ https://issues.jboss.org/browse/TEIID-3573?page=com.atlassian.jira.plugin... ] Van Halbert edited comment on TEIID-3573 at 7/27/15 9:22 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 (adding Is Not Null): select intKey,intNum from smalla where intNum <> 23 and intNum is Not Null - nothing pushed down: teiid handles WHERE g_0.intNum <> 23 and the Not Null check, the results do not have the <null> values 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 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 -- This message was sent by Atlassian JIRA (v6.3.15#6346)