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

Adding +1 to a date give error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 10.3.15
    • Fix Version/s: N/A
    • Component/s: Temporal Types
    • Labels:
      None
    • Environment:
      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.png
          sql error.png
          212 kB
        2. sql error 2.png
          sql error 2.png
          218 kB
        3. sql error 3.png
          sql error 3.png
          227 kB

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration