Uploaded image for project: 'Torque'
  1. Torque
  2. TORQUE-187

Allow joins with subselects in the FROM clause

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: 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);

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: