Bug #75699 Unstable testcase sys_vars.session_track_system_variables_basic

• Submitted: 30 Jan 2015 12:37
• Modified: 1 Apr 2015 5:17
• Reporter: Laurynas Biveinis (OCA)
• Status: Duplicate
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 5.7.5
• OS: Any
• CPU Architecture: Any
• Tags: Contribution, mtr

[30 Jan 2015 12:37] Laurynas Biveinis

Description:
sys_vars.session_track_system_variables_basic queries INFORMATION_SCHEMA.GLOBAL_VARIABLES and SESSION_VARIABLES without an ORDER BY. Thus, it depends on how the hash table enumerates the variables, and that order is both unspecified and unstable.

How to repeat:
Add a new system variable, run session_track_system_variables_basic.

Suggested fix:
Add ORDER BY

[30 Jan 2015 12:41] Laurynas Biveinis

Bug 75699 fix for 5.7.5

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: bug75699.patch (application/octet-stream, text), 2.87 KiB.

[10 Feb 2015 12:04] MySQL Verification Team

Thank you for the bug report and contribution.

[1 Apr 2015 5:11] Erlend Dahl

Fixed in 5.7.6 as a duplicate of

Bug#75114 session_track_system_variables_basic may fail sporadically

No changelog entry.

[1 Apr 2015 5:17] Laurynas Biveinis

Why bug 75114 is inaccessible if it is only "session_track_system_variables_basic may fail sporadically"?

[8 Apr 2015 12:06] Anitha Gopi

Thanks for the contribution. The test was already fixed in 5.7.6