Max Philipp Wriedt created TORQUE-365:
-----------------------------------------
Summary: CountHelper doesn't work, when Criteria has
"setDisctint()"
Key: TORQUE-365
URL: https://issues.apache.org/jira/browse/TORQUE-365
Project: Torque
Issue Type: Bug
Components: Runtime
Affects Versions: 5.1
Reporter: Max Philipp Wriedt
When passing a Criteria which has been modified with "setDistinct()" the
CountHelper creates a wrong SQL-Statement containing "SELECT COUNT(DISTINCT
*)". This is not valid SQL.
A common workaround is to set a column to count while creating the CountHelper.
If I am not wrong we could also solve this problem inside the count()-function
of the CountHelper itself, as there is already a handler for DISTINCT cases.
{code:java}
boolean distinct = isAndSetDistinct(criteriaSelectModifiers) &&
!Objects.equals(columnName, "*");{code}
This could probably set "DISTINCT" directly behind the SELECT, but not inside
the "COUNT()" clause, generating at least valid SQL.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscr...@db.apache.org
For additional commands, e-mail: torque-dev-h...@db.apache.org
