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