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
          Faisal Faisal Saeed (Inactive) created issue -
          bar Alexander Barkov made changes -
          Field Original Value New Value
          Labels Cinoa
          bar Alexander Barkov made changes -
          Labels Cinoa Compatibility
          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?
          bar Alexander Barkov made changes -
          Labels Compatibility Compatibility need_feedback
          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]
          greenman Ian Gilfillan made changes -
          Labels Compatibility need_feedback Compatibility
          woqutech woqutech made changes -
          Attachment 10.6-minus.path [ 55504 ]
          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
          monty Michael Widenius made changes -
          Fix Version/s 10.6 [ 24028 ]
          serg Sergei Golubchik made changes -
          Assignee Michael Widenius [ monty ]
          serg Sergei Golubchik made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          serg Sergei Golubchik made changes -
          issue.field.resolutiondate 2021-05-20 09:28:55.0 2021-05-20 09:28:55.941
          serg Sergei Golubchik made changes -
          Component/s Server [ 13907 ]
          Fix Version/s 10.6.1 [ 24437 ]
          Fix Version/s 10.6 [ 24028 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 98147 ] MariaDB v4 [ 156464 ]

          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.