[ https://issues.apache.org/jira/browse/FLINK-27683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Anderson updated FLINK-27683: ----------------------------------- Summary: Insert into (column1, column2) Values(.....) fails with SQL hints (was: Insert into (column1, column2) Values(.....) can't work with sql Hints) > Insert into (column1, column2) Values(.....) fails with SQL hints > ----------------------------------------------------------------- > > Key: FLINK-27683 > URL: https://issues.apache.org/jira/browse/FLINK-27683 > Project: Flink > Issue Type: Bug > Components: Table SQL / Planner > Affects Versions: 1.14.0, 1.16.0, 1.15.1 > Reporter: Xin Yang > Assignee: Xin Yang > Priority: Major > Labels: pull-request-available > Fix For: 1.16.0, 1.15.1, 1.14.6 > > 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)