-
Bug
-
Resolution: Done
-
Major
-
8.7.1
-
None
Operator '<>' returns true for NULL <> 1
Example:
select intKey,intNum from smallA where intNum<>1
It returns also rows which have NULL in column intNum
I believe that NULL <> 1 is not true in SQL.
- is related to
-
TEIID-3539 Infinispan-dsl-cache translator: Can't use IS [NOT] NULL operator for non-string columns
- Closed
-
TEIID-3625 JDG translator has disabled capabilities for GT and LT
- Closed