[infinispan-issues] [JBoss JIRA] (ISPN-6743) Upsert does not work for MySQL

[Krzysztof Sobolewski (JIRA)]

Krzysztof Sobolewski created ISPN-6743:
------------------------------------------

             Summary: Upsert does not work for MySQL
                 Key: ISPN-6743
                 URL: https://issues.jboss.org/browse/ISPN-6743
             Project: Infinispan
          Issue Type: Bug
          Components: Loaders and Stores
    Affects Versions: 9.0.0.Alpha2
            Reporter: Krzysztof Sobolewski


ISPN-20, merged recently (thanks!), added "upsert" support for JDBC cache stores. The "upsert" SQL statement is database-type-dependent and the one for MySQL has a different "API" than the one for other database types - whereas all the others use the same number and order of placeholders as the equvalent INSERT statement, so that the same method can be used to update the INSERT, UPDATE and "upsert" statement, the MySQL one adds additional placeholders and the aforementioned method is no longer sufficient.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)