Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1535

Give error if ORDER BY clause references ambiguous column name

          Details

          • Type: Improvement
          • Status: Closed
          • Priority: Major
          • Resolution: Fixed
          • Affects Version/s: 1.11.0
          • Fix Version/s: 1.12.0
          • Component/s: None
          • Labels:
            None

            Description

            When I use calcite, I found follow sql can convert to a RelNode correctly.

             
SELECT id AS t1, name AS t1 FROM T ORDER BY t1

            The column name t1 for ORDER BY is ambiguous, should check at validation?

              Attachments

                Activity

                  People

                  • Assignee:
                    julianhyde Julian Hyde
                    Reporter:
                    dongming Dongming Liu
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: