[teiid-issues] [JBoss JIRA] (TEIID-5163) Google Spreadsheet translator incorrect results DELETE with boolean in criteria

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-5163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13504043#comment-13504043 ] 

RH Bugzilla Integration commented on TEIID-5163:
------------------------------------------------

Van Halbert <vhalbert at redhat.com> changed the Status of [bug 1515145|https://bugzilla.redhat.com/show_bug.cgi?id=1515145] from MODIFIED to ON_QA

> 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)