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

Predicate Pull up above Project enhancement

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.5.0
    • 1.6.0
    • core
    • None

    Description

      Predicate Pull up on Project can also pull up deterministic functions whose arguments are all literals.

      Ex: select r1.x from (select cast('10' as int) as x, y from r1 where y<10)r1 join r2 on r1.x=r2.x;

      Currently deterministic functions involving constants are ignored which results in missed transitive inference.

      Attachments

        Issue Links

          Activity

            People

              jpullokkaran Laljo John Pullokkaran
              jpullokkaran Laljo John Pullokkaran
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: