Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19162 Some basic datatypes and functions in oracle compatibility mode do not work
  3. MDEV-20025

ADD_MONTHS() Oracle function

Details

    Description

      This function is used to add / subtract months from a given date/datetime value.

      It's very similar to DATE_ADD() function in MariaDB.

      MariaDB: DATE_ADD(sysdate(), interval 5 months)
      Oracle: ADD_MONTHS(sysdate, 5)

      Oracle Doc: https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions004.htm

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25752 ADD_MONTHS with a non-integer argument gives a different result on Oracle compared to MariaDB

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            Faisal Faisal Saeed (Inactive) created issue -
            bar Alexander Barkov made changes -
            Field Original Value New Value
            Labels Compatibility
            woqutech.com woqutech.com made changes -
            Attachment 10.6-add_months [ 55505 ]
            woqutech.com woqutech.com added a comment -

            The patch is implement add_months funcions using Item_date_add_interval(thd, $3, $5, INTERVAL_MONTH, 0), please review the patch, thanks!

            woqutech.com woqutech.com added a comment - The patch is implement add_months funcions using Item_date_add_interval(thd, $3, $5, INTERVAL_MONTH, 0), please review the patch, thanks!
            woqutech.com woqutech.com made changes -
            Attachment 10.6-add_months [ 55505 ]
            woqutech.com woqutech.com made changes -
            Attachment 10.6-add_months.patch [ 55518 ]
            monty Michael Widenius made changes -
            Assignee Michael Widenius [ monty ]
            monty Michael Widenius added a comment -

            I looked at the patch and it looks ok.
            I will push it in to bb-10.6-monty today and into 10.6 next week

            monty Michael Widenius added a comment - I looked at the patch and it looks ok. I will push it in to bb-10.6-monty today and into 10.6 next week
            monty Michael Widenius made changes -
            Component/s Data Definition - Procedure [ 10119 ]
            Fix Version/s 10.6.0 [ 24431 ]
            Affects Version/s 10.6 [ 24028 ]
            monty Michael Widenius made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            monty Michael Widenius made changes -
            Summary sql_mode="oracle" does not support "ADD_MONTHS()" function ADD_MONTHS() Oracle function
            serg Sergei Golubchik made changes -
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.6.0 [ 24431 ]
            serg Sergei Golubchik made changes -
            issue.field.resolutiondate 2021-05-20 09:30:24.0 2021-05-20 09:30:24.747
            serg Sergei Golubchik made changes -
            Component/s Server [ 13907 ]
            Component/s Data Definition - Procedure [ 10119 ]
            Fix Version/s 10.6.1 [ 24437 ]
            Fix Version/s 10.6 [ 24028 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            greenman Ian Gilfillan made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 98151 ] MariaDB v4 [ 156465 ]

            People

              monty Michael Widenius
              Faisal Faisal Saeed (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.