Bug #70392 MySQL JSON UDFs binary is called libmy_json_udf.so but DDL uses libmy_json.so

• Submitted: 21 Sep 2013 23:10
• Modified: 30 Oct 2013 16:14
• Reporter: Roland Bouman
• Status: Closed
• Category: MySQL Server: JSON User-defined function ( UDF )
• Severity: S3 (Non-critical)
• Version: 0.2
• OS: Any
• Assigned to: Sveta Smirnova
• CPU Architecture: Any

[21 Sep 2013 23:10] Roland Bouman

Description:
http://labs.mysql.com/, category: MySQL JSON UDFs, package mysql-json-udfs-0.2.0-labs-json-udfs-linux-glibc2.5-x86_64.tar.gz

contains this binary: libmy_json_udf.so

But the README contains these instructions for installation on Linux:
"
Linux/UNIX/Mac OSX
------------------

Copy libmy_json.so into plugin directory of your MySQL server, then login and type:

create function json_valid returns integer soname 'libmy_json.so';
"

The library name in the DDL statements is wrong and should match the filename of the binary

How to repeat:
see description

Suggested fix:
fix either the README or change the name of the binary

[22 Sep 2013 4:56] MySQL Verification Team

Hello Roland,

Thank you for the bug report.
Verified as described.

// Dir listing

09/22/2013  10:20 AM    <DIR>          .
09/22/2013  10:20 AM    <DIR>          ..
09/13/2013  01:02 AM            17,987 COPYING
09/13/2013  01:02 AM            68,163 libmy_json_udf.so
09/13/2013  01:02 AM             2,492 license-pcre.txt
09/14/2013  04:26 AM             5,989 README
               4 File(s)         94,631 bytes
               2 Dir(s)  103,836,532,736 bytes free

// Excerpt from README

Installation
------------

Linux/UNIX/Mac OSX
------------------

Copy libmy_json.so into plugin directory of your MySQL server, then login and type:

create function json_valid returns integer soname 'libmy_json.so';
create function json_search returns string soname 'libmy_json.so';
..
..
.
create function json_contains_key returns integer soname 'libmy_json.so';

Thanks,
Umesh

[30 Oct 2013 16:14] Sveta Smirnova

Fixed in versions 0.2.1 and 0.3.0