Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-29102

system_time_zone is incorrect on Windows when TZ is set

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.6.8
    • 10.6.11, 10.7.7, 10.8.6, 10.9.4, 10.10.2
    • Variables
    • None
    • Microsoft Windows [Version 10.0.18363.2274]
      official MSI build

    Description

      On Windows, the global variable system_time_zone doesn't properly reflect the used time zone when the environment variable TZ is set.

      For example, on my system configured for region Germany, but TZ is set as "CST-8":
      SELECT @@time_zone, @@system_time_zone, TIMEDIFF(NOW(), UTC_TIMESTAMP());
      SYSTEM Europe/Berlin 08:00:00
      Whereas in Linux it returns
      SYSTEM CST 08:00:00

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19243 Fix timezone handling on Windows to report POSIX timezone names

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            sweiser Sebastian Weiser created issue -
            sweiser Sebastian Weiser made changes -
            Field Original Value New Value
            serg Sergei Golubchik made changes -
            Assignee Vladislav Vaintroub [ wlad ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.6 [ 24028 ]
            wlad Vladislav Vaintroub made changes -
            wlad Vladislav Vaintroub made changes -
            Status Open [ 1 ] Needs Feedback [ 10501 ]
            elenst Elena Stepanova made changes -
            Status Needs Feedback [ 10501 ] Open [ 1 ]
            wlad Vladislav Vaintroub made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            wlad Vladislav Vaintroub made changes -
            wlad Vladislav Vaintroub made changes -
            Fix Version/s 10.6.11 [ 28441 ]
            Fix Version/s 10.7.7 [ 28442 ]
            Fix Version/s 10.8.6 [ 28443 ]
            Fix Version/s 10.9.4 [ 28444 ]
            Fix Version/s 10.10.2 [ 28410 ]
            Fix Version/s 10.6 [ 24028 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]

            People

              wlad Vladislav Vaintroub
              sweiser Sebastian Weiser
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.