[MDEV-4634] Crash in CONVERT_TZ Created: 2013-06-10  Updated: 2013-06-28  Resolved: 2013-06-28

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.3, 5.5.31, 5.3.12
Fix Version/s: 5.5.32, 5.3.13

Type: Bug Priority: Critical
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None


 Description   

This query crashes the server (debug build):

SELECT CONVERT_TZ(GREATEST(DATE('2021-00-00'),DATE('2021-00-00')),'+00:00','+7:5');

So does this one:

SELECT CONVERT_TZ(GREATEST(TIMESTAMP('2021-00-00'),TIMESTAMP('2021-00-00')),'+00:00','+7:5');



 Comments   
Comment by Alexander Barkov [ 2013-06-10 ]

#4 tztime.cc:799: my_time_t sec_since_epoch(int, int, int, int, int, int): Assertion `mon > 0 && mon < 13' failed
#5 0x00000000006df9f9 in Time_zone_offset::TIME_to_gmt_sec (this=0x2887d40,
t=0x7fffcc2e92f0, error_code=0x7fffcc2e9324)
at /home/bar/maria-bzr/maria-10.0-connect/sql/tztime.cc:1385
#6 0x00000000006dc801 in TIME_to_timestamp (thd=0x2b1b920, t=0x7fffcc2e92f0,
error_code=0x7fffcc2e9324)

Generated at Thu Feb 08 06:57:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.