Starting from version 6, Hibernate has changed the generated SQL for the plural attribute size function. Unfortunately, it uses the count(1) function, which is not supported in older versions of Informix. I am providing the documentation only in text form without an online link, as it can only be accessed in PDF format.
Support for arguments is now better for newer versions of Informix, even with this function and with online documentation.
For example unit test
with hql query
in Hibernate 6 generate SQL
in Hibernate 5.6 generate SQL
There is syntax error with Informix 11.50
Another example of unit test where size function is used.
Starting from version 6, Hibernate has changed the generated SQL for the plural attribute size function. Unfortunately, it uses the count(1) function, which is not supported in older versions of Informix. I am providing the documentation only in text form without an online link, as it can only be accessed in PDF format.
Support for arguments is now better for newer versions of Informix, even with this function and with online documentation.
For example unit test
with hql query
in Hibernate 6 generate SQL
in Hibernate 5.6 generate SQL
There is syntax error with Informix 11.50
Another example of unit test where size function is used.
HQL query