Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19162 Some basic datatypes and functions in oracle compatibility mode do not work
  3. MDEV-20021

sql_mode="oracle" does not support MINUS set operator

Details

    Description

      This is already available in MariaDB as "EXCEPT"

      returns the Result of the query 1 that is not found in the result of query 2

      MariaDB [world]> select * From City where id between 456 and 457 except select * from City where id=456;
      		 
      +-----+------------+-------------+----------+------------+
      		 
      | ID  | Name       | CountryCode | District | Population |
      		 
      +-----+------------+-------------+----------+------------+
      		 
      | 457 | Birmingham | GBR         | England  |    1013000 |
      		 
      +-----+------------+-------------+----------+------------+

      Oracle Doc: https://www.techonthenet.com/oracle/minus.php

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          bar Alexander Barkov added a comment - - edited

          Faisal Is the task to support the MINUS keyword as a synonym to EXCEPT in this context?
          Or does Oracle's MINUS work somehow differently from MariaDB EXCEPT?

          bar Alexander Barkov added a comment - - edited Faisal Is the task to support the MINUS keyword as a synonym to EXCEPT in this context? Or does Oracle's MINUS work somehow differently from MariaDB EXCEPT?
          greenman Ian Gilfillan added a comment -

          Yes, a synonym, as Oracle's MINUS is the equivalent of EXCEPT [DISTINCT]

          greenman Ian Gilfillan added a comment - Yes, a synonym, as Oracle's MINUS is the equivalent of EXCEPT [DISTINCT]
          woqutech woqutech added a comment -

          the patch in attachment is mapping MINUS to EXCEPT, please review it. thanks!

          woqutech woqutech added a comment - the patch in attachment is mapping MINUS to EXCEPT, please review it. thanks!
          monty Michael Widenius added a comment -

          Patch ok. Will add to my 10.6 tree

          monty Michael Widenius added a comment - Patch ok. Will add to my 10.6 tree

          People

            monty Michael Widenius
            Faisal Faisal Saeed (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 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.