Replies: 1 comment
-
When registering a Cube function from RegisterFunction("CUBE", new SQLFunctionTemplate(NHibernateUtil.String, "CUBE(?1)")); to RegisterFunction("CUBE", new StandardSQLFunction("Cube", null)); it helped me |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Problem Description
When using
.GroupBy(q => new { q.Url, q.ProfileId }.Cube())
, the ORM generates an incorrect SQL query. It is expected thatGROUP BY CUBE(...)
will include both fields (Url and ProfileId), but in the generated query, only the first field (Url) is included.Example Code (LINQ Query)
Generated SQL (Incorrect)
Expected SQL (Correct)
CubeHqlGenerator
Beta Was this translation helpful? Give feedback.
All reactions