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

Unified syntax for renaming table value constructor

    XMLWordPrintable

    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: