[jira] [Created] (TORQUE-365) CountHelper doesn't work, when Criteria has "setDisctint()"

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)