[DRILL-3225] SQL parser seems to ignore specified <fractional seconds precision>

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: SQL Parser
• Assignee: Unassigned
• Reporter: Daniel Barclay
• Created: 31/May/15 06:22
• Updated: 01/Oct/15 16:37

Description

Drill's SQL parser and/or type processing seem to ignore the fractional seconds precision value specified in a <fractional seconds precision> for a datetime or interval type.

In one case, a type descriptor of TIME(5) yields a RelDataType whose getFullTypeString() returns "TIME(0)".

In another, a type descriptor of "INTERVAL HOUR TO SECOND(3)" yields a RelDataType whose getFullTypeString() returns "INTERVAL HOUR TO SECOND". Additionally, calling .getIntervalQualifier().getFractionalSecondPrecision( DrillRelDataTypeSystem.DRILL_REL_DATATYPE_SYSTEM ) yields 6 (a default value?) instead of 3.

(This behavior was seen in INFORMATION_SCHEMA code listing data for a view created using casts with the above type descriptors.)

Issue Links

• relates to: DRILL-3244 Start unit precision getting into fractional seconds precision in View.FieldType serialization
• relates to: DRILL-3216 Fix existing(+) INFORMATION_SCHEMA.COLUMNS columns