[
https://issues.apache.org/jira/browse/CALCITE-2432?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16565295#comment-16565295
]
Iulian Tirzuman edited comment on CALCITE-2432 at 8/1/18 1:18 PM:
------------------------------------------------------------------
-150 is returned by the Microsoft JDBC driver implementation used to connect to
SQL Server and it corresponds to sql_variant data type:
[https://docs.microsoft.com/en-us/sql/t-sql/data-types/sql-variant-transact-sql?view=sql-server-2017]
You can see this information in the debug screenshot that I attached.
was (Author: [email protected]):
-150 is returned by the Microsoft JDBC driver implementation used to connect to
SQL Server and it corresponds to sql_variant data type:
https://docs.microsoft.com/en-us/sql/t-sql/data-types/sql-variant-transact-sql?view=sql-server-2017
> Unknown column types not being handled
> --------------------------------------
>
> Key: CALCITE-2432
> URL: https://issues.apache.org/jira/browse/CALCITE-2432
> Project: Calcite
> Issue Type: Bug
> Reporter: Iulian Tirzuman
> Assignee: Julian Hyde
> Priority: Major
> Attachments: sql type -150.jpg
>
>
> The SQL Server column type sql_variant of table SEQUENCES , column
> START_VALUE which has the dataType -150 and the code
> "SqlType.valueOf(dataType)" fails because it doesn't contain it; it should at
> least configurable to be defaulted to a a default sql type ?
> Here is the link to the code where the issue happens:
> https://github.com/apache/calcite/blob/8b09736870de922b5c0b0b149732ebeacd990437/core/src/main/java/org/apache/calcite/adapter/jdbc/JdbcSchema.java#L319
> I've attached also a screenshot with the debug before the error occurs.
> I've used sqljdbc42.jar as the JDBC driver to connect to SQL Server.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
