Wed, 23 Feb 2011 17:40:56 +0100 Feed for all projects http://bugs.mysqludf.org/ Anonymous user Wed, 23 Feb 2011 17:40:56 +0100 Source info: lib_mysqludf_pref-1.0.1 source.
Linux info:Running Centos 5.5
[user@box lib_mysqludf_preg-1.0.1]$ uname -a
Linux box 2.6.18-194.17.1.el5 #1 SMP Wed Sep 29 12:50:31 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux

Configure works:

[user@box lib_mysqludf_preg-1.0.1]$ ./configure
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe mkdir -p... /bin/mkdir -p
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking for style of include used by make... GNU
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking dependency style of gcc... gcc3
checking for a sed that does not truncate output... /bin/sed
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for fgrep... /bin/grep -F
checking for ld used by gcc... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for BSD- or MS-compatible name lister (nm)... /usr/bin/nm -B
checking the name lister (/usr/bin/nm -B) interface... BSD nm
checking whether ln -s works... yes
checking the maximum length of command line arguments... 98304
checking whether the shell understands some XSI constructs... yes
checking whether the shell understands "+="... yes
checking for /usr/bin/ld option to reload object files... -r
checking how to recognize dependent libraries... pass_all
checking for ar... ar
checking for strip... strip
checking for ranlib... ranlib
checking command to parse /usr/bin/nm -B output from gcc object... ok
checking how to run the C preprocessor... gcc -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking for dlfcn.h... yes
checking for objdir... .libs
checking if gcc supports -fno-rtti -fno-exceptions... no
checking for gcc option to produce PIC... -fPIC -DPIC
checking if gcc PIC flag -fPIC -DPIC works... yes
checking if gcc static flag -static works... yes
checking if gcc supports -c -o file.o... yes
checking if gcc supports -c -o file.o... (cached) yes
checking whether the gcc linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
checking for gcc... (cached) gcc
checking whether we are using the GNU C compiler... (cached) yes
checking whether gcc accepts -g... (cached) yes
checking for gcc option to accept ISO C89... (cached) none needed
checking dependency style of gcc... (cached) gcc3
checking for mysqlbin... ERROR 1045 (28000): Access denied for user 'nskalski'@'localhost' (using password: NO)
checking for mysql_config... /usr/bin/mysql_config
checking for MySQL libraries... yes
configure: setting libdir to mysql plugin dir /usr/lib/mysql/plugin
checking for pcre-config... /usr/bin/pcre-config
checking for PCRE - version >= 1... 6.6
configure: creating ./config.status
config.status: creating Makefile
config.status: creating test/Makefile
config.status: creating doc/Makefile
config.status: creating config.h
config.status: executing depfiles commands
config.status: executing libtool commands
[user@box lib_mysqludf_preg-1.0.1]$

Make works. (output too long to list)

Install libraries as root works:

[user@box lib_mysqludf_preg-1.0.1]$ sudo make install
[sudo] password for user:
Making install in test
make[1]: Entering directory `/home/user/lib_mysqludf_preg-1.0.1/test'
make[2]: Entering directory `/home/user/lib_mysqludf_preg-1.0.1/test'
make[2]: Nothing to be done for `install-exec-am'.
make[2]: Nothing to be done for `install-data-am'.
make[2]: Leaving directory `/home/user/lib_mysqludf_preg-1.0.1/test'
make[1]: Leaving directory `/home/user/lib_mysqludf_preg-1.0.1/test'
Making install in doc
make[1]: Entering directory `/home/user/lib_mysqludf_preg-1.0.1/doc'
make[2]: Entering directory `/home/user/lib_mysqludf_preg-1.0.1/doc'
make[2]: Nothing to be done for `install-exec-am'.
make[2]: Nothing to be done for `install-data-am'.
make[2]: Leaving directory `/home/user/lib_mysqludf_preg-1.0.1/doc'
make[1]: Leaving directory `/home/user/lib_mysqludf_preg-1.0.1/doc'
make[1]: Entering directory `/home/user/lib_mysqludf_preg-1.0.1'
make[2]: Entering directory `/home/user/lib_mysqludf_preg-1.0.1'
test -z "/usr/lib/mysql/plugin" || /bin/mkdir -p "/usr/lib/mysql/plugin"
/bin/sh ./libtool --mode=install /usr/bin/install -c 'lib_mysqludf_preg.la' '/usr/lib/mysql/plugin/lib_mysqludf_preg.la'
libtool: install: /usr/bin/install -c .libs/lib_mysqludf_preg.so /usr/lib/mysql/plugin/lib_mysqludf_preg.so
libtool: install: /usr/bin/install -c .libs/lib_mysqludf_preg.lai /usr/lib/mysql/plugin/lib_mysqludf_preg.la
libtool: install: /usr/bin/install -c .libs/lib_mysqludf_preg.a /usr/lib/mysql/plugin/lib_mysqludf_preg.a
libtool: install: chmod 644 /usr/lib/mysql/plugin/lib_mysqludf_preg.a
libtool: install: ranlib /usr/lib/mysql/plugin/lib_mysqludf_preg.a
libtool: finish: PATH="/usr/bin:/bin:/sbin" ldconfig -n /usr/lib/mysql/plugin
----------------------------------------------------------------------
Libraries have been installed in:
/usr/lib/mysql/plugin

If you ever happen to want to link against installed libraries
in a given directory, LIBDIR, you must either use libtool, and
specify the full pathname of the library, or use the `-LLIBDIR'
flag during linking and do at least one of the following:
- add LIBDIR to the `LD_LIBRARY_PATH' environment variable
during execution
- add LIBDIR to the `LD_RUN_PATH' environment variable
during linking
- use the `-Wl,-rpath -Wl,LIBDIR' linker flag
- have your system administrator add LIBDIR to `/etc/ld.so.conf'

See any operating system documentation about shared libraries for
more information, such as the ld(1) and ld.so(8) manual pages.
----------------------------------------------------------------------
make[2]: Nothing to be done for `install-data-am'.
make[2]: Leaving directory `/home/user/lib_mysqludf_preg-1.0.1'
make[1]: Leaving directory `/home/user/lib_mysqludf_preg-1.0.1'
[user@box lib_mysqludf_preg-1.0.1]$

Now installdb fails:

[user@box lib_mysqludf_preg-1.0.1]$ sudo make installdb
/usr/bin/mysql -p installdb_win.sql
if test -f .libs/lib_mysqludf_preg.dll; then \
/usr/bin/mysql -p ]]> http://bugs.mysqludf.org/?do=details&task_id=30 http://bugs.mysqludf.org/?do=details&task_id=30 Anonymous user Sat, 05 Feb 2011 08:37:12 +0100 mysql> SELECT PREG_CAPTURE('/\d+/', '123');
+------------------------------+
| PREG_CAPTURE('/\d+/', '123') |
+------------------------------+
| NULL |
+------------------------------+
1 row in set (0.00 sec)
]]> http://bugs.mysqludf.org/?do=details&task_id=29 http://bugs.mysqludf.org/?do=details&task_id=29 Anonymous user Fri, 07 Jan 2011 09:48:54 +0100 Database changed
mysql> create function lib_mysqludf_json_info returns string soname 'lib_mysqludf_json.so';
Query OK, 0 rows affected (0.00 sec)

mysql> create function json_array returns string soname 'lib_mysqludf_json.so';
Query OK, 0 rows affected (0.00 sec)

mysql> create function json_members returns string soname 'lib_mysqludf_json.so';
Query OK, 0 rows affected (0.00 sec)

mysql> # create function json_object returns string soname 'lib_mysqludf_json.so';
mysql> create function json_object returns string soname 'lib_mysqludf_json.so';
Query OK, 0 rows affected (0.01 sec)

mysql> create function json_values returns string soname 'lib_mysqludf_json.so';
Query OK, 0 rows affected (0.00 sec)

mysql> SET NAMES UTF8;
Query OK, 0 rows affected (0.00 sec)

mysql> USE test;
Database changed
mysql> CREATE TABLE IF NOT EXISTS `mytable` (
-> `id` int(10) NOT NULL AUTO_INCREMENT,
-> `addtime` int(10) NOT NULL,
-> `title` varchar(255) CHARACTER SET utf8 NOT NULL,
-> PRIMARY KEY (`id`)
-> ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
Query OK, 0 rows affected (0.01 sec)

mysql> insert into mytable set addtime=1, title=2;
Query OK, 1 row affected (0.00 sec)

mysql> SELECT json_object(id,addtime,title) FROM mytable WHERE id =1;
ERROR 1123 (HY000): Can't initialize function 'json_object'; Invalid json member name - name cannot be empty
mysql> ]]> http://bugs.mysqludf.org/?do=details&task_id=28 http://bugs.mysqludf.org/?do=details&task_id=28 Anonymous user Fri, 07 Jan 2011 09:45:39 +0100 Database changed
mysql> create function lib_mysqludf_json_info returns string soname 'lib_mysqludf_json.so';
Query OK, 0 rows affected (0.00 sec)

mysql> create function json_array returns string soname 'lib_mysqludf_json.so';
Query OK, 0 rows affected (0.00 sec)

mysql> create function json_members returns string soname 'lib_mysqludf_json.so';
Query OK, 0 rows affected (0.00 sec)

mysql> # create function json_object returns string soname 'lib_mysqludf_json.so';
mysql> create function json_object returns string soname 'lib_mysqludf_json.so';
Query OK, 0 rows affected (0.01 sec)

mysql> create function json_values returns string soname 'lib_mysqludf_json.so';
Query OK, 0 rows affected (0.00 sec)

mysql> SET NAMES UTF8;
Query OK, 0 rows affected (0.00 sec)

mysql> USE test;
Database changed
mysql> CREATE TABLE IF NOT EXISTS `mytable` (
-> `id` int(10) NOT NULL AUTO_INCREMENT,
-> `addtime` int(10) NOT NULL,
-> `title` varchar(255) CHARACTER SET utf8 NOT NULL,
-> PRIMARY KEY (`id`)
-> ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
Query OK, 0 rows affected (0.01 sec)

mysql> insert into mytable set addtime=1, title=2;
Query OK, 1 row affected (0.00 sec)

mysql> SELECT json_object(id,addtime,title) FROM mytable WHERE id =1;
ERROR 1123 (HY000): Can't initialize function 'json_object'; Invalid json member name - name cannot be empty
mysql> ]]> http://bugs.mysqludf.org/?do=details&task_id=27 http://bugs.mysqludf.org/?do=details&task_id=27 Anonymous user Sun, 02 Jan 2011 06:40:56 +0100
SELECT preg_capture('/h/g', 'hello');

returns the error
ERROR 1123 (HY000): Can't initialize function 'preg_capture'; Unknown modifier

]]> http://bugs.mysqludf.org/?do=details&task_id=26 http://bugs.mysqludf.org/?do=details&task_id=26 Anonymous user Fri, 17 Dec 2010 10:13:10 +0100
e.g.
preg_rlike('/.*/', ''); // returns 0, should return 1
preg_rlike('/a*/', 'b'); // returns 1, correct
preg_rlike('/a*/', ''); // returns 0, should return 1]]> http://bugs.mysqludf.org/?do=details&task_id=25 http://bugs.mysqludf.org/?do=details&task_id=25 Anonymous user Thu, 28 Oct 2010 08:53:23 +0200 With need to other users to execute stored procedures
thanks]]> http://bugs.mysqludf.org/?do=details&task_id=24 http://bugs.mysqludf.org/?do=details&task_id=24 Anonymous user Tue, 05 Oct 2010 15:43:50 +0200
Numeric values that cannot be represented as sequences of digits
(such as Infinity and NaN) are not permitted.

This inconsistency with the RFC leaves a number of properly implemented JSON clients broken. Please consider returning NULL instead or providing the means to turn off the use of NaN where JSON compliance is necessary.]]> http://bugs.mysqludf.org/?do=details&task_id=23 http://bugs.mysqludf.org/?do=details&task_id=23 Anonymous user Fri, 19 Mar 2010 21:20:30 +0100
ex:
SELECT PREG_CAPTURE("/\./", "a"); //returns a - should return null
SELECT PREG_CAPTURE("/\./", "."); //correctly returns .
SELECT PREG_CAPTURE("/[\.]/", "a"); //correctly returns null
SELECT PREG_CAPTURE("/[\.]/", "."); //correctly returns .]]> http://bugs.mysqludf.org/?do=details&task_id=20 http://bugs.mysqludf.org/?do=details&task_id=20 Anonymous user Thu, 21 Jan 2010 12:38:31 +0100 I am trying execute a ruby script but nothing happens
Neither the sys_eval is execute the command in arg
I was try:
mysql> SELECT sys_eval('id');
+----------------+
| sys_eval('id') |
+----------------+
| |
+----------------+
1 row in set (0,00 sec)
]]> http://bugs.mysqludf.org/?do=details&task_id=19 http://bugs.mysqludf.org/?do=details&task_id=19