Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-2230

DATE/TIME type math is broken -- TIMEDIFF, TIMESTAMPDIFF and date math

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.2.2
    • Fix Version/s: 1.2.5
    • Component/s: ExeMgr, PrimProc
    • Labels:
      None
    • Sprint:
      2019-04, 2019-05, 2019-06

      Description

      The following regression tests fail:
      TIMEDIFF
      working_tpch1/qa_fe_cnxFunctions/bug3585.sql
      queries return empty
      TIMEDIFF.DM
      some queries fail
      working_tpch1/qa_fe_postProcessedFunctions/TIMEDIFF.DM

      TIMESTAMPDIFF
      working_tpch1/qa_fe_cnxFunctions/fromunixtime.sql
      1 query returns incorrect answer.

      DATE math
      working_tpch1/qa_fe_cnxFunctions/unix_timestamp.sql

      These may or may not be related

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              David.Hall David Hall
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.