[DRILL-3385] Max. fractional seconds precision less than standard (should be >= 6; is 3)

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Execution - Data Types
• Labels: interval
• Assignee: Unassigned
• Reporter: Daniel Barclay
• Created: 26/Jun/15 05:44
• Updated: 10/Nov/15 18:31

Description

Drill's maximum fractional seconds precision is less than the minimum specified by the SQL standard.

ISO/IEC 9075-2:2011(E) Annex B item 35 subitem p (p. 1329) says:

The maximum value of <time fractional seconds precision> is implementation-defined, but shall not be less than 6.

However, Drill's representation of DAY/HOUR/MINUTE/SECOND intervals seems to carry only integer milliseconds (for only 3 decimal digits of fractional seconds precision).

(Time and timestamp values probably also carry only integer milliseconds.)