[Monetdb-developers] [Monetdb-sql-checkins] sql/src/backends/monet5 sql.mx, , 1.321, 1.322 sql_scenario.mx, , 1.337, 1.338

Fabian Groffen Fabian.Groffen at cwi.nl
Sat Mar 7 22:47:22 CET 2009

On 07-03-2009 21:41:21 +0000, Stefan de Konink wrote:
> This code adds the last_id variable to MonetDB5/SQL to implement 'in SQL'
> access to the last updated sequence, in a similar fashion as the @@IDENTITY
> found in MSSQL. For future compatibility a procedure like get_last_row_id()
> found in other databases, this function would have to return the variable
> found. The variable is updated when m->last_id is updated.
> The code was added to have last_id support within the ODBC interface;
> required for phpBB compatibility.

Weird, ODBC already knows it, and more reliable, via the response of
Q_UPDATE.  I think it was already implemented in ODBC even?  It's
available in mapilib, using mapi_get_last_id.

More information about the developers-list mailing list