The following issue has been SUBMITTED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=296 ====================================================================== Reported By: MagnusSundberg Assigned To: ====================================================================== Project: DBMail Issue ID: 296 Category: installation scripts Reproducibility: always Severity: minor Priority: normal Status: new ====================================================================== Date Submitted: 31-Jan-06 12:02 CET Last Modified: 31-Jan-06 12:02 CET ====================================================================== Summary: MySQL add_header_tables.mysql Description: Just a small note on the programming of this file. My beleif is that when you issue CREATE TABLE MySQL automatically commits. Yhe file https://svn.ic-s.nl/svn/dbmail/trunk/dbmail/sql/mysql/add_header_tables.mysql almost starts with START TRANSACTION; and finishes with COMMIT; The problem is that there actually is a commit for each CREATE TABLE;
My suggestion is that you should drop the START TRANSACTION and COMMIT line, since it is more confusing and adds a false feeling of security. http://dev.mysql.com/doc/refman/5.0/en/innodb-implicit-command-or-rollback.html ====================================================================== Issue History Date Modified Username Field Change ====================================================================== 31-Jan-06 12:02 MagnusSundberg New Issue ======================================================================
