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

I_S.parameters not immediatly changed updated after procedure change

    XMLWordPrintable

Details

    Description

      If having use a procedure, then in another connection, this procedure is changed (removing one parameter), a call to INFORMATION_SCHEMA.parameters will not reflect the changes in the the first connection.

      example to reproduce :
      create procedure :

      create or replace procedure metaChange(p1 int, p2 int)
      BEGIN
        select p1 as 'p1';
      END
      

      The failing scenario:

      • connection 1 : execute

        call metaChange(1, 2)
        

      • connection 1 : execute

        SELECT * FROM information_schema.parameters where SPECIFIC_NAME='metaChange';
        

        => return the p1 and p2 parameters as expected

      • connection 2 : change procedure:

        create or replace procedure metaChange(p1 int)
        BEGIN
          select p1 as 'p1';
        END
        

        procedure has now only one parameter

      • connection 2 : execute

        SELECT * FROM information_schema.parameters where SPECIFIC_NAME='metaChange';
        

        => return the p1 parameters as expected

      • connection 1 : execute

        SELECT * FROM information_schema.parameters where SPECIFIC_NAME='metaChange';
        

        => still return the p1 and p2 parameters

      Attachments

        Issue Links

          Activity

            People

              Lawrin Lawrin Novitsky
              diego dupin Diego Dupin
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.