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

Google translator evaluates 0 as not NULL for operator <>

    XMLWordPrintable

Details

    Description

      Query ""SELECT stringNum FROM bqt1.SmallA <> 0" returns also values NULL (empty cell in spreadsheet).
      I.e., NULL is treated as different from 0.
      If this is expected behavior, shouldn't it be in the documentation?

      Attachments

        Issue Links

          incorporates

          Bug - A problem that impairs or prevents the functions of the product. TEIID-4666 Google translator throws SpreadsheetOperationException for query DELETE FROM table

          • 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.
          • Resolved

          Activity

            People

              rhn-engineering-shawkins Steven Hawkins
              lfabriko@redhat.com Lucie Krejcirova
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: