Bug #7594 query_cache_wlock_invalidate is settable but not viewable in 4.0.19-4.0.23

• Submitted: 30 Dec 2004 20:37
• Modified: 11 Jan 2005 20:26
• Reporter: Matthew Lord
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.0.19-.23
• OS: Any (all)
• Assigned to: Jim Winstead
• CPU Architecture: Any

[30 Dec 2004 20:37] Matthew Lord

Description:
Our changelogs state that the option was added in 4.0.19 but it is not listed in show
variables.  You can however set it with set query_cache_wlock_invalidate=ON|OFF;

How to repeat:
Connect to 4.0.23

show variables like "query_cache_wlock_invalidate";
set query_cache_wlock_invalidate=ON;
show variables like "query_cache_wlock_invalidate";

Suggested fix:
Add it to the show variables list.

[1 Jan 2005 0:16] MySQL Verification Team

Thank you for the bug report.

[4 Jan 2005 1:46] Jim Winstead

It was already visible in 4.1, just added line to 4.0 tree to make it visible there.

[4 Jan 2005 16:30] Jim Winstead

Fixed in 4.0 tree.

[11 Jan 2005 20:26] Paul DuBois

Mentioned in 4.0.24 change notes.