On 07-03-2009 23:09:13 +0100, Stefan de Konink wrote:
> >> 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 */

Yes, but for ODBC it was extended also to return the generated number of a
sequence (key) as second field.  Last week I implemented the use of this
field in JDBC.

> 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.

I'm pretty sure the information is already there, and that ODBC should
use that information instead of a separate query which is prone to
transaction race conditions and more.  I was under the impression the
extra information was added because ODBC needed it.

------------------------------------------------------------------------------
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

Reply via email to