[jira] [Updated] (DRILL-5647) Drill pushes timestamp to SQL Server using the wrong data type

["N Campbell (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-5647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

N Campbell updated DRILL-5647:
------------------------------
    Component/s:     (was:  Server)
                 Storage - JDBC

> Drill pushes timestamp to SQL Server using the wrong data type
> --------------------------------------------------------------
>
>                 Key: DRILL-5647
>                 URL: https://issues.apache.org/jira/browse/DRILL-5647
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - JDBC
>    Affects Versions: 1.10.0
>         Environment: Drill 1.10
> SQL Server 2016
>            Reporter: N Campbell
>
> SQL Server  timestamp data type is not a timestamp per ISO-SQL
> https://docs.microsoft.com/en-us/sql/t-sql/data-types/rowversion-transact-sql
> Hence, a statement such as 
> select cast( '2000-12-31 12:00:00.000' as timestamp ) from plugin.schema.table
> will fail due to the following syntax error 
> DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query. 
> SELECT CAST('2000-12-31 12:00:00.000' AS TIMESTAMP(0)) AS "EXPR$0"
> FROM "dbo"."TVERSION"



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