[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4053) Incorrect SQL with substring for Firebird

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4053?page=c... ] Ali Tekin commented on HHH-4053: -------------------------------- The problem is that in the Dialect.java line 210 it reads as: ... registerFunction( "substring", new SQLFunctionTemplate( Hibernate.STRING, "substring(?1, ?2, ?3)" ) ); ... This line should be overwritten in FirebirdDialect.java as: ... registerFunction("substring", new SQLFunctionTemplate(new StringType(), "substring(?1 from ?2 for ?3)")); ... I have created a CustomFirebirdDialect class and tested it, it worked charmly. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira