Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-3104 Enable Phoenix test cases with Calcite-Phoenix
  3. PHOENIX-3993

Make use of DATETIME_PLUS operator in calcite for arithmetics on DATE and TIME

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      Syntax of arithmetics on DATE or TIME type are different in calcite but in phoenix we can use + and - for the same. For example

      date '2014-02-11' + interval '2' day
      

      So any arithmetics on date or time should replace with it. We need to add it as compatibility change so added calcite-compat-change flag to it.

      Wdyt James R. Taylor Julian Hyde Wei Xue?
      FYI Ankit Singhal.

        Attachments

          Activity

            People

            • Assignee:
              rajeshbabu Rajeshbabu Chintaguntla
              Reporter:
              rajeshbabu Rajeshbabu Chintaguntla
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: