Torque
  1. Torque
  2. TORQUE-185

Allow subselects which do not reference a column

    Details

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

      Description

      Currently it is not possible to create the following prepared statement query:
      select * from TABLE_1 where (select count from TABLE2 where TABLE2.COLUMN1 = TABLE1.COLUMN1 AND TABLE2.COLUMN2=?) = 0;
      It should be possible to create such queries.

        Activity

        Hide
        Thomas Fox added a comment -

        Currently, all tables are added to the from clause of a criteria. Currently the query would have an additional TABLE1 in the inner select clause.
        select * from TABLE_1 where (select count from TABLE2,TABLE1 where TABLE2.COLUMN1 = TABLE1.COLUMN1 AND TABLE2.COLUMN2=?) = 0;

        It must be possible to define the from clause manually.

        Show
        Thomas Fox added a comment - Currently, all tables are added to the from clause of a criteria. Currently the query would have an additional TABLE1 in the inner select clause. select * from TABLE_1 where (select count from TABLE2,TABLE1 where TABLE2.COLUMN1 = TABLE1.COLUMN1 AND TABLE2.COLUMN2=?) = 0; It must be possible to define the from clause manually.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development