Google translator comparison with boolean value matches all rows ---------------------------------------------------------------- Key: TEIID-4845 URL: https://issues.jboss.org/browse/TEIID-4845 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.10.6_3 Reporter: Lucie Fabrikova Assignee: Steven Hawkins Fix For: 9.3, 9.2.2 Both following queries match and remove all rows (ie. with both true/false/null values): DELETE WHERE BooleanValue DELETE WHERE NOT BooleanValue Where column in foreign table is: booleanvalue boolean OPTIONS (NATIVE_TYPE 'BOOLEAN') and view: BooleanValue boolean