maybe the failure wasn't clear. I get the following.
Unique index or primary key violation: "PUBLIC.TEST_AB"; SQL
statement:
MERGE INTO test_ab (AID, AB) KEY (AID)
SELECT test_ab.AID, (test_ab.AB + 2000) FROM test_ab test_ab
INNER JOIN test_a test_a
ON (test_a.ID = test_ab.AID AND test_a.A = 11) [23001-134] 23001/23001
(Help)
org.h2.jdbc.JdbcSQLException: Unique index or primary key violation:
"PUBLIC.TEST_AB"; SQL statement:
MERGE INTO test_ab (AID, AB) KEY (AID)
SELECT test_ab.AID, (test_ab.AB + 2000) FROM test_ab test_ab
INNER JOIN test_a test_a
ON (test_a.ID = test_ab.AID AND test_a.A = 11) [23001-134]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:
316)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.command.dml.Merge.merge(Merge.java:172)
at org.h2.command.dml.Merge.update(Merge.java:128)
at org.h2.command.CommandContainer.update(CommandContainer.java:
70)
at org.h2.command.Command.executeUpdate(Command.java:198)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:
176)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:151)
at org.h2.server.web.WebApp.getResult(WebApp.java:1260)
at org.h2.server.web.WebApp.query(WebApp.java:954)
at org.h2.server.web.WebApp.process(WebApp.java:216)
at org.h2.server.web.WebApp.processRequest(WebApp.java:163)
at org.h2.server.web.WebThread.process(WebThread.java:129)
at org.h2.server.web.WebThread.run(WebThread.java:86)
at java.lang.Thread.run(Thread.java:619)