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

Use the server time_zone system variable for functions that it affects in ColumnStore.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 1.4.0, 1.5.3
    • Icebox
    • PrimProc
    • None

    Description

      ColumnStore currently does not use the time_zone system variable in MariaDB server in evaluating functions that are affected by time zone.

      Functions and data types that are affected by time zone are listed here: https://mariadb.com/kb/en/time-zones/#time-zone-effects

      In addition, from_unixtime() also is dependent on the time zone setting.

      The goal of this ticket is to add support for time zone for all affected functions in ColumnStore so that these functions behave consistent to the server.

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MCOL-3867 from_unixtime() not giving expected output for a given time zone

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

          Bug - A problem which impairs or prevents the functions of the product. MCOL-3867 from_unixtime() not giving expected output for a given time zone

          • 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-3868 unix_timestamp() output incorrect when time_zone is not 0:00

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

          Bug - A problem which impairs or prevents the functions of the product. MCOL-3594 Failed tests in the 001 suite in 1.4

          • Major - Major loss of function.
          • Closed
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MCOL-1397 MariaDB session variables should be pushed down into ExeMgr and PrimProc

          • Major - Major loss of function.
          • Closed

          Activity

            People

              tntnatbry Gagan Goel (Inactive)
              tntnatbry Gagan Goel (Inactive)
              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.