You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by "Thomas Fox (JIRA)" <ji...@apache.org> on 2012/06/08 06:51:23 UTC

[jira] [Commented] (TORQUE-7) joins should support join operators other than equal

    [ https://issues.apache.org/jira/browse/TORQUE-7?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13291547#comment-13291547 ] 

Thomas Fox commented on TORQUE-7:
---------------------------------

It is now possible to add composite join conditions by using the criteria.Criteria.addJoin(Strin, String, Criterion, JoinType) method.
With composite join conditions, it is not always possible to determine the joined tables from the join condition, therefore the tables to be added to the FROM clause must be specified explicitly.
Thanks to Graham Leggett for an initial patch.
                
>  joins should support join operators other than equal
> -----------------------------------------------------
>
>                 Key: TORQUE-7
>                 URL: https://issues.apache.org/jira/browse/TORQUE-7
>             Project: Torque
>          Issue Type: Improvement
>          Components: Runtime
>    Affects Versions: 3.0, 3.1, 3.1.1, 3.2
>            Reporter: Thomas Fox
>            Assignee: Thomas Fox
>            Priority: Minor
>             Fix For: 4.0
>
>
>  At the moment, it is not possible to create joins like
> select * from book,author where book.author_id <> author.author_id;
> The most flexibe thing was if one could create a join using a criteria object.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org