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

Unexpected PROCEDURE does not exist error with a non-default PATH

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 13.0, 12.3.1
    • None
    • Stored routines
    • None

    Description

      This script:

      SET PATH 'CURRENT_PATH,test1';
      		 
      DELIMITER $$
      		 
      CREATE OR REPLACE PROCEDURE p1()
      		 
      BEGIN
      		 
        SELECT 1;
      		 
      END;
      		 
      $$
      		 
      DELIMITER ;
      		 
      CALL p1();

      produces an unexpected error:

      ERROR 1305 (42000): PROCEDURE p1 does not exist

      It makes the use of the feature quite problematic.

      Note, if I do SET PATH DEFAULT, the CALL works fine.

      Attachments

        Issue Links

          is caused by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34391 SET PATH statement

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              Unassigned Unassigned
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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