hholzgra / mysql-udf-regexp Goto Github PK

View Code? Open in Web Editor NEW

129.0 14.0 14.0 474 KB

MySQL User Defined Functions module implementing REGEXP_...() functions

License: GNU General Public License v2.0

Shell 87.41% C 12.59%

mariadb mysql udf

mysql-udf-regexp's Introduction

mysql-udf-regexp

This package impelemnts regular expression functions as MySQL User Defined Functions (UDFs).

The functions implemented by this package are:

REGEXP_LIKE(text, pattern [, mode])
REGEXP_SUBSTR(text, pattern [,position [,occurence [,mode]]])
REGEXP_INSTR?(text, pattern [,position [,occurence [,return_end [,mode]]]])
REGEXP_REPLACE?(text, pattern, replace [,position [,occurence [,return_end [,mode]]])

The functions support the same regular expression syntax as the MySQL REGEXP operator as documented in the Regular Expressions appendix of the MySQL manual.

These functions are very similar to the Oracle SQL functions by the same name. They are not 100% compatible but should be good enough to act as replacements in most common use cases.

mysql-udf-regexp's People

Contributors

Stargazers

Watchers

Forkers

1060460048 marsojane qingqingqing brewneaux mark-leppa jimolucy neo-nie eddyoc mdabbagh88 moshonk wuranbo fgaroby rowayda-khayri icdcom

mysql-udf-regexp's Issues

undefined symbol: _db_enter_

Was trying to create the functions after I placed the compiled regexp.so into my /usr/lib/mysql/plugin, but got:

ERROR 1126 (HY000): Can't open shared library 'regexp.so' (errno: 0 /usr/lib/mysql/plugin/regexp.so: undefined symbol: _db_enter_)

Only found http://bugs.mysql.com/bug.php?id=60872 as a reference for this problem, but I don't know exactly how I could deal with it.

Beginning of line anchor doesn't seem to work in REGEXP_REPLACE

Here's a normal replacement, without any anchors (works fine):

mysql> SELECT REGEXP_REPLACE('ABCABC', 'A', '*');
+------------------------------------+
| REGEXP_REPLACE('ABCABC', 'A', '*') |
+------------------------------------+
| *BC*BC                             |
+------------------------------------+
1 row in set (0.00 sec)

If we add the beginning of line anchor, it fails to replace:

mysql> SELECT REGEXP_REPLACE('ABCABC', '^A', '*');
+-------------------------------------+
| REGEXP_REPLACE('ABCABC', '^A', '*') |
+-------------------------------------+
| ABCABC                              |
+-------------------------------------+
1 row in set (0.00 sec)

End of line anchor works fine:

mysql> SELECT REGEXP_REPLACE('ABCABC', 'C$', '*');
+-------------------------------------+
| REGEXP_REPLACE('ABCABC', 'C$', '*') |
+-------------------------------------+
| ABCAB*                              |
+-------------------------------------+
1 row in set (0.00 sec)

Trying to install on a mac

Not really an issue - I'm just trying to install this package on a mac and get this error back with I try to get an error:
./udf_regexp.h:34:11: fatal error: 'regex/my_regex.h' file not found

I bet I am missing something...

Support for out of tree MySQL builds (--with-mysql-src)

mysql-udf-regexp requires not only a source tree of MySQL, it also needs to have the configure process run at least once there (#6). Because it checks for mysql_version.h and mysql_version.h.in to be in the same directory this will not work for out-of-tree builds (with different directories for the pristine source and the configure-generated or object files).

Documentation issues

Some minor documentation issues...

it was not exactly clear by looking at the top level's README file to figure out that the autogenerated INSTALL file in the regexp subdirectory contains the actual installation procedure
"configuring" the mysql tree meant to install cmake and execute cmake . in the MySQL source tree, otherwise the configure script of this extension did not accept the source at all
I figured that using --with-mysql-src was not at all possible, instead ./configure CFLAGS="-I/usr/include/mysql -I/path/to/mysql/src" was sufficient as well as an alternative, is this correct?

./libtool: line 860: X--tag=CC: command not found

$ make
make  all-am
make[1]: Entering directory `/usr/home/saper/sw/mysql-udf-regexp/regexp'
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I.    -I/usr/home/saper/sw/mysql-5.6.31/include -I/usr/home/saper/sw/mysql-5.6.31  -I/usr/home/saper/sw/mysql-5.6.31/sql  -g -O2 -MT regexp_la-regexp.lo -MD -MP -MF ".deps/regexp_la-regexp.Tpo" -c -o regexp_la-regexp.lo `test -f 'regexp.c' || echo './'`regexp.c; \
then mv -f ".deps/regexp_la-regexp.Tpo" ".deps/regexp_la-regexp.Plo"; else rm -f ".deps/regexp_la-regexp.Tpo"; exit 1; fi
./libtool: line 860: X--tag=CC: command not found
./libtool: line 893: libtool: ignoring unknown tag : command not found
./libtool: line 860: X--mode=compile: command not found
./libtool: line 1010: *** Warning: inferring the mode of operation is deprecated.: command not found
./libtool: line 1011: *** Future versions of Libtool will require --mode=MODE be specified.: command not found
./libtool: line 1154: Xgcc: command not found
./libtool: line 1154: X-DHAVE_CONFIG_H: command not found
./libtool: line 1154: X-I.: command not found
./libtool: line 1154: X-I.: command not found
./libtool: line 1154: X-I.: command not found
./libtool: line 1154: X-I/usr/home/saper/sw/mysql-5.6.31/include: No such file or directory
./libtool: line 1154: X-I/usr/home/saper/sw/mysql-5.6.31: No such file or directory
./libtool: line 1154: X-I/usr/home/saper/sw/mysql-5.6.31/sql: No such file or directory
./libtool: line 1154: X-g: command not found
./libtool: line 1154: X-O2: command not found
./libtool: line 1154: X-MT: command not found
./libtool: line 1154: Xregexp_la-regexp.lo: command not found
./libtool: line 1154: X-MD: command not found
./libtool: line 1154: X-MP: command not found
./libtool: line 1154: X-MF: command not found
./libtool: line 1154: X.deps/regexp_la-regexp.Tpo: No such file or directory
./libtool: line 1154: X-c: command not found
./libtool: line 1205: Xregexp_la-regexp.lo: command not found
./libtool: line 1210: libtool: compile: cannot determine name of library object from `': command not found
make[1]: *** [regexp_la-regexp.lo] Error 1
make[1]: Leaving directory `/usr/home/saper/sw/mysql-udf-regexp/regexp'
make: *** [all] Error 2

Trying to install on ubuntu

When I trying to install on ubuntu 14.04 LTS I have an error:

ccc@ubuntu:/Desktop/mysql-udf-regexp/regexp$ sudo make install
if /bin/bash ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -g -O2 -MT regexp_la-regexp.lo -MD -MP -MF ".deps/regexp_la-regexp.Tpo" -c -o regexp_la-regexp.lo test -f 'regexp.c' || echo './'regexp.c;
then mv -f ".deps/regexp_la-regexp.Tpo" ".deps/regexp_la-regexp.Plo"; else rm -f ".deps/regexp_la-regexp.Tpo"; exit 1; fi
mkdir .libs
gcc -DHAVE_CONFIG_H -I. -I. -I. -g -O2 -MT regexp_la-regexp.lo -MD -MP -MF .deps/regexp_la-regexp.Tpo -c regexp.c -fPIC -DPIC -o .libs/regexp_la-regexp.o
regexp.c:56:23: fatal error: my_global.h: No such file or directory
#include <my_global.h>
^
compilation terminated.
make: *** [regexp_la-regexp.lo] Error 1
ccc@ubuntu:/Desktop/mysql-udf-regexp/regexp$ locate my_global.h
/usr/include/mysql/my_global.h
Please help

configure on mac os yosemite fails

config.log.zip

System: mac os x yosemite 10.10.5
mysql source: 5.5.38 (/usr/local/mysql)
statement: ./configure --with-mysql-src=/usr/local/mysql-5.5.38/

"checking for mysql source directory... configure: error: not configured yet"

hholzgra / mysql-udf-regexp Goto Github PK

mysql-udf-regexp's Introduction

mysql-udf-regexp

mysql-udf-regexp's People

Contributors

Stargazers

Watchers

Forkers

mysql-udf-regexp's Issues

undefined symbol: _db_enter_

Beginning of line anchor doesn't seem to work in REGEXP_REPLACE

Trying to install on a mac

Support for out of tree MySQL builds (--with-mysql-src)

Documentation issues

./libtool: line 860: X--tag=CC: command not found

Trying to install on ubuntu

configure on mac os yosemite fails

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent