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

Document stored packages overview

    XMLWordPrintable

Details

    Description

      For now we have a few pages on the manual telling about PACKAGE related statements:

      • CREATE PACKAGE
      • DROP PACKAGE
      • CREATE PACKAGE BODY
      • DROP PACKAGE BODY

      However, the manual misses an overview page similar to what we for stored procedures and functions.

      The overview page should explain:

      • What is a package. Why use packages.
      • How packages are different from the SQL Standard modules.
      • Package variables
      • Public and private routines
      • Executable initialization section
      • Stored package privileges
      • SHOW CREATE PACKAGE [BODY]
      • SHOW PACKAGE [BODY] CODE
      • SHOW PACKAGE [BODY] STATUS
      • Name resolution order - resolving ambiguities:

          SELECT pkg.f1(); -- Schema `pkg`, schema function `f1`
          SELECT pkg.f1(); -- Current schema, package `pkg`, package function `f1`
        

      • Stored package internals

      Attachments

        Issue Links

          Activity

            People

              JoeCotellese Joe Cotellese
              bar Alexander Barkov
              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.