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

[Anthony Patricio (JIRA)]

dialect changes: limit string
-----------------------------

                 Key: HHH-2809
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2809
             Project: Hibernate3
          Issue Type: Bug
          Components: core
    Affects Versions: 3.2.3
            Reporter: Anthony Patricio
         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

-- 
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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira