Bug #74244 | Wrong results with stored programs and nullable system variables | ||
---|---|---|---|
Submitted: | 7 Oct 2014 6:52 | Modified: | 5 Nov 2014 16:02 |
Reporter: | Davi Arnaut (OCA) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Stored Routines | Severity: | S2 (Serious) |
Version: | 5.6, 5.6.22 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[7 Oct 2014 6:52]
Davi Arnaut
[7 Oct 2014 7:10]
MySQL Verification Team
Hello Davi, Thank you for the report and test case. Thanks, Umesh
[5 Nov 2014 16:02]
Paul DuBois
Noted in 5.7.6 changelog. Reading a system variable with a NULL value inside a stored program caused any subsequent reads to return a NULL value even though the variable value might change across invocations of the stored program.