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

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

> Roman, what if table in that insert has after insert trigger which also
> inserts records in more tables? I suppose that last_gen_id() with no
> name parameter will return you that value. Is it what people expect from
> that Joomla's function?

Correct. But that is the design behind the MySQL AUTO_INCREMENT column. 
I still do not have a question re. how MySQL behaves when two 
connections use the same user name and perform the insert into the same 
table...

> If we anyway talk about SQL extension - what if we add RETURNING PRIMARY
> KEY? Suppose this can be useful in many cases.

That would work for Joomla, but I am not sure whether it is useful in 
general case. On the other hand, it would be a nice addition to identity 
columns in 3.0.

Roman