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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.14.0
• Component/s: Connectors / JDBC
• Assignee: Unassigned
• Reporter: haojiawei
• Created: 26/Apr/22 13:41
• Updated: 29/Apr/22 05:59
• Resolved: 29/Apr/22 05:59

Description

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;

 

 

Issue Links

• is duplicated by: FLINK-16024 Support filter pushdown in JDBC connector