[ https://issues.apache.org/jira/browse/FLINK-27683?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17539167#comment-17539167 ]
Shengkai Fang commented on FLINK-27683: --------------------------------------- The main reason is that it tries to cast the SqlTabelRef to SqlIdentifier. > Insert into (column1, column2) Values(.....) can't work with sql Hints > ---------------------------------------------------------------------- > > Key: FLINK-27683 > URL: https://issues.apache.org/jira/browse/FLINK-27683 > Project: Flink > Issue Type: Bug > Components: Table SQL / Runtime > Affects Versions: 1.14.0 > Reporter: Xin Yang > Priority: Major > Attachments: screenshot-1.png, screenshot-2.png > > > When I try to use statement `Insert into (column1, column2) Values(.....)` > with SQL hints, it throw some exception, which is certainly a bug. > > * Sql 1 > {code:java} > INSERT INTO `tidb`.`%s`.`%s` /*+ OPTIONS('tidb.sink.update-columns'='c2, > c13')*/ (c2, c13) values(11111, 12.12) {code} > * > ** result 1 > !screenshot-1.png! > * Sql 2 > {code:java} > INSERT INTO `tidb`.`%s`.`%s` (c2, c13) /*+ > OPTIONS('tidb.sink.update-columns'='c2, c13')*/ values(11111, 12.12) > {code} > * > ** result 2 > !screenshot-2.png! > * Sql 3 > {code:java} > INSERT INTO `tidb`.`%s`.`%s` (c2, c13) values(11111, 12.12) > {code} > * > ** result3 : success -- This message was sent by Atlassian Jira (v8.20.7#820007)