[
https://issues.apache.org/jira/browse/FLINK-17657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17107228#comment-17107228
]
JinxinTang edited comment on FLINK-17657 at 5/14/20, 11:42 AM:
---------------------------------------------------------------
hi, [~zhanglun], Could you please provide code detail to reproduce this issus,
it seems ok in my side, here is my code piece: [code
piece|https://github.com/TJX2014/flink/blob/master-flink17657-jdbc-bigint/flink-examples/flink-examples-batch/src/main/java/org/apache/flink/examples/java/jdbc/JdbcReader.java]
was (Author: jinxintang):
hi, [~zhanglun], Could you please provide code detail to reproduce this issus,
it seems ok in my side, here is my code piece:[code
piece|https://github.com/TJX2014/flink/blob/master-flink17657-jdbc-bigint/flink-examples/flink-examples-batch/src/main/scala/org/apache/flink/examples/scala/jdbc/ReadMysql.scala]
> 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
> 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)
