nhibernate-issues

[nhibernate-issues] [NHJIRA] Created: (NH-2781) linq's OrderBy by a calculated column doesn't work

[dmitry (JIRA) <nh...@gm...>]

linq's OrderBy by a calculated column doesn't work
--------------------------------------------------

                 Key: NH-2781
                 URL: http://216.121.112.228/browse/NH-2781
             Project:  NHibernate
          Issue Type: Bug
          Components: Linq Provider
    Affects Versions: 3.1.0
            Reporter: dmitry
            Priority: Major


var a = source.Select(s => new { s.Email, Revenue = s.CompletedOffers.Sum(c => (decimal?)c.Offer.Revenue) })
.OrderBy(s => s.Revenue).ToList()

throws QuerySyntaxException. Message: "Exception of type 'Antlr.Runtime.NoViableAltException' was thrown"

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

        

[nhibernate-issues] [NHJIRA] Commented: (NH-2781) linq's OrderBy by a calculated column doesn't work

[Patrick E. (JIRA) <nh...@gm...>]

    [ http://216.121.112.228/browse/NH-2781?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=21345#action_21345 ] 

Patrick Earl commented on NH-2781:
----------------------------------

Hi dmitry.  It would be great if you could provide a full unit test.  http://blog.patearl.net/2010/12/nhibernate-30-linq.html

> linq's OrderBy by a calculated column doesn't work
> --------------------------------------------------
>
>                 Key: NH-2781
>                 URL: http://216.121.112.228/browse/NH-2781
>             Project:  NHibernate
>          Issue Type: Bug
>          Components: Linq Provider
>    Affects Versions: 3.1.0
>            Reporter: dmitry
>            Priority: Major
>
> var a = source.Select(s => new { s.Email, Revenue = s.CompletedOffers.Sum(c => (decimal?)c.Offer.Revenue) })
> .OrderBy(s => s.Revenue).ToList()
> throws QuerySyntaxException. Message: "Exception of type 'Antlr.Runtime.NoViableAltException' was thrown"

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