[CALCITE-2299] TIMESTAMPADD(SQL_TSI_FRAC_SECOND) should be nanoseconds not microseconds

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.16.0
• Fix Version/s: 1.17.0, avatica-1.13.0
• Component/s: core
• Assignee: Julian Hyde
• Reporter: James Duong
• Created: 03/May/18 17:09
• Updated: 20/Jul/18 08:18
• Resolved: 09/Jul/18 08:35

Description

When calling TIMESTAMPADD with the first parameter SQL_TSI_FRAC_SECOND and the JDBC escape sequence, this gets interpreted as microseconds when it should be interpreted as nanoseconds.

 

From the ODBC spec on MSDN:

https://docs.microsoft.com/en-us/sql/odbc/reference/appendixes/time-date-and-interval-functions?view=sql-server-2017

'where fractional seconds are expressed in billionths of a second.'

Issue Links

• relates to: CALCITE-2281 TIMESTAMPADD(MICROSECOND, ...) returns incorrect results
• links to: GitHub Pull Request #58
• links to: GitHub Pull Request #60
• links to: GitHub Pull Request #731