Hi all:

 

This might be obvious to many but I just noticed that MySQL’s “Auto Increment” still increases when using the autocommit = 0 / rollback() transaction method of handling database dependent tests, at least with my set up.

So if you wonder why your new ID numbers are significantly higher than it seems they should be, that would probably explain why.

 

Galen’s (very welcome) explanation of the DB transaction method of handling database-dependent tests:

 

http://galencharlton.com/blog/2013/08/musings-on-kohas-database-dependent-tests/

 

Description: logo

David Cook
Systems Librarian

(BA,FRLS,MLIS)

Prosentient Systems P/L
ABN 31 078 409 168
72/330 Wattle St,
Ultimo NSW 2007

tel: 02 92120899

fax: 02 92120885

dcook@prosentient.com.au