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

[Leyne, S. <Se...@br...>]

Adriano,

> > We do not have the AUTO_INCREMENT data type, but I was thinking that
> > for the most use cases (80/20 principle), storing the last value used
> > in the
> > gen_id(..) function in the context would do the trick.
> >
> I'd much prefer something like LAST_GEN_ID(<name>). Oracle has
> <name>.curval, so it's like something a database-portable application would
> be capable to use.

Does this represent the next value, the last value for any transaction or the last value for the current transaction?


Sean