AO generates invalid SQL when GROUP BY query selects an aggregate column

Description

Bug

I've had to @Ignore a few of the test methods in GroupByTest because they are trying to run queries for which AO generates invalid SQL. For example, the query is trying to select "MAX(SCORE) AS SCORE", which would be fine if not for the double quotes that cause the DB to interpret that entire clause (including the alias) as a column name (which of course does not exist).

Workaround

Use Querydsl for non-trivial SELECT queries.

Environment

None

Testing Notes

Add notes...

Status

Assignee

Unassigned

Reporter

Andrew Swan

Labels

None

Add-on Type

None

Team

None

CC

None

Risk factor

None

QA Kickoff Status

None

QA Demo Status

None

Components

Priority

Major
Configure