[CONJ-1133] zoneinfo.sql does not contain UTC but UCT! Created: 2023-12-06 Updated: 2023-12-13 |
|
| Status: | Open |
| Project: | MariaDB Connector/J |
| Component/s: | None |
| Affects Version/s: | 3.3.1 |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Bo Mattsson | Assignee: | Diego Dupin |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Environment: |
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. |
| Comments |
| Comment by Diego Dupin [ 2023-12-13 ] |
|
Just to understand the problem, where this ZONEINFO.SQL comes from ? |