]
Julian Homer commented on HHH-969:
----------------------------------
Has any work been done on this issue?
Has a test case been supplied for this problem? If not can I help by providing one?
Regards
Jools
InformixDialect uses wrong sql for substring function
-----------------------------------------------------
Key: HHH-969
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-969
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.0.5
Environment: Hibernate 3.0.5, Informix 9.4
Reporter: Scott Russell
InformixDialect inherits function definitions from its parent Dialect. However, the
default sql syntax for substring, substring(str, start, len) is not supported in Informix.
Rather, Informix uses the following syntax: substring(str FROM start FOR len)
The following line needs to be added to the InformixDialect constructor in order for this
function to work correctly:
registerFunction( "substring", new SQLFunctionTemplate(Hibernate.STRING,
"substring(?1 FROM ?2 FOR ?3)" ));
-Scott
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: