[hibernate-issues] [Hibernate-JIRA] Issue Comment Edited: (HHH-969) InformixDialect uses wrong sql for substring function
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-969?page=co...
]
Martin Heitz edited comment on HHH-969 at 7/20/11 3:30 AM:
-----------------------------------------------------------
The fix suggested by Scott works fine for me. Anyway a fix in the Hibernate
InformixDialect would be much better.
Best regards, Mattin
P.S. Note that I'm using 3.6.5.Final and the issue is still open.
was (Author: mattin):
The fix suggested by Scott works fine for me. Anyway a fix in the Hibernate
InformixDialect would be much better.
Best regards, Mattin
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.
For more information on JIRA, see: http://www.atlassian.com/software/jira