Fabian Groffen wrote:
> 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.
mapi_get_last_id is not used in the odbc sources. And Q_UPDATE denotes:
case Q_UPDATE: /* Q_UPDATE */
/* result count generating query */
So I don't know if you were thinking about something else. I am still
fighting with cvs to get my patches in diff -u format. Hence the
previous off by one screwup.
Stefan
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Monetdb-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-developers
