[teiid-issues] [JBoss JIRA] (TEIID-4468) Google translator evaluates 0 as not NULL for operator <>
Steven Hawkins (JIRA)
issues at jboss.org
Sun Sep 25 14:04:00 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4468?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-4468.
-----------------------------------
Resolution: Done
Updated the logic to add is not null checks anytime there is a predicate that could potentially match null.
> Google translator evaluates 0 as not NULL for operator <>
> ----------------------------------------------------------
>
> Key: TEIID-4468
> URL: https://issues.jboss.org/browse/TEIID-4468
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12
> Reporter: Lucie Fabrikova
> Assignee: Steven Hawkins
> Fix For: 9.1, 9.0.5
>
>
> 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?
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list