[teiid-issues] [JBoss JIRA] (TEIID-4700) Google translator inconsistent behavior for DELETE and SELECT for null values
Lucie Fabrikova (JIRA)
issues at jboss.org
Fri Jan 13 03:52:00 EST 2017
[ https://issues.jboss.org/browse/TEIID-4700?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lucie Fabrikova updated TEIID-4700:
-----------------------------------
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...
was:
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 returned and deleted rows contain null values, so the result is consistent.
The server.log is empty, so I didn't attach it...
> 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...
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
More information about the teiid-issues
mailing list