Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.2.24
-
None
-
None
-
debian 9
Description
steps to reproduce:
- set current timezone to a timezone with DST
- this means that there is tipycally one hour in the year that does not exist (when the local clock is moved forward).
- 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:
- 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"
Attachments
Issue Links
- relates to
-
MDEV-10068 Invalid datetime format: 1292 Incorrect datetime value: '2011-03-27 02:47:26'
- Closed