[
https://issues.apache.org/jira/browse/FLINK-27683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Xin Yang updated FLINK-27683:
-----------------------------
Description:
* 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
was:
{code:java}
INSERT INTO `tidb`.`%s`.`%s` /*+ OPTIONS('tidb.sink.update-columns'='c2, c13')
(c2, c13) values(11111, 12.12) {code}
!screenshot-1.png!
{code:java}
INSERT INTO `tidb`.`%s`.`%s` (c2, c13) /*+
OPTIONS('tidb.sink.update-columns'='c2, c13') values(11111, 12.12)
{code}
!screenshot-2.png!
{code:java}
INSERT INTO `tidb`.`%s`.`%s` (c2, c13) values(11111, 12.12)
{code}
result : success
> 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: New Feature
> Affects Versions: 1.14.0
> Reporter: Xin Yang
> Priority: Major
> Attachments: screenshot-1.png, screenshot-2.png
>
>
> * 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)
