[h2] Failed on update with inner join

[Tapac]

Example:

FooTable.innerJoin(BarTable).update({ FooTable.foo eq BarTable.bar }) {
   it[BarTable.baz] = 123
}

Exception:

org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "UPDATE FOOTABLE INNER[*] JOIN BARTABLE ON FOOTABLE.ID = BARTABLE.FOO_ID SET BAZ =? WHERE FOOTABLE .FOO = BARTABLE.BAR"; expected "., AS, SET"; 

[JustPRV]

It seems like H2 doesn't support update with join, but exists can be used instead.

BarTable.update({
    exists(FooTable.slice(FooTable.id).select {
        (BarTable.fooId eq FooTable.foo) and (BarTable.bar eq FooTable.foo)
    }
)}) {
    it[baz] = 123
}

UPDATE BARTABLE SET BAZ=? 
WHERE EXISTS (
	SELECT FOOTABLE.ID 
	FROM FOOTABLE 
	WHERE BARTABLE.FOO_ID = FOOTABLE.FOO 
	AND BARTABLE.BAR = FOOTABLE.FOO
)

For cases when a column needs to be updated with value from the joined table, there is MERGE INTO ... WHEN MATCHED THEN UPDATE ... statement.