Uploaded image for project: 'Flink'
  1. Flink
  2. FLINK-27683

Insert into (column1, column2) Values(.....) fails with SQL hints

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    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

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            xuanyu66 Xin Yang
            xuanyu66 Xin Yang
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment