boolean=true doesn't work predictably against MySQL connector ------------------------------------------------------------- Key: TEIID-1341 URL: https://jira.jboss.org/browse/TEIID-1341 Project: Teiid Issue Type: Quality Risk Components: JDBC Connector Affects Versions: 6.0.0 Reporter: Debbie Steigner Fix For: 7.3 MySQL defines false as zero and anything else as a true. So, in MySQL, writing "... where boolean_column = true ..." will usually not evaluate correctly because true is defined as one. To avoid this confusion, MMX should translate boolean_column=true to boolean_column<>false in the SqlTranslator of the MySQL Connector.