[I] [Bug] There is a problem using mysql-to-mysql with sort [inlong]

[via GitHub]

LiJie20190102 opened a new issue, #9199:
URL: https://github.com/apache/inlong/issues/9199

   ### What happened
   
   The data synchronization task I created is from MySQL to MySQL. I use the 
command line to operate sort, and the database information is correct. However, 
I see that the jobmanager log on Flink shows that I cannot find the source 
table I want. Do I need to configure any filtering conditions to do this
   
   
   mysql2mysql.sql
   
   ```
   CREATE TABLE `table_11`(
       `name` STRING)
       WITH (
       'connector' = 'mysql-cdc-inlong',
       'hostname' = '192.168.1.133',
       'database-name' = 'inlong_test',
       'port' = '13306',
       'username' = 'root',
       'password' = 'qsdi1@3',
       'table-name' = 'source_test'
   );
   
   CREATE TABLE `table_22`(
       PRIMARY KEY (`name`) NOT ENFORCED,
       `name` STRING)
       WITH (
   'connector' = 'jdbc-inlong',
       'url' = 'jdbc:mysql://192.168.1.133:13306/inlong_test',
       'username' = 'root',
       'password' = 'qsdi1@3',
       'table-name' = 'target'
   );
   
   INSERT INTO `table_22`
       SELECT
       `name` AS `name`
       FROM `table_11`;
   ```
        
        
   CLI:
   /opt/software/flink/flink-1.13.6/bin/flink run -c 
org.apache.inlong.sort.Entrance /usr/lib/inlong/inlong-sort/sort-dist-1.9.0.jar 
--sql.script.file /home/lj/inlong/mysql2mysql.sql
   
   flink jobmanager log:
   
![image](https://github.com/apache/inlong/assets/53458004/0da1df4e-04df-4964-ac65-523f1ef75aca)
   The log shows that there is actually this table, but it has been filtered 
out.
   
![image](https://github.com/apache/inlong/assets/53458004/744ba0b6-7e50-41c9-8342-a4dc5ad3ba32)
   
   
![image](https://github.com/apache/inlong/assets/53458004/27f6cfa5-0ab6-4f5e-8436-3aa2d708fd50)
   
   
   ### What you expected to happen
   
   Can correctly synchronize MySQL to MySQL data
   
   ### How to reproduce
   
   mysql2mysql.sql
   
   ```
   CREATE TABLE `table_11`(
       `name` STRING)
       WITH (
       'connector' = 'mysql-cdc-inlong',
       'hostname' = '192.168.1.133',
       'database-name' = 'inlong_test',
       'port' = '13306',
       'username' = 'root',
       'password' = 'qsdi1@3',
       'table-name' = 'source_test'
   );
   
   CREATE TABLE `table_22`(
       PRIMARY KEY (`name`) NOT ENFORCED,
       `name` STRING)
       WITH (
   'connector' = 'jdbc-inlong',
       'url' = 'jdbc:mysql://192.168.1.133:13306/inlong_test',
       'username' = 'root',
       'password' = 'qsdi1@3',
       'table-name' = 'target'
   );
   
   INSERT INTO `table_22`
       SELECT
       `name` AS `name`
       FROM `table_11`;
   ```
        
        
   CLI:
   /opt/software/flink/flink-1.13.6/bin/flink run -c 
org.apache.inlong.sort.Entrance /usr/lib/inlong/inlong-sort/sort-dist-1.9.0.jar 
--sql.script.file /home/lj/inlong/mysql2mysql.sql
   
   ### Environment
   
   _No response_
   
   ### InLong version
   
   1.9.0
   
   ### InLong Component
   
   InLong Sort
   
   ### Are you willing to submit PR?
   
   - [X] Yes, I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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: dev-unsubscr...@inlong.apache.org.apache.org

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