Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1366

subquery multiple column in statement

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Cannot Reproduce
    • None
    • 1.1.5
    • ExeMgr
    • None
    • 2018-09, 2018-10, 2018-11, 2018-12, 2018-13

    Description

      Hi,

      The following is complaining that a and b are not joined. it is my understanding that this should work : https://mariadb.com/kb/en/library/subquery-limitations/

      select * from a where (x,y) not in (select distinct x,y from b);

      workaround is a little longer to write

      Attachments

        Activity

          People

            rprakash Ravi Prakash (Inactive)
            plinel patrice
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.