Brian,
I have a query that tried to execute, but failed:
update gangs as source, users as dest set source.money = source.money
+ '100', dest.money = if((dest.money - '100') < 0,0,dest.money -
'100') where source.id = '4' and dest.id = '56270' and '100' <=
dest.money
Multi-table updates are not SQL compliant and therefore the parser fails
to extract the table names.
You should split this query in 2 separate update statements inside a
transaction.
Hope this helps,
Emmanuel
--
Emmanuel Cecchet - Research scientist
EPFL - LABOS/DSLAB - IN.N 317
Phone: +41-21-693-7558
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
