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

Improve simplification of '(x < y) IS NOT TRUE' when x and y are not nullable

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.34.0
    • 1.35.0
    • core

    Description

      Currently '(1 < x) IS NOT TRUE' when pulled up predicates contain 'x IS NOT NULL' is not simplified, and keeps it as it is.
       
      It can and should be simplified to '1 >= x', which is more concise and useful for further simplification, such as CALCITE-5780
       
      Note that this Jira is splited from CALCITE-5780, which makes this part of codes more clear, and follows the principle that a Jira only discusses one issue.

      Attachments

        Issue Links

        Activity

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

          People

            Runking Runkang He
            Runking Runkang He
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment