[
https://issues.apache.org/jira/browse/FLINK-17657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
lun zhang updated FLINK-17657:
------------------------------
Description:
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 .
was:
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 .
> 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)
