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

Accumulo translator: null values not returned for <> criteria in WHERE clause

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Major
    • None
    • 8.12.5
    • Misc. Connectors
    • None

    Description

      For columns, which contain some null values, a query like:

      SELECT nullable_column FROM table_name WHERE nullable_column <> some_value
      

      doesn't return null values.

      Simple select works:

      SELECT nullable_column FROM table_name
      

      returns all rows regardless whether they are null or not.

      IS NULL criteria in WHERE clause also work:

      SELECT nullable_column FROM table_name WHERE nullable_column IS NULL
      

      returns correct number of null values.

      Attachments

        Activity

          People

            rhn-engineering-rareddy Ramesh Reddy
            jstastny@redhat.com Jan Stastny
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: