[ https://issues.jboss.org/browse/TEIID-4468?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4468: --------------------------------------- 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. -- This message was sent by Atlassian JIRA (v6.4.11#64026)