I thought I posted about this earlier, but I don't see the message in the archives. I apologize if this is a duplicate.
Anyone have a solution for using MySQL sequences with Sequoia? We're using fake MySQL sequences using the parameterized last_insert_id() technique (described at http://www.mysqlperformanceblog.com/2008/04/02/stored-function-to-generate-sequences/among other places). Using the stored function, we're seeing duplicate sequence entries. Executing the update/select statements outside of a function, we're seeing duplicate sequence entries. Using a stored procedure, we're not seeing duplicate sequence entries, but performance is poor. What's a guy to do? Thanks, Ian.
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
