Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-14961

Calcite engine. Arithmetic operators cannot be applied to <DATE> + <INTEGER>

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • sql
    • None
    • Docs Required, Release Notes Required

    Description

      The query
      SELECT CAST('2000-10-10' AS DATE) + 2
      fails with SqlValidatorException

      Cannot apply '+' to arguments of type '<DATE> + <INTEGER>'. Supported form(s): '<NUMERIC> + <NUMERIC>'
      '<DATETIME_INTERVAL> + <DATETIME_INTERVAL>'
      '<DATETIME> + <DATETIME_INTERVAL>'
      '<DATETIME_INTERVAL> + <DATETIME>'
      

      Tests:
      function/date/test_extract_edge_cases.test_ignore

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              tledkov-gridgain Taras Ledkov
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: