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

Allow joins with subselects in the FROM clause

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 4.0-beta1
    • 4.0-beta1
    • Runtime
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: