[jira] [Created] (DRILL-5655) Drill returns a VARCHAR when DATE projected by query sent to SQL Server

[N Campbell (JIRA)]

N Campbell created DRILL-5655:
---------------------------------

             Summary: Drill returns a VARCHAR when DATE projected by query sent 
to SQL Server
                 Key: DRILL-5655
                 URL: https://issues.apache.org/jira/browse/DRILL-5655
             Project: Apache Drill
          Issue Type: Bug
          Components:  Server
    Affects Versions: 1.10.0
         Environment: Drill 1.10
SQL Server 2016
            Reporter: N Campbell


A query which projects a DATE literal will return a VARCHAR(65k) if query uses 
SQL Server.

If the query uses a Parquet file a DATE type is returned via JDBC 
If the query uses ORACLE a TIMESTAMP type is returned via JDBC

select DATE '1996-01-01' from x.y.TVERSION



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)