Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-29696

uhelpful error message for timedate in the DST non-existing hour

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.2.24
    • None
    • Temporal Types, Time zones
    • None
    • debian 9

    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"

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              mvalsasna MAtteo Valsasna
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.