Stored procedure execution fails if contains a functional index
Description
Environment
AFFECTED CS IDs
Smart Checklist
Activity
Jira Bot June 9, 2021 at 10:56 PM
To: Former user
CC:
Hi, I'm jira-bot, Percona's Jira automation tool. I've detected that someone from
Percona has made an edit to the Summary field of an issue that you reported.
I'm not sentient (yet) so I'm not sure whether the person fixed a typo, changed
a few words, or completely rewrote the text. In any case, it is Percona Engineering's
intention to make the Summary and Description of an issue as accurate as possible
so that we're fixing the actual problem you're encountering, and to avoid
misunderstandings about symptoms and causes.
If the current Summary does not accurately reflect the problem you are reporting,
or if you feel the change was otherwise inappropriate in some way, please add a
new comment explaining things and we'll address it as soon as we can.
This message will be added only once per issue, regardless of how many times
the Summary is edited.
message-code:summary-edited
Details
Details
Assignee
Daniel FialaReporter
Mateo FleitasLabels
Upstream Bug URL
Affects versions
Priority
MediumSmart Checklist
Open Smart Checklist
Smart Checklist
A Stored Procedure execution fails after some executions when a functional index is present in the SP definition. The error behaves differently depending on the versions I tested:
8.0.23 (PS, Community): It only fails when using a temporary table. After the third execution, all the subsequent executions fail.
8.0.25 (Community): It also fails on normal tables.
How to Repeat
Now if you invoke that procedure 3 times in a row:
On 8.0.25 (Community) The error is
Please, let me know if more information is needed.
Best Regards,
Mateo Fleitas