Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-392 TIME datatype is not supported
  3. MCOL-1433

Some functions return non-matching results after data type TIME was added to the functions test suite

    XMLWordPrintable

Details

    • Sub-Task
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • None
    • 1.2.0
    • ExeMgr
    • None
    • 2018-08, 2018-09, 2018-10, 2018-11, 2018-12, 2018-13, 2018-14, 2018-15, 2018-16, 2018-17, 2018-18

    Description

      The following distributed functions in ColumnStore failed functions test after TIME data type was added to the test suite. I have checked some of these functions and found that they are not handling the TIME data type correctly.

      The functions test suite is part of the Autopilot/features test. It compared results returned by MariaDB server and ColumnStore.

      CAST
      CONVERT
      DATE
      DATE_FORMAT
      DATEDIFF
      DAY
      DAYOFMONTH
      DAYOFWEEK
      DAYOFYEAR
      MONTH
      QUARTER
      TIMEDIFF
      TO_DAYS
      WEEK
      WEEK
      WEEKOFYEAR
      YEAR
      DEGREES
      HEX
      INET_NTOA
      LAST_DAY
      MAKEDATE
      MONTHNAME
      NULLIF
      PERIOD_ADD
      STR_TO_DATE
      TIMESTAMPDIFF
      WEEKDAY
      YEARWEEK
      YEARWEEK

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MCOL-1461 Functions not normally used with DATETIME/TIME produce odd results with them

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MCOL-1768 DATE_FORMAT() does not behave like MariaDB

          • Major - Major loss of function.
          • Closed

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              dleeyh Daniel Lee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.