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

Adding +1 to a date give error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.3.15
    • N/A
    • Temporal Types
    • None
    • Windows 10 Home

    Description

      I have a table with 2 date fields.
      I used the following query to update one

      update day19 set bdate = ddate+1 where narration like "th card%"

      I received the errors attached.
      I altered the date of the row giving error using sql manager but the error shifted to 31st May.

      It seems the date calculator gets stuck at month ends.

      Since there are no specific data files or error logs required I have not attached them.

      If required I can send them

      Attachments

        1. sql error 2.png
          sql error 2.png
          218 kB
        2. sql error.png
          sql error.png
          212 kB
        3. sql error 3.png
          sql error 3.png
          227 kB

        Activity

          People

            bar Alexander Barkov
            akshatkapo Akshat
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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