Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13230

Information about EXCEPT ALL is inconsistent between KB, JIRA, code and tests

    XMLWordPrintable

    Details

      Description

      It is unclear from the available sources whether EXCEPT ALL is supposed to work at all, and if it is, to what extent.

      The KB says that is is not supported:

      ALL is not supported by EXCEPT (and it is difficult to make sense of ALL with EXCEPT).

      MDEV-10140 in scope of which EXCEPT was implemented says that ALL is supported, and explains the semantics (however strange it is):

      With ALL, a row that has m duplicates in the left table and n duplicates in the right table will appear max(m-n,0) times in the result set.

      Also, when EXCEPT ALL is executed in current pre-10.3.1 server, it throws an error, but it's not "unsupported":

      MariaDB [test]> select * from t1 except all select * from t2;
      ERROR 1221 (HY000): Incorrect usage of EXCEPT and ALL
      

      So,

      • if EXCEPT ALL is not supported, I think it's better to throw the corresponding error message rather than Incorrect usage;
      • please reconcile KB with JIRA so they both contain correct information.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.