Invalid SQL when grouping by condition

Description

Hi team,

When grouping by a condition nHibernate produce invalid SQL in the group by clause.

It correctly creates a case when in the select statement but missing the parameters in the group by resulting in System.Data.SqlClient.SqlException : Incorrect syntax near '?'.

Example test project attached that have 4 unit tests demonstrating that it works perfectly in select, where & order by but in a group by its an issue.

Many thanks to take a look at this as for me.

Cheers!

Mikael

Environment

None

Attachments

1

Activity

Show:

Mikael Hallin June 17, 2016 at 7:38 AM

Thanks I have downloaded the source code ans tested it and the SQL is now perfect!

Above example,

Alex Zaytsev June 17, 2016 at 1:41 AM

Duplicate of

Duplicate

Details

Assignee

Reporter

Labels

Components

Affects versions

Priority

Who's Looking?

Open Who's Looking?
Created June 17, 2016 at 12:52 AM
Updated November 5, 2016 at 12:17 AM
Resolved November 5, 2016 at 12:17 AM
Who's Looking?