Viewing all changes in revision 2502.1137.187.
- Committer: Annamalai Gurusami
- Date: 2012-05-16 05:47:48 UTC
- mto: (2502.1194.1 mysql-5.1.64-release)
- mto: This revision was merged to the branch mainline in revision 3152.
- Revision ID: annamalai.gurusami@oracle.com-20120516054748-bge2rocu2cy86r3x
Bug #12752572 61579: REPLICATION FAILURE WHILE
INNODB_AUTOINC_LOCK_MODE=1 AND USING TRIGGER
When an insert stmt like "insert into t values (1),(2),(3)" is
executed, the autoincrement values assigned to these three rows are
expected to be contiguous. In the given lock mode
(innodb_autoinc_lock_mode=1), the auto inc lock will be released
before the end of the statement. So to make the autoincrement
contiguous for a given statement, we need to reserve the auto inc
values at the beginning of the statement.
rb://1074 approved by Alexander Nozdrin
INNODB_AUTOINC_LOCK_MODE=1 AND USING TRIGGER
When an insert stmt like "insert into t values (1),(2),(3)" is
executed, the autoincrement values assigned to these three rows are
expected to be contiguous. In the given lock mode
(innodb_autoinc_lock_mode=1), the auto inc lock will be released
before the end of the statement. So to make the autoincrement
contiguous for a given statement, we need to reserve the auto inc
values at the beginning of the statement.
rb://1074 approved by Alexander Nozdrin
- files modified:
- sql/handler.cc
expand all
collapse all
added
removed
