You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Xin Yang (Jira)" <ji...@apache.org> on 2022/05/30 13:12:00 UTC
[jira] [Comment Edited] (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=17543939#comment-17543939 ]
Xin Yang edited comment on FLINK-27683 at 5/30/22 1:11 PM:
-----------------------------------------------------------
[~fsk119] Would you tell me where can I add an integration test for this sql?
`JdbcDynamicTableSinkITCase`?
was (Author: JIRAUSER289681):
[~fsk119] Would you tell me where can I add an integration test for this sql?
> 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
> 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)