Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
1.10.0
-
None
-
None
-
Drill 1.10
SQL Server 2016
Description
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"