Invalid SQL when grouping by condition
Description
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
Who's Looking?
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