[ https://issues.apache.org/jira/browse/FLINK-27417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17529784#comment-17529784 ]
Shengkai Fang commented on FLINK-27417: --------------------------------------- [~haojiawei] I think it's not a bug just optimaztion. Do you mind to implement the feature? You can the look up other connectors that implements the SupportsFilterPushDown interface for details. > Flink JDBC SQL Connector:SELECT * FROM table WHERE co > 100; mysql will > execute SELECT * FROM table to scan the whole table > ---------------------------------------------------------------------------------------------------------------------------- > > Key: FLINK-27417 > URL: https://issues.apache.org/jira/browse/FLINK-27417 > Project: Flink > Issue Type: Bug > Components: Connectors / JDBC > Affects Versions: 1.14.0 > Reporter: haojiawei > Priority: Major > > 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; > > -- This message was sent by Atlassian Jira (v8.20.7#820007)