[MDEV-19500] Update with join stopped worked if there is a call to a procedure in a trigger Created: 2019-05-16  Updated: 2019-06-01  Resolved: 2019-05-17

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Update, Stored routines, Triggers
Affects Version/s: 10.2.24
Fix Version/s: 10.2.25, 5.5.65, 10.1.41, 10.3.16, 10.4.6

Type: Bug Priority: Blocker
Reporter: Anton Avramov Assignee: Sergei Golubchik
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Debian stretch, Ubuntu bionic

Attachments: File bug_report.sql    
Issue Links:
Duplicate
duplicates MDEV-19491 update query stopped working after ma... Closed

 Description   

After update of the official deb package to 10.2.24 to our clients we start experience errors of type PROCEDURE xxx does not exist.
Some times the problem is manifested as table does not exists.
In any case the procedure/table exists and was used regularly before.

Attached is and sql script to demonstrate the problem.

Funny think is that if you make and update on the table first without the join and then with the join it doesn't throws an error. You can uncomment the commended update in the sql script to see what I mean.
Generated at Thu Feb 08 08:52:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.