Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16771

<Table Value Constructor> incomplete feature

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Not a Bug
    • 10.3.3, 10.3.8
    • N/A
    • 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.

      Attachments

        Activity

          People

            shagalla Galina Shalygina
            JArmstrong Jon Armstrong
            Votes:
            1 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.