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

Fix timezone handling on Windows to report POSIX timezone names

Details

    Description

      For JDBC/Node.js drivers at least, it is necessary to handle timezone information (system_time_zone, @session.time_zone) in the way that is independent from the underlying OS, and also POSIX locale names have to be supported. Currently, POSIX locale names are not accepted, and the server would report a rather unusable "Coordinated Universal Time".

      The task is to make Windows behave like the other OSes do wrt to timezone information.
      The mapping between Windows timezone names and POSIX is given by the "golden standard"

      CLDR data https://unicode.org/repos/cldr/trunk/common/supplemental/windowsZones.xml

      We can parse that to create map the names. It is also possible to find the DST setting and UTC offsets using Windows APIs GetTimezoneInformation etc.

      Attachments

        Issue Links

          causes

          Task - A task that needs to be done. CONJS-62 Support named timezones and daylight savings time

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29102 system_time_zone is incorrect on Windows when TZ is set

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

          Task - A task that needs to be done. MDEV-18948 Package time zone tables for Windows users

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            GeoffMontee Geoff Montee (Inactive) added a comment -

            MDEV-18948 might be related to this.

            GeoffMontee Geoff Montee (Inactive) added a comment - MDEV-18948 might be related to this.
            wlad Vladislav Vaintroub added a comment -

            I fixed only system_time_zone. We're currently discussing how to package checking generated timezone related tables for any platform.

            wlad Vladislav Vaintroub added a comment - I fixed only system_time_zone. We're currently discussing how to package checking generated timezone related tables for any platform.

            People

              wlad Vladislav Vaintroub
              wlad Vladislav Vaintroub
              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.