Jet driver does not return correct results when HQL where clause contains a boolean value
Description
When a HQL query contain a condition that is mapped to a boolean value the generate SQL query is incorrect. For example "from Account where locked = true" is translated into "select ....... from Acount where locked=1". When using access it should be "..... where locked=-1". It only fails with with the ASTQueryTranslatorFactory. The ClassicQueryTranslatorFactory works as expected.
Fix is trivial. Add override for ToBooleanValueString to JetDialect that creates the correct values for the SQL statement.
When a HQL query contain a condition that is mapped to a boolean value the generate SQL query is incorrect. For example
"from Account where locked = true" is translated into "select ....... from Acount where locked=1". When using access it should be "..... where locked=-1". It only fails with with the ASTQueryTranslatorFactory. The ClassicQueryTranslatorFactory works as expected.
Fix is trivial. Add override for ToBooleanValueString to JetDialect that creates the correct values for the SQL statement.