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

                Issue Links

                relates to

                Bug - A problem which impairs or prevents the functions of the product. CALCITE-2977 Exception is not thrown out when there are ambiguous field in select list

                • Major - Major loss of function.
                • Resolved

                  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: