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

    • 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

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          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:

              Slack

                Issue deployment