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

TIMEDIFF() function can return wrong values

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6.5
    • None
    • None
    • None
    • debian buster

    Description

      If the difference between two datetime values is too large TIMEDIFF() returns the wrong value.

      Example:
      SELECT TIMEDIFF('2022:01:01 00:00:00', '2022:07:01 01:35:00');

      This appears to be because there is an upper limit on a time value. It would be better if calling TIMEDIFF() on two datetimes that overflows this value caused an error so the wrong values are not accidently used.

      Attachments

        Activity

          People

            Unassigned Unassigned
            rdyas Robert Dyas
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.