[Zope-DB] Strange problem with ZSQL Method called from another ZSQL Method

[Dieter Maurer]

Stefan Schmid writes:
 > ....
 > # ZSQL Method next_objectid
 > UPDATE objectid SET oid = LAST_INSERT_ID(oid+1)
 > <dtml-var sql_delimiter>
 > SELECT LAST_INSERT_ID() AS oid FROM objectid
 > 
 > This ZSQL method works as expected when called from a DTML Document but
 > calls from a second ZSQL method (i.e. 'insert_test') generate a sequence of
 > numbers that increase by 2 each time.
I believe to remember that I saw a similar problem description
(long ago, --> mailing list archives). But, I fear, it has not been
resolved...


Dieter