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:
To create the functions, one can use statements such as:
However, when the server was compiled with:
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.
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.