[infinispan-issues] [JBoss JIRA] (ISPN-7250) ORA-00928: missing SELECT keyword when inserting entry with Oracle cache store

[Gustavo Fernandes (JIRA)]

Gustavo Fernandes created ISPN-7250:
---------------------------------------

             Summary: ORA-00928: missing SELECT keyword when inserting entry with Oracle cache store
                 Key: ISPN-7250
                 URL: https://issues.jboss.org/browse/ISPN-7250
             Project: Infinispan
          Issue Type: Bug
          Components: Loaders and Stores
    Affects Versions: 9.0.0.Alpha4
            Reporter: Gustavo Fernandes
            Assignee: Gustavo Fernandes


Tested with Oracle 11g express edition

Example of query currently sent to Oracle:

{code:sql}
MERGE INTO "ISPN_cache" USING (VALUES ('Az4s','030',1)) AS tmp (datum, version, id) ON (datum = tmp.datum) WHEN MATCHED THEN UPDATE SET version = tmp.version, id = tmp.id WHEN NOT MATCHED THEN INSERT (datum, version, id) VALUES (tmp.datum, tmp.version, tmp.id)
{code}

which does not seem valid



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)