Uploaded image for project: 'Tajo (Retired)'
  1. Tajo (Retired)
  2. TAJO-249

Wrong evaluation case of boolean expression

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Critical
    • Resolution: Cannot Reproduce
    • None
    • 0.2-incubating
    • Planner/Optimizer
    • None

    Description

      The below boolean expressions causes wrong evaluation results.

      WHERE date_a BETWEEN 20130705 AND 20130715
        AND ((date_b BETWEEN 20100101 AND 20120601) OR date_b > 20130715)
        AND (date_c < 20120601 OR date_c > 20130715)
        AND date_d > 20130715
      

      Attachments

        Activity

          People

            hyunsik Hyunsik Choi
            hyunsik Hyunsik Choi
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: