You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "godfrey he (Jira)" <ji...@apache.org> on 2022/06/13 08:32:00 UTC
[jira] [Closed] (FLINK-27683) Insert into (column1, column2) Values(.....) can't work with sql Hints
[ https://issues.apache.org/jira/browse/FLINK-27683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
godfrey he closed FLINK-27683.
------------------------------
Resolution: Fixed
> 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 / 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
>
> 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)