Commit ID
|
|
Contributor: | kalhans as Rohit Kalhans |
Files Modified: | 27 |
| Date: | 07-February-2012 at 08:29 | Lines Added: | 65 | |
| Repository: | lp:mysql-server | Lines Removed: | 3 | |
| Commit Comment: | BUG#11758263 50440: MARK UNORDERED UPDATE WITH AUTOINC UNSAFE Problem: Statements that write to tables with auto_increment columns based on the selection from another table, may lead to master and slave going out of sync, as the order in which the rows are retrived from the table may differ on master and slave. Solution: We mark writing to a table with auto_increment table as unsafe. This will cause the execution of such statements to throw a warning and forces the statement to be logged in ROW if the logging format is mixed. Changes: 1. All the statements that writes to a table with auto_increment column(s) based on the rows fetched from another table, will now be unsafe. 2. CREATE TABLE with SELECT will now be unsafe. |
|||
| Language | Code Added | Code Removed | Comments Added | Comment Removed | Blanks Added | Blanks Removed | |
|---|---|---|---|---|---|---|---|
| C++ | 27 | 0 | 28 | 3 | 10 | 0 | |
| File | Language | Code Added | Code Removed | Comments Added | Comment Removed | Blanks Added | Blanks Removed | |
|---|---|---|---|---|---|---|---|---|
| ...st/extra/rpl_tests/rpl_insert_id_pk.test | No source code was detected in this file. | |||||||
| ...t/extra/rpl_tests/rpl_multi_update2.test | No source code was detected in this file. | |||||||
| ...t/extra/rpl_tests/rpl_multi_update3.test | No source code was detected in this file. | |||||||
| ...st/extra/rpl_tests/rpl_multi_update.test | No source code was detected in this file. | |||||||
| mysql-test/r/ps.result | No source code was detected in this file. | |||||||
| ...test/suite/binlog/r/binlog_unsafe.result | No source code was detected in this file. | |||||||
| ...l-test/suite/binlog/t/binlog_unsafe.test | No source code was detected in this file. | |||||||
| ...te/rpl/r/rpl_auto_increment_11932.result | No source code was detected in this file. | |||||||
| ...test/suite/rpl/r/rpl_insert_id_pk.result | No source code was detected in this file. | |||||||
| ...est/suite/rpl/r/rpl_multi_update2.result | No source code was detected in this file. | |||||||
Copyright
©
2013
Black Duck Software, Inc.
and its contributors, Some Rights Reserved. Unless otherwise marked, this work is licensed under a
Creative Commons Attribution 3.0 Unported License
. Ohloh
®
and the Ohloh logo are trademarks of
Black Duck Software, Inc.
in the United States and/or other jurisdictions. All other trademarks are the property of their respective holders.