[CALCITE-4476] DateTimeUtils.timeStringToUnixDate may produce wrong time

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: avatica-1.17.0
• Fix Version/s: avatica-1.18.0
• Component/s: avatica
• Labels: pull-request-available
• Assignee: Vladimir Ozerov
• Reporter: Vladimir Ozerov
• Created: 23/Jan/21 19:32
• Updated: 18/May/21 11:23
• Resolved: 02/Feb/21 19:35

Description

The query SELECT CAST("00:00" as TIME) returns 00:00:01 in Calcite.
The problem is located in the DateTimeUtils.timeStringToUnixDate method that mistakenly assigns 1 to seconds and minutes in some cases.

PR: https://github.com/apache/calcite-avatica/pull/134

Issue Links

• relates to: CALCITE-3881 SqlFunctions#addMonths yields incorrect results in some corner case