[teiid-issues] [JBoss JIRA] (TEIID-3573) Infinispan-dsl-cache translator: Operator <> incorrectly handles NULL values

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.