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}