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

Google translator inconsistent behavior for DELETE and SELECT for null values

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 9.2
    • Fix Version/s: 9.2, 9.1.3
    • Component/s: Misc. Connectors
    • Labels:
      None
    • Environment:

      9.2.0.Alpha2

    • Steps to Reproduce:
      Hide

      insert into smalla (intnum, intkey) values (10, 1), (null, 2), (30,3)
      select intnum, intkey from smalla where intnum > -10 AND intnum < 20 #returns (10,1)
      delete from smalla where intnum > -10 AND intnum < 20 #deletes (10,1), (null,2)

      Show
      insert into smalla (intnum, intkey) values (10, 1), (null, 2), (30,3) select intnum, intkey from smalla where intnum > -10 AND intnum < 20 #returns (10,1) delete from smalla where intnum > -10 AND intnum < 20 #deletes (10,1), (null,2)

      Description

      In teiid I observed following inconsistent behavior:
      Q1: select intnum, intkey from smalla where intnum > -10 AND intnum < 20
      Q2: delete from smalla where intnum > -10 AND intnum < 20

      Q1 returns rows without null values for intnum, but Q2 deletes also rows with null values for intnum.

      I observed that if I remove the lower boundary (ie. Q3: select intnum, intkey from smalla where intnum < 20 and similarly for delete), both selected and deleted rows contain null values, so the result is consistent.

      The server.log is empty, so I didn't attach it...

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                lfabriko Lucie Fabrikova
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: