Bug #105450 | There is a problem when calling the system table in stored function | ||
---|---|---|---|
Submitted: | 4 Nov 2021 2:49 | Modified: | 22 Jan 2022 15:25 |
Reporter: | yi qian | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Information schema | Severity: | S2 (Serious) |
Version: | 8.0.25, 8.0.27 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | regression, stored function; information_schema.tables |
[4 Nov 2021 2:49]
yi qian
[4 Nov 2021 6:30]
MySQL Verification Team
Hello yi qian, Thank you for the report and test case. Verified as described with 8.0.27 build. regards, Umesh
[4 Nov 2021 19:19]
Justin Swanhart
Can up update the synopsis/tags to say 'stored function'. The reporter's original language may not be not english.
[5 Nov 2021 3:41]
yi qian
change storage function to stored function
[22 Jan 2022 15:25]
Daniel Price
Posted by developer: Fixed as of the upcoming 8.0.29 release: An INFORMATION_SCHEMA.FILES or INFORMATION_SCHEMA.TABLES query executed by prepared statement or stored function returned stale data. Cached data was reported after the data had changed.