Bug #31175 | SELECT ... FOR UPDATE does not block | ||
---|---|---|---|
Submitted: | 24 Sep 2007 13:17 | Modified: | 26 Sep 2007 3:45 |
Reporter: | Hakan Küçükyılmaz | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: Locking | Severity: | S2 (Serious) |
Version: | 5.1.23, 6.0.3 | OS: | Linux (64-bit) |
Assigned to: | CPU Architecture: | Any |
[24 Sep 2007 13:17]
Hakan Küçükyılmaz
[24 Sep 2007 14:26]
MySQL Verification Team
Thank you for the bug report. Verified as described.
[24 Sep 2007 15:17]
Hakan Küçükyılmaz
Also fails with Falcon
[26 Sep 2007 3:45]
Hakan Küçükyılmaz
Sorry for confusion. set @autocommit = 0 sets the user variable @autocommit to 0. SELECT ... FOR UPDATE works as expected when using "set autocommit = 0" or "set @@autocommit = 0". Best regards, Hakan