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

Cannot use UDF's when their library is embedded

    XMLWordPrintable

Details

    Description

      The CONNECT storage engine comes with additional UDF's used to generate JSON items.

      All is right when the plugin is not embedded. It can be installed using:

      INSTALL PLUGIN CONNECT SONAME 'ha_connect';

      To create the functions, one can use statements such as:

      CREATE FUNCTION function_name RETURNS STRING SONAME 'ha_connect.{so|dll'};

      However, when the server was compiled with:

      WITH STORAGE ENGIE CONNECT=ON

      there is no more ha_connect library and apparently it is impossible to create the UDF's.

      There should be a syntax to indicate they are located in the MariaDB server.

      Additional question:
      The 'INSTALL PLUGIN' command accepts the library file type to be omited and resolved to 'so' on Linux and to 'dll' on Windows. However, the 'CREATE FUNCTION' does not. This makes complicated to make tests that should run on on both operating systems.

      Attachments

        Activity

          People

            Unassigned Unassigned
            bertrandop Olivier Bertrand
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.