Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
Description
The SQL standard allows for the optional specification of derived table column names in the form of a parenthesized name list following the derived table name.
The implementation of this it "attached" to MDEV-31466.
We will need to update our documentation accordingly.
Here is the relevant syntax specification from a recent SQL standard document.
<table primary> ::=
|
<table or query name>
|
[ <query system time period specification> ]
|
[ <correlation or recognition> ]
|
| <derived table> <correlation or recognition>
|
| <lateral derived table> <correlation or recognition>
|
| <collection derived table> <correlation or recognition>
|
| <table function derived table> <correlation or recognition>
|
| <PTF derived table> [ <correlation or recognition> ]
|
| <only spec> [ <correlation or recognition> ]
|
| <data change delta table> [ <correlation or recognition> ]
|
| <JSON table> <correlation or recognition>
|
| <JSON table primitive> <correlation name>
|
| <parenthesized joined table>
|
 |
<correlation or recognition> ::=
|
[ AS ] <correlation name>
|
[ <parenthesized derived column list> ]
|
Attachments
Issue Links
- relates to
-
MDEV-31466 Add optional correlation column list for derived tables
-
- Closed
-