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

system_time_zone is incorrect on Windows when TZ is set

    XMLWordPrintable

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

          Activity

            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.