[teiid-issues] [JBoss JIRA] (TEIID-4468) Google translator evaluates 0 as not NULL for operator <>
Steven Hawkins (JIRA)
issues at jboss.org
Fri Sep 23 12:24:00 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13297996#comment-13297996 ]
Steven Hawkins commented on TEIID-4468:
---------------------------------------
> If this is expected behavior, shouldn't it be in the documentation?
It's not expected from Teiid's perspective. It looks like a bug / quality issue with google spreadsheets - the documentation states null comparisons should use is null / is not null, which implies null should not match equality or not equality. We'll have to workaround that from our side. And it affects all types from what I have seen.
> 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
> Affects Versions: 8.12
> Reporter: Lucie Fabrikova
> Assignee: Steven Hawkins
> Priority: Minor
>
> 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