Uploaded image for project: 'EXASOL Roadmap'
  1. EXASOL Roadmap
  2. EXASOL-2839

Unified syntax for renaming table value constructor

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Fix Version/s: Exasol 7.1.0
    • Component/s: None
    • Labels:
      None

      Description

      Background

      There are different areas in SQL that allow renaming e.g. Table in JOIN, column name, subselect, etc. The renaming can be done with or without "AS" and with or without renaming the columns (depending on the context).

      Improvement

      Table value constructor now can now be used with or without "AS" syntax for renaming or completely without renaming the columns.

      Examples
      All these renamings are now valid syntax.

      select * from SYS.EXA_ALL_COLUMNS;
      select * from SYS.EXA_ALL_COLUMNS T;
      select * from SYS.EXA_ALL_COLUMNS as T;
      
      create table T as values (1) V(V1);
      create table T as values (1) as V(V1);
      
      select * from values (1);
      select * from values (1) V;
      select * from values (1) as V; 
      select * from values (1) V(V1);
      select * from values (1) as V(V1);

        Attachments

          Activity

            People

            • Assignee:
              CaptainEXA Captain EXASOL
              Reporter:
              CaptainEXA Captain EXASOL
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: