You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Shengkai Fang (Jira)" <ji...@apache.org> on 2022/05/19 02:26:00 UTC
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=17539167#comment-17539167 ]
Shengkai Fang commented on FLINK-27683:
---------------------------------------
The main reason is that it tries to cast the SqlTabelRef to SqlIdentifier.
> 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 / Runtime
> Affects Versions: 1.14.0
> Reporter: Xin Yang
> Priority: Major
> 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)