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

[Jan Stastny (JIRA)]

Jan Stastny created TEIID-5163:
----------------------------------

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