[
https://issues.apache.org/jira/browse/TORQUE-320?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14075622#comment-14075622
]
Thomas Fox commented on TORQUE-320:
-----------------------------------
I am not in favour of having different funtionality for different databases.
Torque has always tried to provide the same functionality for different
databases.
To illustrate the problem:
Usually additional select columns are not much of a problem, but with a
subselect this is different. For example, to retain only one book per author,
one would write:
"DELETE FROM BOOK WHERE BOOK_ID NOT IN (SELECT MIN(BOOK_ID) FROM BOOK GROUP BY
AUTHOR_ID)");
This is a perfectly valid query in oracle, and I cannot create it with the
current Criteria API so I have to resort to String query creation :-(
> GroupBy adds columns to the select clause
> -----------------------------------------
>
> Key: TORQUE-320
> URL: https://issues.apache.org/jira/browse/TORQUE-320
> Project: Torque
> Issue Type: Bug
> Components: Runtime
> Affects Versions: 4.0
> Reporter: Thomas Fox
>
> If I create a Criteria, define the select columns manually and then add
> groupBy Columns, SqlBuilder adds the groupBy Columns to the select columns
> One should be able to create GROUP BY Queries without adding the columns to
> the select clause
--
This message was sent by Atlassian JIRA
(v6.2#6252)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
