nhibernate-issues

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

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

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


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

        

[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

        

[nhibernate-issues] [JIRA] Commented: (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:comment-tabpanel#action_15837 ] 

Craig Neuwirt commented on NH-1139:
-----------------------------------

I don't think the above fix will work.  There could be Exists SubQueries which will break it.

Any ideas?

> 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

        

[nhibernate-issues] [JIRA] Commented: (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:comment-tabpanel#action_15838 ] 

Craig Neuwirt commented on NH-1139:
-----------------------------------

I just noticed this is a duplicate of NH-1128 and can thus be closed.  The patch from 1128 appears to resolve my issue.

> 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

        

[nhibernate-issues] [JIRA] Closed: (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 ]

Sergey Koshcheyev closed NH-1139.
---------------------------------

    Resolution: Duplicate

> 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