[nhibernate-issues] [JIRA] Created: (NH-837) Error using Limits with DB2400Dialect

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Error using Limits with DB2400Dialect
-------------------------------------

         Key: NH-837
         URL: http://jira.nhibernate.org/browse/NH-837
     Project: NHibernate
        Type: Bug
  Components: Data Providers  
    Versions: 1.2.0.Beta2    
    Reporter: Christophe Vigouroux

Using with DB2400Dialect :

query.SetFirstResult(startRow);
query.SetMaxResults(maxRows);
IList<Core.Imprimante> retour = query.List<Core.Imprimante>();

results in the generation of the following SQL statement :

select * from (select rownumber() over() as rownum, this_.CDIMPLOG as CDIMPLOG0_0_, this_.CDSOC as CDSOC0_0_, this_.LBIMP as LBIMP0_0_ FROM TIMPRIM this_) as tempresult where rownum <= ?

This statement is for use with DB2 UDB, but not compatible with DB2 for iSeries.
The statement should use RRN(table) instead of rownumber() and use "fetch first n rows" instead of over().

DB2400Dialect should override GetLimitString of DB2Dialect to provide with functionality.

Thanks for your support !

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira