Flink JDBC SQL Connector：SELECT * FROM table WHERE co > 100; mysql will execute SELECT * FROM table to scan the whole table

Use flink cli to create a mysql mapping table, and execute the query SELECT * FROM table WHERE co > 100;Mysql will execute SELECT * FROM table to scan the whole table.

show mysql execute sql:  select * from information_schema.`PROCESSLIST` where info is not null;