Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-22199

Sql. No validation for duplicates of CTE aliases

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • sql
    • Docs Required, Release Notes Required

    Description

      The query below contains two CTE with the same alias name and executed with no error, and returns a result for the last alias.

      with CTE1 as (select 42), CTE1 as (select 43) select * FROM CTE1; 

      For such a situation it should be thrown a validation error.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              jooger Iurii Gerzhedovich
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: