[FLINK-27683] Insert into (column1, column2) Values(.....) fails with SQL hints

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.14.0, 1.15.1, 1.16.0
• Fix Version/s: 1.15.1, 1.16.0, 1.14.6
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: Xin Yang
• Reporter: Xin Yang
• Created: 18/May/22 10:28
• Updated: 27/Oct/23 09:15
• Resolved: 13/Jun/22 08:31

Description

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

  INSERT INTO `tidb`.`%s`.`%s` /*+ OPTIONS('tidb.sink.update-columns'='c2, c13')*/   (c2, c13) values(11111, 12.12) 

• • result 1
    

• Sql 2

  INSERT INTO `tidb`.`%s`.`%s` (c2, c13) /*+ OPTIONS('tidb.sink.update-columns'='c2, c13')*/  values(11111, 12.12)
  

• • result 2
    

• Sql 3

  INSERT INTO `tidb`.`%s`.`%s` (c2, c13)  values(11111, 12.12)
  

• • result3 : success

Issue Links

• is duplicated by: FLINK-26259 Partial insert and partition insert cannot work with sql hint
• links to: GitHub Pull Request #19847
• links to: GitHub Pull Request #19891
• links to: GitHub Pull Request #19892