[
https://issues.apache.org/jira/browse/CALCITE-2211?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16399146#comment-16399146
]
Julian Hyde commented on CALCITE-2211:
--------------------------------------
Just curious, what is the JDBC type of that "bigint(20) unsigned" column? It is
definitely not BIGINT because SQL standard BIGINT is 64 bit signed. What does
MySQL print when you describe the columns in the table?
It's helpful if when we use a type name we are explicit what type system it
belongs to. For instance, when [~suez1224] mentions {{Decimal}} above he is
referring to the [C sharp decimal
type|https://docs.microsoft.com/en-us/dotnet/csharp/language-reference/keywords/decimal],
not the SQL DECIMAL type.
> Type of BigInteger should be BIGINT
> -----------------------------------
>
> Key: CALCITE-2211
> URL: https://issues.apache.org/jira/browse/CALCITE-2211
> Project: Calcite
> Issue Type: Bug
> Affects Versions: 1.15.0
> Reporter: Eyal Segal
> Assignee: Julian Hyde
> Priority: Major
>
> Vertica DB returns BigInteger values as BigInteger. It seems thatÂ
> JavaToSqlTypeConversionRules doesn't support mapping between BigInteger to
> BIGINT.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
