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

Explicitly set session time_zone shows UTC time

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • None
    • N/A
    • N/A
    • None

    Description

      This occurs with both 10.5.9 and 10.5.11 built under Yocto 3.3, both with "genericx86-64" and "intel-corei7-64" CPU tuning builds.

      The timezone database from /usr/share/zoneinfo is loaded.

      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A
       
      Welcome to the MariaDB monitor.  Commands end with ; or \g.
      Your MariaDB connection id is 35
      Server version: 10.5.11-MariaDB-log MariaDB Server
       
      Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      MariaDB [dtd]> select @@global.time_zone, @@session.time_zone, now(), localtime(), utc_timestamp();
      +--------------------+---------------------+---------------------+---------------------+---------------------+
      | @@global.time_zone | @@session.time_zone | now()               | localtime()         | utc_timestamp()     |
      +--------------------+---------------------+---------------------+---------------------+---------------------+
      | SYSTEM             | SYSTEM              | 2021-07-06 07:55:08 | 2021-07-06 07:55:08 | 2021-07-06 05:55:08 |
      +--------------------+---------------------+---------------------+---------------------+---------------------+
      1 row in set (0.001 sec)
       
      MariaDB [dtd]> set time_zone = "US/Eastern";
      Query OK, 0 rows affected (0.001 sec)
       
      MariaDB [dtd]> select @@global.time_zone, @@session.time_zone, now(), localtime(), utc_timestamp();
      +--------------------+---------------------+---------------------+---------------------+---------------------+
      | @@global.time_zone | @@session.time_zone | now()               | localtime()         | utc_timestamp()     |
      +--------------------+---------------------+---------------------+---------------------+---------------------+
      | SYSTEM             | US/Eastern          | 2021-07-06 05:55:25 | 2021-07-06 05:55:25 | 2021-07-06 05:55:25 |
      +--------------------+---------------------+---------------------+---------------------+---------------------+
      1 row in set (0.001 sec)
      

      Can it be a configuration problem or an issue with the particular build?

      Attachments

        Activity

          People

            Unassigned Unassigned
            zboszor Zoltán Böszörményi
            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.