Torque
  1. Torque
  2. TORQUE-7

joins should support join operators other than equal

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 3.0, 3.1, 3.1.1, 3.2
    • Fix Version/s: 4.0-beta1
    • Component/s: Runtime
    • Labels:
      None
    • Old Scarab Id:
      TRQS258

      Description

      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.

        Activity

        Hide
        Thomas Fox added a comment -

        Other operators can now be used in joinsd by using the method criteria.Criteria.addJoin(Column, SqlEnum,Column, JoinType)

        Show
        Thomas Fox added a comment - Other operators can now be used in joinsd by using the method criteria.Criteria.addJoin(Column, SqlEnum,Column, JoinType)
        Hide
        Thomas Fox added a comment -

        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.

        Show
        Thomas Fox added a comment - 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.

          People

          • Assignee:
            Thomas Fox
            Reporter:
            Thomas Fox
          • Votes:
            2 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development