[MDEV-25752] ADD_MONTHS with a non-integer argument gives a different result on Oracle compared to MariaDB - Jira

MariaDB:

SELECT ADD_MONTHS('1994-07-07', 2);

+-----------------------------+

| ADD_MONTHS('1994-07-07', 2) |

+-----------------------------+

| 1994-09-07                  |

+-----------------------------+

SELECT ADD_MONTHS('1994-07-07', 2.6);

+-------------------------------+

| ADD_MONTHS('1994-07-07', 2.6) |

+-------------------------------+

| 1994-10-07                    |

+-------------------------------+

Oracle:

SELECT ADD_MONTHS('07-JUL-1994',2) FROM DUAL

ADD_MONTHS('07-JUL-1994',2.6)

07-SEP-94

SELECT ADD_MONTHS('07-JUL-1994',2.6) FROM DUAL

ADD_MONTHS('07-JUL-1994',2)

07-SEP-94

Is this intentional? Also, no warnings.

relates to

MDEV-20025 ADD_MONTHS() Oracle function

Transition	Time In Source Status	Execution Times

Sergei Golubchik made transition - 2021-05-21 15:27

Open

Confirmed

4h 27m

Dave Gosselin made transition - 2023-12-14 20:12

Confirmed

In Progress

937d 4h 44m

Dave Gosselin made transition - 2023-12-21 14:12

In Progress

Closed

6d 18h

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

MariaDB Server