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

[NHibernate J. <mik...@us...>]

     [ http://jira.nhibernate.org/browse/NH-837?page=comments#action_14624 ]
     
Christophe Vigouroux commented on NH-837:
-----------------------------------------

Obviously RRN() is not an equivalent to Row_Number. It returns a "relative" row number and cannot be used because it doesn't return the row number of the result set, only the row number of the physical table.

I don't know any way to get the row number of the result set, or any other way to ask DB2/400 to fetch the rows starting from an offet...

> 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