Uploaded image for project: 'Infinispan'
  1. Infinispan
  2. ISPN-7250

ORA-00928: missing SELECT keyword when inserting entry with Oracle cache store

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 9.0.0.Beta1
    • 9.0.0.Alpha4
    • Loaders and Stores
    • None

    Description

      Tested with Oracle 11g express edition

      Example of query currently sent to Oracle:

      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)
      

      which does not seem valid

      Attachments

        Activity

          People

            gfernand@redhat.com Gustavo Fernandes (Inactive)
            gfernand@redhat.com Gustavo Fernandes (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: