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

MariaDB Oracle mode misses Synonyms

    XMLWordPrintable

Details

    Description

      Oracle knows an object type called Synonyms:
      https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7001.htm

      "Use the CREATE SYNONYM statement to create a synonym, which is an alternative name for a table, view, sequence, procedure, stored function, package, materialized view, Java class schema object, user-defined object type, or another synonym.

      Synonyms provide both data independence and location transparency. Synonyms permit applications to function without modification regardless of which user owns the table or view and regardless of which database holds the table or view. However, synonyms are not a substitute for privileges on database objects. Appropriate privileges must be granted to a user before the user can use the synonym."

      This is still lacking in MariaDB 10.3 oracle mode. IMHO this is crucial for oracle portability because it allows to have packages (e.g. dbms_output) only once per instance instead of once per schema (see also example here (at the very end): http://www.fromdual.com/select-hello-world-fromdual-with-mariadb-pl-sql

      Possibly, synonyms to these object types can go into a separate MDEV each:

      • table
      • view
      • sequence
      • procedure
      • stored function
      • package

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              oli Oli Sennhauser
              Votes:
              6 Vote for this issue
              Watchers:
              13 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.