PL/SQL parser (MDEV-10142)

[MDEV-12086] sql_mode=ORACLE: Allow SELECT UNIQUE as a synonym for SELECT DISTINCT Created: 2017-02-20  Updated: 2020-08-27  Resolved: 2017-02-20

Status: Closed
Project: MariaDB Server
Component/s: Parser
Affects Version/s: None
Fix Version/s: 10.3.0

Type: Technical task Priority: Major
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: Compatibility

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.

 Comments   
Comment by Alexander Barkov [ 2017-02-20 ]

Pushed to bb-10.2-compatibility

Generated at Thu Feb 08 07:55:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.