[ARROW-13281] [C++][Gandiva] Error on timestampDiffMonth function behavior for negative diff values

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 5.0.0
• Component/s: C++ - Gandiva
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/28960
• Assignee: João Pedro Antunes Ferreira
• Reporter: João Pedro Antunes Ferreira
• Created: 07/Jul/21 13:38
• Updated: 11/Jan/23 08:32
• Resolved: 15/Jul/21 16:09

Description

The TIMESTAMPDIFF function appears to return incorrect values when a negative number should be returned.

Example:

• For the inputs TIMESTAMPDIFFMONTH("2019-06-30", "2019-03-31") it should return -3, but it returns -1
• For the inputs TIMESTAMPDIFFMONTH("2019-06-30", "2019-05-31") it should return -1, but it returns 1

Issue Links

• links to: GitHub Pull Request #10674