[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-1063) support for 'locate' function in SQLServer and Sybase dialects

support for 'locate' function in SQLServer and Sybase dialects -------------------------------------------------------------- Key: HHH-1063 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1063 Project: Hibernate Core Issue Type: Patch Components: core Affects Versions: 3.1 rc2 Environment: latest from CVS, SQL Server 2000 Reporter: Nathan Moon Assignee: Gavin King Fix For: 3.1 rc3 Attachments: CharindexFunction.java, SQLServerDialect.patch, sybasedialect.patch This is really 2 separate patches: 1. the file 'sqlserverdialect.patch' adds support for the 'locate' function in SQL Server 2000. Sybase doesn't seem to support a three param version of charindex, which is why this patch goes in SQLServerDialect and not in SybaseDialect. 2. the file 'sybasedialect.patch', along with the new file 'CharindexFunction.java' (belongs in org.hibernate.dialect.function), add support for the 'locate' function in Sybase (untested). I am not a Sybase user, but this seems like it should work to emulate the three param version of locate, even though Sybase doesn't seem to support a third param (start_index). To test this, I tried out something similar on SQLServer, but like I said, it's not really tested on Sybase.