You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Iulian Tirzuman (JIRA)" <ji...@apache.org> on 2018/08/01 13:19:00 UTC
[jira] [Comment Edited] (CALCITE-2432) Unknown column types not
being handled
[ 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: iulian@tirzuman.ro):
-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)