I did the same for MySQL:
# Z SQL Method next_objectid
UPDATE objectid SET oid = LAST_INSERT_ID(oid+1)
SELECT LAST_INSERT_ID() AS oid FROM objectid
This works as expected when called from a DTML Document but calls
from a second Z SQL Method generate a sequence of numbers that
increase by 2 each time.
# Z SQL Method insert_test
INSERT INTO test(oid, descr)
VALUES (<dtml-var expr="next_objectid().oid">, "Test")
Is anybody noticing anything similar, or if you have any opinion
on what might be going on, please reply.