[MDEV-27759] TZ_CONVERT regression Created: 2022-02-04  Updated: 2022-05-16  Resolved: 2022-05-16

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: VAROQUI Stephane Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: None
Environment:

10.8.0-MariaDB-1:10.8.0+maria~focal-log preview for docker image quay.io/mariadb-foundation/mariadb-devel:10.8-mdev-11675-rpl-lag-free-alter


 Description    

??SELECT CONVERT_TZ('2016-01-01 12:00:00','CET', '+01:00');
 
+---------------------------------------------------+
 
| CONVERT_TZ('2016-01-01 12:00:00','CET', '+01:00') |
 
+---------------------------------------------------+
 
| NULL                                              |
 
+---------------------------------------------------+
 
1 row in set (0.019 sec)
 
??



 Comments   
Comment by VAROQUI Stephane [ 2022-02-04 ]

Wrongly reporting this as as a mcol when it should be mdev but i don't found how to convert it . This is a regression confirmed to works on 10.3 and failing on 10.8 early preview

Comment by Sergei Golubchik [ 2022-04-18 ]

works for me. you likely haven't populated time zone tables in your 10.8 installation, so the server doesn't know what is "CET"

Generated at Thu Feb 08 09:55:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.