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

[Adriano d. S. F. <adr...@gm...>]

On 26-12-2010 06:55, Roman Rokytskyy wrote:
>> What's wrong with
>> SELECT GEN_ID (<name>,0) from rdb$database
> 
> Nothing, except that I do not know <name>...
> 
>> ?  Does it need to be stored somehow (otherwise)?  Surely poking it into a context variable is just lipstick.
> 
> No, that is not strictly requried.
> 
>> 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.


Adriano