]
RH Bugzilla Integration commented on TEIID-3573:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug
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
Fix For: 8.7.1.6_2, 8.12
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.