[
https://issues.apache.org/jira/browse/TORQUE-320?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14100054#comment-14100054
]
Thomas Vandahl commented on TORQUE-320:
---------------------------------------
My point just was that I remember especially Oracle barking on me because the
column used in the GROUP BY clause was not listed in the selected columns. I
don't know when this happens, it might be a totally unrelated case. You have
much more Oracle experience than I. In my case the different methods would not
have helped much because it's the database that throws the error.
I just wanted to make sure that Torque does not create invalid SQL for some
DBs. I'm unhappy with the ILIKE operator already.
> 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]