PL/SQL parser - Phase 2 (MDEV-10764)

[MDEV-12085] sql_mode=ORACLE: allow derived tables not to have aliases Created: 2017-02-20  Updated: 2021-05-11

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Technical task Priority: Major
Reporter: Alexander Barkov Assignee: Unassigned
Resolution: Unresolved Votes: 1
Labels: Compatibility


 Description   

Oracle does not require derived tables to have aliases:

SQL> SELECT * FROM (SELECT * FROM t1) WHERE a=20;
 
 
 
	 A
 
----------
 
	20

MariaDB returns an error for the same query:

MariaDB [test]> SELECT * FROM (SELECT * FROM t1) WHERE a=20;
 
ERROR 1248 (42000): Every derived table must have its own alias

When running in sql_mode=ORACLE, we'll allow derived tables not to have aliases.
Generated at Thu Feb 08 07:55:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.