Daniel Barclay (Drill) created DRILL-3225:
---------------------------------------------
Summary: SQL parser seems to ignore specified <fractional seconds
precision>
Key: DRILL-3225
URL: https://issues.apache.org/jira/browse/DRILL-3225
Project: Apache Drill
Issue Type: Bug
Components: SQL Parser
Reporter: Daniel Barclay (Drill)
Assignee: Aman Sinha
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 ) yield 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.)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)