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

field names are unexpected after ProjectRemoveRule applied

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Not A Problem
    • 1.17.0
    • 1.18.0
    • core
    • None

    Description

      @Test public void testProjectRemove() {
          final String sql = "select name as n from (select name from dept) t";
          sql(sql).withRule(ProjectRemoveRule.INSTANCE).check();
        }
      

      currently, the result plan is:

      plan

      LogicalProject(NAME=[$1])
      LogicalTableScan(table=[[CATALOG, SALES, DEPT]])

      the filed name of LogicalProject should be `N` instead of `NAME`

      Attachments

        Activity

          People

            julianhyde Julian Hyde
            godfreyhe godfrey he
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: