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 Fix For: 9.0.0.Beta1 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