Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
10.3.3, 10.3.8
-
None
-
Current testing environment 10.3.3, also confirmed on 10.3.8
Description
A <table value constructor> is described in the ANSI SQL specification dated around 2011. It's basically considered a <simple table> and can be used in various contexts, including the FROM clause of a SELECT statement (DML).
The following is accepted in 10.3.3 (no documentation found for it):
SELECT * FROM (VALUES (1), (2)) AS xxx; |
SELECT `1` FROM (VALUES (1), (2)) AS xxx; |
SELECT xxx.`3` FROM (VALUES (3), (1)) AS xxx; |
The following is not supported (notice the derived column list, following the correlation name). That derived column list is not supported, but would be nice to have (to fill out the feature).
SELECT xxx.colname FROM (VALUES (3), (1)) AS xxx(colname); |
Clarification: The <table value constructor>, which is fine as is, does not provide reasonable column names, as expected. It's the <derived column list> that is missing, which follows the table alias / <correlation name>. This <derived column list> applies (in the standard) to most types of tables we find in the FROM clause.