Re: [Firebird-devel] Simplify MySQL migration: LAST_INSERT_ID()

[Roman R. <ro...@ro...>]

>>> All transactions should get the "right" result, since it is independent of any other transactions.
>>
>> Correct.
>>
> No, that's all wrong!
>
> You'll get values allocated in another connections.

You mean the SELECT gen_id(<name>, 0) case? Yes, that won't work in a 
concurrent environment.

I thought that you're talking about the general requirements.

Roman