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

Allow subselects which do not reference a column

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

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

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment