Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-1133

zoneinfo.sql does not contain UTC but UCT!

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 3.3.1
    • N/A
    • Other
    • None
    • Windows 11 Pro, DBeaver 23.0.0, ASUS mobo, AMD CPU 16 kernels 32 threads, 65GB RAM.

    Description

      Has test environment Win 11 pro set to UTC+1. Had problems with DST in accessing Mariadb db in 10.11.3. Was a DST problem. Settings driver 3.3.1 to allowLoadLocalInfile true, and serverTimezone UTC+1.

      Got the ZONEINFO.SQL (downloaded 2023-12-05) and installed, and just SET GLOBAL times_zone and SESSION times_zone to UTC+1, but got an error.

      Subsequent investigation via SELECT mysql.time_zone_name limit 2000; I found out that there was no UTC, but UCT! same for posix/UCT! Tested via DBeaver and in KNIME, in KNIME breaks without any error msg.

      Attachments

        Activity

          People

            diego dupin Diego Dupin
            bommare Bo Mattsson
            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.