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

Package methods can't be used before their declaration

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.4, 11.5(EOL)
    • 11.4
    • Stored routines
    • None

    Description

      Non-Oracle mode.

      The following package can be created without errors:

      CREATE SCHEMA IF NOT EXISTS test;
      		 
      USE test;
      		 
       
      		 
      DELIMITER ||
      		 
       
      		 
      CREATE OR REPLACE PACKAGE ctr
      		 
        FUNCTION a() RETURNS INT;
      		 
      END;
      		 
      ||
      		 
       
      		 
      CREATE OR REPLACE PACKAGE BODY ctr
      		 
       
      		 
        FUNCTION a() RETURNS INT
      		 
        BEGIN
      		 
          RETURN b();
      		 
        END;
      		 
       
      		 
        FUNCTION b() RETURNS INT
      		 
        BEGIN
      		 
          RETURN 1;
      		 
        END;
      		 
      END;
      		 
      ||
      		 
       
      		 
      DELIMITER ;

      But calling a() returns an error:

      MariaDB [test]> SELECT ctr.a();
      		 
      ERROR 1305 (42000): FUNCTION test.b does not exist

      This happens because b() was not defined before the line that calls it.

      You can verify that the code works if you invert a() and b() code, or if you declare b() in CREATE PACKAGE.

      This error makes it impossible to have two mutually recursive private methods.

      Attachments

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-32101 CREATE PACKAGE [BODY] for sql_mode=DEFAULT

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

          Activity

            alice Alice Sherepa added a comment -

            Thanks!
            I repeated as described. 

            DELIMITER ||;
            		 
             
            CREATE PACKAGE ctr
            		 
              FUNCTION a() RETURNS INT;
            		 
            END;
            		 
            ||
            		 
             
            CREATE PACKAGE BODY ctr
            		 
              FUNCTION a() RETURNS INT RETURN b();
            		 
              FUNCTION b() RETURNS INT  RETURN 1;
            		 
            END;
            		 
            ||
            		 
            DELIMITER ;||
            		 
             
            		 
            SELECT ctr.a();
            		 
            mysqltest: At line 19: query 'SELECT ctr.a()' failed: ER_SP_DOES_NOT_EXIST (1305): FUNCTION test.b does not exist


            CREATE PACKAGE ctr
            		 
            FUNCTION a() RETURNS INT;
            		 
            END;
            		 
            ||
            		 
            CREATE PACKAGE BODY ctr
            		 
            FUNCTION b() RETURNS INT  RETURN 1;
            		 
            FUNCTION a() RETURNS INT RETURN b();
            		 
            END;
            		 
            ||
            		 
            SELECT ctr.a();
            		 
            ctr.a()
            		 
            1

            alice Alice Sherepa added a comment - Thanks! I repeated as described. DELIMITER ||; CREATE PACKAGE ctr FUNCTION a() RETURNS INT ; END ; || CREATE PACKAGE BODY ctr FUNCTION a() RETURNS INT RETURN b(); FUNCTION b() RETURNS INT RETURN 1; END ; || DELIMITER ;||   SELECT ctr.a(); mysqltest: At line 19: query 'SELECT ctr.a()' failed: ER_SP_DOES_NOT_EXIST (1305): FUNCTION test.b does not exist CREATE PACKAGE ctr FUNCTION a() RETURNS INT ; END ; || CREATE PACKAGE BODY ctr FUNCTION b() RETURNS INT RETURN 1; FUNCTION a() RETURNS INT RETURN b(); END ; || SELECT ctr.a(); ctr.a() 1

            People

              bar Alexander Barkov
              f_razzoli Federico Razzoli
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.