[drupal-devel] LOCK vs. SELECT FOR UPDATE

[Moshe Weitzman]

Karoly Negyesi wrote:
>>> I think that I do now recall why we are looking up the next ID first: If
>>> we use mysql_insert_id we risk not getting the right ID.
> 
> 
> Per mysql doc:
> 
> "For LAST_INSERT_ID(), the most recently generated ID is maintained in 
> the  server on a per-connection basis. It is not changed by another 
> client."
> 
> I fail to see how could we no get the right ID.


Do successive requests from the same web server reuse the same connection?