You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "dusukang (Jira)" <ji...@apache.org> on 2022/05/26 03:40:00 UTC

[jira] [Updated] (FLINK-27794) The primary key obtained from MySQL is incorrect by using MysqlCatalog

     [ https://issues.apache.org/jira/browse/FLINK-27794?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

dusukang updated FLINK-27794:
-----------------------------
    Description: 
I want to use MysqlCatalog to get the information of the database table `user`. The database table creation statement is as follows
{code:java}
CREATE TABLE flinksql_test.`user` (
  `uid` bigint(20) NOT NULL,
  `uname` varchar(36) DEFAULT NULL,
  `others` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8; {code}

> The primary key obtained from MySQL is incorrect by using MysqlCatalog
> ----------------------------------------------------------------------
>
>                 Key: FLINK-27794
>                 URL: https://issues.apache.org/jira/browse/FLINK-27794
>             Project: Flink
>          Issue Type: Bug
>          Components: Connectors / JDBC
>    Affects Versions: 1.15.0
>            Reporter: dusukang
>            Priority: Major
>
> I want to use MysqlCatalog to get the information of the database table `user`. The database table creation statement is as follows
> {code:java}
> CREATE TABLE flinksql_test.`user` (
>   `uid` bigint(20) NOT NULL,
>   `uname` varchar(36) DEFAULT NULL,
>   `others` varchar(128) DEFAULT NULL,
>   PRIMARY KEY (`uid`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8; {code}



--
This message was sent by Atlassian Jira
(v8.20.7#820007)