[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-2809) dialect changes: limit string

dialect changes: limit string ----------------------------- Key: HHH-2809 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2809 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.2.3 Reporter: Anthony Patricio Assignee: Strong Liu Fix For: 3.5.x Attachments: IngresDialect.svndiff32 In Ingres we use "SELECT FIRST $n col1,... FROM ..." to limit the resultset. The old dialect replaces the first 6 chars of the select statement with "SELECT FIRST $n". When running our partner application, hibernate has put 2 or 3 blanks at the begining of the query, which causes an error, of course. Patch attached