Details
-
Technical task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
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.