Bug #71637 | Manual mentions IS_GAP and IX_GAP locks, but never explains them | ||
---|---|---|---|
Submitted: | 9 Feb 2014 14:23 | Modified: | 23 Feb 2016 15:18 |
Reporter: | Valeriy Kravchuk | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Documentation | Severity: | S1 (Critical) |
Version: | 5.6 | OS: | Any |
Assigned to: | Daniel Price | CPU Architecture: | Any |
Tags: | information_schema, innodb_locks, missing manual |
[9 Feb 2014 14:23]
Valeriy Kravchuk
[9 Feb 2014 14:42]
Valeriy Kravchuk
Corrected tag.
[11 Feb 2014 11:43]
MySQL Verification Team
Thank you for the bug report.
[23 Feb 2016 15:18]
Daniel Price
Posted by developer: The LOCK_MODES field description in the INNODB_LOCKS Table documentation has been revised. The changes should appear online within 24 hours. https://dev.mysql.com/doc/refman/5.5/en/innodb-locks-table.html https://dev.mysql.com/doc/refman/5.6/en/innodb-locks-table.html https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-table.html From storage/innobase/handler/i_s.cc: #define IDX_LOCK_MODE 2 {STRUCT_FLD(field_name, "lock_mode"), /* S[,GAP] X[,GAP] IS[,GAP] IX[,GAP] AUTO_INC UNKNOWN */ STRUCT_FLD(field_length, 32), STRUCT_FLD(field_type, MYSQL_TYPE_STRING), STRUCT_FLD(value, 0), STRUCT_FLD(field_flags, 0), STRUCT_FLD(old_name, ""), STRUCT_FLD(open_method, SKIP_OPEN_TABLE)}, Thank you for the bug report.