Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3573

Infinispan-dsl-cache translator: Operator <> incorrectly handles NULL values

XMLWordPrintable

      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.

              van.halbert Van Halbert (Inactive)
              felias_jira Filip Elias (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: