[DERBY-883] Enhance GROUP BY clause to support expressions instead of just column references. - ASF JIRA

XML

Word

Printable

JSON

This select would return an error syntax on finding "(" after month if group by clause:

select idissue, month(creation), year(creation), count(distinct idissue)
where
....
group by idissue, month(creation), year(creation)

relates to

DERBY-6863 NPE when multiple values are contained in an IN statement within a CASE statement used in a GROUP BY

DERBY-3094 Grouping of expressions causes NullPointerException

DERBY-2014 NullPointerException with NULLIF in GROUP BY clause

DERBY-4403 Assert failure (sane) or NullPointerException (insane) when attempting to GROUP BY expression containing scalar subquery

DERBY-5313 Assert failure with CASE expression in GROUP BY clause

DERBY-2008 NullPointerException with LTRIM, RTRIM and 2-argument SUBSTR() call in GROUP BY clause.

DERBY-2170 Document the ability to use functions in GROUP BY expressions

(2 relates to)