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

            Activity

              People

              Assignee:
              shawkins Steven Hawkins
              Reporter:
              lfabriko Lucie Krejcirova
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: