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

Implement FilterSortTransposeRule

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.40.0
    • None

    Description

      Do we need this rule?

      from: 

      LogicalFilter(condition=[<($0, 10)])
        LogicalSort(sort0=[$0], dir0=[ASC])
          LogicalProject(EMPNO=[$0])
            LogicalTableScan(table=[[scott, EMP]]) 

      to: 

      LogicalSort(sort0=[$0], dir0=[ASC])
        LogicalFilter(condition=[<($0, 10)])
          LogicalProject(EMPNO=[$0])
            LogicalTableScan(table=[[scott, EMP]]) 

      Attachments

        Issue Links

          Activity

            People

              jensen Zhen Chen
              jensen Zhen Chen
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: