[
https://issues.jboss.org/browse/TEIID-5163?page=com.atlassian.jira.plugin...
]
Jan Stastny updated TEIID-5163:
-------------------------------
Description:
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}
was:
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}
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)