Torque
  1. Torque
  2. TORQUE-187

Allow joins with subselects in the FROM clause

    Details

    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 4.0-beta1
    • Fix Version/s: 4.0-beta1
    • Component/s: Runtime
    • Labels:
      None

      Description

      It shall be possible to execute statements like

      SELECT * FROM table1, (SELECT * FROM table2 WHERE xxx) t2 WHERE table1.id = t2.id

      (I know this example can be rewritten as a simple join, the actual use case is more complicated)

      In the case of the Criteria object, this would suggest a call sequence like

      criteria.addAlias("t2", subCriteria);
      criteria.addJoin("t2.id", Table1Peer.ID);

        Activity

        Hide
        Thomas Fox added a comment -

        see org.apache.torque.generated.peer.JoinTest.testImplicitInnerJoinWithSubselect() in the test project for a test case

        Show
        Thomas Fox added a comment - see org.apache.torque.generated.peer.JoinTest.testImplicitInnerJoinWithSubselect() in the test project for a test case

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development