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

Predicate Pull up above Project enhancement

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.5.0
    • Fix Version/s: 1.6.0
    • Component/s: core
    • Labels:
      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

          Activity

            People

            • Assignee:
              jpullokkaran Laljo John Pullokkaran
              Reporter:
              jpullokkaran Laljo John Pullokkaran

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment