Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Need SO for x64 mysql #2

Open
mooyah opened this issue Apr 17, 2013 · 4 comments
Open

Need SO for x64 mysql #2

mooyah opened this issue Apr 17, 2013 · 4 comments

Comments

@mooyah
Copy link

mooyah commented Apr 17, 2013

I need a SO file for 64-bit mysql. The SO file provided is 32-bit. I would build it myself, but the repository is missing required files.

@werebear73
Copy link

Having the same issue

@h3110w0r1d
Copy link

just compile it yourself

gcc $(/your/mysql/bin/path/mysql_config --cflags) -shared -fPIC -o lib_mysqludf_json.so lib_mysqludf_json.c

@Kirow
Copy link

Kirow commented Jan 5, 2015

compilation works for me, but function result was different than I expected
teste json_array, expected:

[
   ["1","2","3"],
   ["1","2","3"]
]

got:

["1","2","3"]
["1","2","3"]

But it is probably possible to make it like I want to.

Also used sql for same purposes(~same performance)

SELECT * INTO OUTFILE 'pathToFile' 
    FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"'
    LINES 
        STARTING BY '['
        TERMINATED BY '],\n'
    FROM Table

result:

["1","2","3"],
["1","2","3"],

Maybe someone have good idea how to get json format I want?

@tazuddinleton
Copy link

tazuddinleton commented Nov 5, 2021

Compile worked but when trying to create udf

create function lib_mysqludf_json_info returns string soname 'lib_mysqludf_json.so';
create function json_array returns string soname 'lib_mysqludf_json.so';
create function json_members returns string soname 'lib_mysqludf_json.so';
create function json_object returns string soname 'lib_mysqludf_json.so';
create function json_values returns string soname 'lib_mysqludf_json.so';

Getting error

create function lib_mysqludf_json_info returns string soname 'lib_mysqludf_json.so';
ERROR 1127 (HY000): Can't find symbol 'lib_mysqludf_json_info' in library
mysql> create function json_array returns string soname 'lib_mysqludf_json.so';
ERROR 1585 (HY000): This function 'json_array' has the same name as a native function
mysql> create function json_members returns string soname 'lib_mysqludf_json.so';
ERROR 1127 (HY000): Can't find symbol 'json_members' in library
mysql> create function json_object returns string soname 'lib_mysqludf_json.so'; 
ERROR 1585 (HY000): This function 'json_object' has the same name as a native function
mysql> create function json_values returns string soname 'lib_mysqludf_json.so'; 
ERROR 1127 (HY000): Can't find symbol 'json_values' in library

Does anybody have any ideas?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

5 participants