[
https://issues.apache.org/jira/browse/FLINK-17657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17107084#comment-17107084
]
lun zhang edited comment on FLINK-17657 at 5/14/20, 8:39 AM:
-------------------------------------------------------------
Thank for your replay. It seem not ok.I try and get the follow exception.
[ERROR] Could not execute SQL statement. Reason:
java.lang.ClassCastException: java.math.BigInteger cannot be cast to
java.math.BigDecimal
It's seem the jdbc read the id fielf as java.math.BigInteger.And Sql DataType
not support java.math.BigInteger only support (Long)
was (Author: zhanglun):
Thank for your replay. It seem not ok.I try and get the follow exception.
[ERROR] Could not execute SQL statement. Reason:
java.lang.ClassCastException: java.math.BigInteger cannot be cast to
java.math.BigDecimal
> jdbc not support read BIGINT UNSIGNED field
> -------------------------------------------
>
> Key: FLINK-17657
> URL: https://issues.apache.org/jira/browse/FLINK-17657
> Project: Flink
> Issue Type: Bug
> Components: Connectors / JDBC, Table SQL / Client
> Affects Versions: 1.10.0, 1.10.1
> Reporter: lun zhang
> Priority: Major
> Fix For: 1.11.0
>
> Attachments: env.yaml, excetion.txt
>
>
> I use sql client read mysql table, but I found I can't read a table contain
> `BIGINT UNSIGNED` field. It will
> Caused by: java.lang.ClassCastException: java.math.BigInteger cannot be cast
> to java.lang.Long
>
> MySQL table:
>
> create table tb
> (
> id BIGINT UNSIGNED auto_increment comment '自增主键'
> primary key,
> cooper BIGINT(19) null ,
> user_sex VARCHAR(2) null
> );
>
> my env yaml is env.yaml .
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
