[
https://issues.apache.org/jira/browse/FLINK-14100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17100030#comment-17100030
]
Flavio Pompermaier commented on FLINK-14100:
--------------------------------------------
I used this scripts to test the upsert query and the get query..the table is
very simple (just 2 fields).
Do you have a minimal test to run?
{code:java}
DROP TABLE TEST;
CREATE TABLE test
(
id numeric(10) not null,
name varchar2(50) not NULL,
CONSTRAINT supplier_pk PRIMARY KEY (id)
);
-- case sensitive version
MERGE INTO "TEST" t
USING (SELECT 1 "ID", 'xxxx' "NAME" FROM DUAL) s
ON (t."ID"=s."ID")
WHEN MATCHED THEN UPDATE SET t."NAME"=s."NAME"
WHEN NOT MATCHED THEN INSERT (t."ID", t."NAME") VALUES (s."ID", s."NAME")
-- case insensitive version
MERGE INTO test t
USING (SELECT 1 id, 'xxxx' name FROM DUAL) s
ON (t.id=s.id)
WHEN MATCHED THEN UPDATE SET t.name=s.name
WHEN NOT MATCHED THEN INSERT (t.id, t.name) VALUES (s.id, s.name)
SELECT * FROM test;
{code}
> Introduce OracleDialect
> -----------------------
>
> Key: FLINK-14100
> URL: https://issues.apache.org/jira/browse/FLINK-14100
> Project: Flink
> Issue Type: Sub-task
> Components: Connectors / JDBC
> Reporter: Canbin Zheng
> Assignee: Flavio Pompermaier
> Priority: Major
> Labels: pull-request-available
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
