Cannot use UDF's when their library is embedded

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:

1 INSTALL PLUGIN CONNECT SONAME 'ha_connect';

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

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

However, when the server was compiled with:

1 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.

Environment

None

Status

Assignee

Olivier Bertrand

Reporter

Olivier Bertrand

Labels

None

External issue ID

None

External issue ID

None

Priority

Critical