NH-3007 - Informix dialect generates incorrect boolean constants

[nhibernate-bot]

Alexander Bolotov created an issue — 11th January 2012, 17:08:31:

In NHibernate 3.2.0 GA, the InformixDialect (and its descendants as well) generates the SQL code that the Informix Dynamic Server 11.50 considers incorrect. The HQL query:

IQuery query = session.CreateQuery("from User u where u.IsLocked = true");

The generated SQL code:

select user0_.Id as Id0_, user0_.Name as Name0_, user0_.IsLocked as IsLocked0_ from User user0_ where user0_.IsLocked=t

The problem here is that the final "t" (or "f" if you put "false" in the HQL query) must be quoted according to Informix documentation (see http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.ddi.doc/ddi64.htm) I am using Informix 11.50 and the native driver from Client SDK 3.50.TC9; cannot test it against other Informix versions, so I am not sure whether it this issue is 11.50-specific or applies to other versions as well.

---

Alexander Bolotov added a comment — 11th January 2012, 17:22:12:

The unit test to reproduce the issue

[hazzik]

It is related to HHH-9894 (hibernate/hibernate-orm@3ef05de).