Update of /cvsroot/modeling/ProjectModeling/Modeling/DatabaseAdaptors/MySQLAdaptorLayer
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv23227/Modeling/DatabaseAdaptors/MySQLAdaptorLayer
Modified Files:
MySQLAdaptorChannel.py
Log Message:
Fixed generation of PK: two threads could get the same id
Index: MySQLAdaptorChannel.py
===================================================================
RCS file: /cvsroot/modeling/ProjectModeling/Modeling/DatabaseAdaptors/MySQLAdaptorLayer/MySQLAdaptorChannel.py,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** MySQLAdaptorChannel.py 10 Jan 2003 10:45:45 -0000 1.1
--- MySQLAdaptorChannel.py 17 Feb 2004 18:53:40 -0000 1.2
***************
*** 80,84 ****
pkRootName=anEntity.primaryKeyRootName()
statements=["UPDATE PK_SEQ_%s SET id=LAST_INSERT_ID(id+1)"%pkRootName,
! "select id FROM PK_SEQ_%s"%pkRootName]
result=[]
for idx in range(count):
--- 80,84 ----
pkRootName=anEntity.primaryKeyRootName()
statements=["UPDATE PK_SEQ_%s SET id=LAST_INSERT_ID(id+1)"%pkRootName,
! "select LAST_INSERT_ID()"]
result=[]
for idx in range(count):
|
