Anyone who can tell me how to do an update operation with *join table*?
I have tried the SQL below:
1.update A set A.a1=1 join table(devId varchar=?) B on A.devId=B.devId *SQL
ERROR*
2.update A, table(devId varchar=?) B set A.a2=1 where A.devId=B.devId *SQL
ERROR*
3.update A set A.a1=1 where A.devId in (select table.devId from table(devId
varchar = ?)) *amost 2 second with 2048 records*
4.update A set A.a1=1 where A.devId in ('1', '2', ..., '2408') *about 600ms
with 2048 records*
It seemed that h2 database does not support first two SQL according to my
test.
And the third SQL has worse performance than the forth, I also do not know
why.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
