[nhibernate-issues] [JIRA] Updated: (NH-1139) Paging does not work for MSSql2005Dialect when property formulas with select/from are used

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

     [ http://jira.nhibernate.org/browse/NH-1139?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Craig Neuwirt updated NH-1139:
------------------------------

    Attachment: MSsql2005DialectFix.patch

I have attached a small patch which I think will resolve the issue.  
The change is to just 
int fromIndex = querySqlString.LastIndexOfCaseInsensitive(" from ");
which finds the last from clause

> Paging does not work for MSSql2005Dialect when property formulas with select/from are used
> ------------------------------------------------------------------------------------------
>
>                 Key: NH-1139
>                 URL: http://jira.nhibernate.org/browse/NH-1139
>             Project: NHibernate
>          Issue Type: Bug
>          Components: Core
>    Affects Versions: 2.0.0.Alpha1
>            Reporter: Craig Neuwirt
>            Priority: Major
>         Attachments: MSsql2005DialectFix.patch
>
>
> Recents changes to the MSSql2005Dialect GetLimitString broke support for properties with
> formulas that contain select/from statements 

-- 
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