Re: Simulating sequences
So, are you saying that because I am using:
UPDATE sequence SET id = LAST_INSERT_ID(id + 1) WHERE sequence_id = 'MySequenceName'
instead of
UPDATE sequence SET id = id + 1 WHERE sequence_id = 'MySequenceName'
that this is why the update statement is sometimes trying to set id to be the same value on two different threads (ie, getting zero rows updated)?
Subject
Written By
Posted
Re: Simulating sequences
July 09, 2014 10:17AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.