Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10142 PL/SQL parser
  3. MDEV-12086

sql_mode=ORACLE: Allow SELECT UNIQUE as a synonym for SELECT DISTINCT

    XMLWordPrintable

    Details

    • Sprint:
      10.2.2-3, 10.2.2-1, 10.2.2-2, 10.2.2-4, 10.1.18

      Description

      Oracle supports SELECT UNIQUE as a synonym for SELECT DISTINCT.

      SQL> SELECT UNIQUE a FROM t1;
      	 A
      ----------
      	30
      	20
      	10
      

      We'll allow the same syntax when running with sql_mode=ORACLE.

        Attachments

          Activity

            People

            Assignee:
            bar Alexander Barkov
            Reporter:
            bar Alexander Barkov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: