[jira] [Created] (DRILL-3225) SQL parser seems to ignore specified

["Daniel Barclay (Drill) (JIRA)" <ji...@apache.org>]

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)