A bug in the HSQL dialect implementation of the `to_char` function resulted in incorrect conversions of objects to strings, and when used in a comparison would result in a `java.lang.IllegalArgumentException` exception.
In this release of JBoss EAP 6, the `to_char` function in the HSQL dialect has been fixed by properly converting objects to a string. As a result, comparisons made using the `to_char` should no longer throw `java.lang.IllegalArgumentException` exceptions.
Description of problem:
I believe(have tried) we have incorrectly registered TO_CHAR in HSQL dialect:
org.hibernate.dialect.HSQLDialect:
registerFunction( "to_char", new StandardSQLFunction( "to_char" ) );
while org.hibernate.dialect.Oracle8iDialect:
registerFunction( "to_char", new StandardSQLFunction("to_char",StandardBasicTypes.STRING) );
We're comparing a TO_CHAR construct that gets a Calendar as parameter to a String. The TO_CHAR converts the Calendar to a String, making it possible to compare it with a String. For me it looks like Hibernate
doesn't get that TO_CHAR makes that conversion and only sees that there's a Calendar (within the TO_CHAR) on the left hand side and a String parameter on the right hand side and decides (erroneously I think) that a comparison between the two is invalid.
Version-Release number of selected component (if applicable):
- tested in EAP 6.0.1 and 6.1.0 Alpha
How reproducible:
- always
Steps to Reproduce:
Reproducer is attached to the customer's case.
Actual results:
Exception thrown.
Expected results:
Query parsed properly.
Additional info:
upstream Jira with proposed patch: https://hibernate.atlassian.net/browse/HHH-8136
Description of problem: I believe(have tried) we have incorrectly registered TO_CHAR in HSQL dialect: org.hibernate.dialect.HSQLDialect: registerFunction( "to_char", new StandardSQLFunction( "to_char" ) ); while org.hibernate.dialect.Oracle8iDialect: registerFunction( "to_char", new StandardSQLFunction("to_char",StandardBasicTypes.STRING) ); We're comparing a TO_CHAR construct that gets a Calendar as parameter to a String. The TO_CHAR converts the Calendar to a String, making it possible to compare it with a String. For me it looks like Hibernate doesn't get that TO_CHAR makes that conversion and only sees that there's a Calendar (within the TO_CHAR) on the left hand side and a String parameter on the right hand side and decides (erroneously I think) that a comparison between the two is invalid. Version-Release number of selected component (if applicable): - tested in EAP 6.0.1 and 6.1.0 Alpha How reproducible: - always Steps to Reproduce: Reproducer is attached to the customer's case. Actual results: Exception thrown. Expected results: Query parsed properly. Additional info: upstream Jira with proposed patch: https://hibernate.atlassian.net/browse/HHH-8136