Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19500

Update with join stopped worked if there is a call to a procedure in a trigger

    XMLWordPrintable

Details

    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.

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              lukav@lukav.com Anton Avramov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.