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

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

    XMLWordPrintable

Details

    Description

      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.

      Attachments

        Issue Links

          is related to

          Bug - A problem that impairs or prevents the functions of the product. TEIID-3539 Infinispan-dsl-cache translator: Can't use IS [NOT] NULL operator for non-string columns

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Bug - A problem that impairs or prevents the functions of the product. TEIID-3625 JDG translator has disabled capabilities for GT and LT

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: