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

Wrong error message on `GRANT .. ON PACKAGE no_such_package ..`

Details

    Description

      GRANT EXECUTE ON PACKAGE no_such_package TO PUBLIC;


      ERROR 1305 (42000): FUNCTION or PROCEDURE no_such_package does not exist

      The error message is wrong, the statement tried to grant on a nonexistent package not a nonexistent function or procedure.

      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

            Ascending order - Click to sort in descending order
            bar Alexander Barkov created issue -
            bar Alexander Barkov made changes -
            Field Original Value New Value
            bar Alexander Barkov made changes -
            Description {code:sql}
            GRANT EXECUTE ON PACKAGE no_such_package TO PUBLIC;
            {code}
            {noformat}
            ERROR 1305 (42000): FUNCTION or PROCEDURE no_such_package does not exist
            {noformat}

            The error message is wrong, the statement tried to grant on a nonexistent package not a nonexistent routine.
            		{code:sql}
            GRANT EXECUTE ON PACKAGE no_such_package TO PUBLIC;
            {code}
            {noformat}
            ERROR 1305 (42000): FUNCTION or PROCEDURE no_such_package does not exist
            {noformat}

            The error message is wrong, the statement tried to grant on a nonexistent package not a nonexistent function or procedure.
            bar Alexander Barkov made changes -
            issue.field.resolutiondate 2024-02-05 12:09:31.0 2024-02-05 12:09:31.034
            bar Alexander Barkov made changes -
            Fix Version/s 11.4.1 [ 29523 ]
            Fix Version/s 11.5.1 [ 29634 ]
            Fix Version/s 11.4 [ 29301 ]
            Assignee Alexander Barkov [ bar ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 11.5.1 [ 29634 ]

            People

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