Expressions not supported in the GROUP BY or ORDER BY clause. #3193
Last updated: 2013-02-19 13:17:59 +0100
Date: 2012-11-24 05:29:07 +0100
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/17.0 Firefox/17.0
Pasted email response from Fabian below:
On 19-11-2012 16:24:09 -0600, Brandon Jackson wrote:
My feeling is that since group columns need to appear in select, it makes sense that group by doesn't support expressions. The alias solves that, which gets you sort of duplicate elimination for free. I understand you can live with that fine too.
What you end up with is the "mismatch" of c0 and its unmodified original column. I think it's worth filing a bug for this one. Niels can judge whether this can be easily detected by some more checking, or not.
Date: 2012-11-26 21:52:31 +0100
are there other examples of the case 2 vs 3. This example maybe fixable but I'm afraid it may require a more general (even larger) patch.
Date: 2012-11-27 14:35:10 +0100
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=89a9ebc92eda
Date: 2013-02-19 13:17:59 +0100
Feb2013 has been released.
The text was updated successfully, but these errors were encountered: