[teiid-issues] [JBoss JIRA] (TEIID-5163) Google Spreadsheet translator incorrect results DELETE with boolean in criteria
Steven Hawkins (JIRA)
issues at jboss.org
Mon Nov 20 09:47:00 EST 2017
[ https://issues.jboss.org/browse/TEIID-5163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-5163.
-----------------------------------
Resolution: Duplicate Issue
Duplicate of TEIID-4845
> Google Spreadsheet translator incorrect results DELETE with boolean in criteria
> -------------------------------------------------------------------------------
>
> Key: TEIID-5163
> URL: https://issues.jboss.org/browse/TEIID-5163
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12.x-6.4
> Reporter: Jan Stastny
> Assignee: Steven Hawkins
> Priority: Critical
>
> When performing DELETE against Google Spreadsheet everything evaluates to false.
> {code:sql}
> DELETE FROM SmallA WHERE BooleanValue
> {code}
> update count is 0, but should be 16.
> {code:sql}
> DELETE FROM SmallA WHERE NOT BooleanValue
> {code}
> update count is 26, but should be 10.
> The BooleanValue column is modeled as:
> {code:sql}
> booleanvalue boolean OPTIONS (NATIVE_TYPE 'BOOLEAN'),
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
More information about the teiid-issues
mailing list