]
Steven Hawkins commented on TEIID-4700:
---------------------------------------
The scope of TEIID-4468 was to address = and <> scenarios. It was not identified at
that time that other comparisons would have issues - from the looks of the above we'll
just have to always attempt compenstation as the google handling seems quite
inconsistent.
Google translator inconsistent behavior for DELETE and SELECT for
null values
-----------------------------------------------------------------------------
Key: TEIID-4700
URL:
https://issues.jboss.org/browse/TEIID-4700
Project: Teiid
Issue Type: Bug
Affects Versions: 9.2
Environment: 9.2.0.Alpha2
Reporter: Lucie Fabrikova
Assignee: Steven Hawkins
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...