[MDEV-29696] uhelpful error message for timedate in the DST non-existing hour Created: 2022-10-04  Updated: 2022-10-04

Status: Open
Project: MariaDB Server
Component/s: Temporal Types, Time zones
Affects Version/s: 10.2.24
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: MAtteo Valsasna Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

debian 9


Issue Links:
Relates
relates to MDEV-10068 Invalid datetime format: 1292 Incorre... Closed

 Description   

steps to reproduce:

  1. set current timezone to a timezone with DST
    1. this means that there is tipycally one hour in the year that does not exist (when the local clock is moved forward).
  2. when I try to insert or update a timezone value to the non-existing hour, I get the generic "Invalid datetime format: 1292 Incorrect datetime value" error message.
    this does not really help understanding the issue, as the time value entered is formally valid, but is non-existing in the current timezone

expected behaviour:

  1. when I try to insert or update a timezone value to the non-existing hour, I get a more specific error message, that hints to the reason of the issue, e.g.

"Invalid datetime format: 1292 datetime value does not exist in the XX timezone - check DST rules"


Generated at Thu Feb 08 10:10:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.