[GitHub] [flink] dusukang commented on pull request #19741: [FLINK-27794][connector/jdbc] The primary key obtained from MySQL is incorrect by using MysqlCatalog

[GitBox <gi...@apache.org>]

dusukang commented on PR #19741:
URL: https://github.com/apache/flink/pull/19741#issuecomment-1141125489

   > I don't reproduce the problem in the issue. Could you also tell us which MySql version you use and the mysql driver version?
   
   Thank you very much for your reply, My MySQL version is 8.0.16. There is a table named mysql.`user` in the MySQL, when i create a table named `user` and get the primary key, but the returned primary key is of mysql.`user`.  It while happen when there are tables which have the same name in different databases, when we use catalog to get the primary key for a table, the result may be from other tables which have same names. Can you help me verify it?
   
   This is my case:
   [https://issues.apache.org/jira/browse/FLINK-27794](url)
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@flink.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org