Filip Elias created TEIID-3573:
----------------------------------
Summary: 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: Steven Hawkins
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)