I'm thinking, as a workaround for now, turn off support of IS NULL and ISNOTNULL in the translator and let Teiid handle it.

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.