[
https://issues.jboss.org/browse/TEIID-3573?page=com.atlassian.jira.plugin...
]
Van Halbert edited comment on TEIID-3573 at 7/15/15 9:15 AM:
-------------------------------------------------------------
This will problematic to implement, because its JDG that's doing the comparison.
Teiid doesn't know that the column contains null values without some pre-reading.
Unless you're thinking of adding an additional filtering in the translator such that
when a column that's used in the WHERE clause is returned that has a null value, and
NULL or ISNULL checks are not used, then filter out the row?
was (Author: van.halbert):
This will problematic to implement, because its JDG that's doing the comparison.
Teiid doesn't know that the column contains null values without some pre-reading.
Infinispan-dsl-cache translator: Operator <> incorrectly
handles NULL values
----------------------------------------------------------------------------
Key: TEIID-3573
URL:
https://issues.jboss.org/browse/TEIID-3573
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.7.1
Reporter: Filip Elias
Assignee: Van Halbert
Operator '<>' returns true for NULL <> 1
Example:
{code}
select intKey,intNum from smallA where intNum<>1
{code}
It returns also rows which have NULL in column intNum
I believe that NULL <> 1 is not true in SQL.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)