diff options
Diffstat (limited to 'databases/mysql-udf')
| -rw-r--r-- | databases/mysql-udf/Makefile | 44 | ||||
| -rw-r--r-- | databases/mysql-udf/distinfo | 3 | ||||
| -rw-r--r-- | databases/mysql-udf/files/patch-mysql_4.1 | 490 | ||||
| -rw-r--r-- | databases/mysql-udf/pkg-descr | 10 | ||||
| -rw-r--r-- | databases/mysql-udf/pkg-message | 31 |
5 files changed, 0 insertions, 578 deletions
diff --git a/databases/mysql-udf/Makefile b/databases/mysql-udf/Makefile deleted file mode 100644 index a5d70184f1f3..000000000000 --- a/databases/mysql-udf/Makefile +++ /dev/null @@ -1,44 +0,0 @@ -PORTNAME= mysql-udf -PORTVERSION= 0.3 -PORTREVISION= 3 -CATEGORIES= databases -MASTER_SITES= SF/${PORTNAME}/${PORTNAME}/${PORTNAME}-${PORTVERSION} - -MAINTAINER= ports@FreeBSD.org -COMMENT= Set of user-defined functions for the MySQL server -WWW= http://mysql-udf.sourceforge.net/ - -LICENSE= BSD2CLAUSE - -DEPRECATED= Upstream last update was in 2007 -EXPIRATION_DATE= 2023-12-31 - -USES= mysql -IGNORE_WITH_MYSQL= 80 - -CFLAGS+= -fPIC - -WRKSRC= ${WRKDIR}/${PORTNAME} - -MODULES= colwidth confidence_higher confidence_lower correlation \ - faculty geomean intercept kurtosis longest median noverm \ - skewness slope stdnorm_density stdnorm_dist weightedavg - -.for MODULE in ${MODULES} -PLIST_FILES+= lib/mysql/plugin/udf_${MODULE}.so -.endfor - -do-build: -.for MODULE in ${MODULES} - cd ${WRKSRC} && \ - ${CC} ${CFLAGS} -I${LOCALBASE}/include -I${LOCALBASE}/include/mysql -c -o udf_${MODULE}.o udf_${MODULE}.cc && \ - ${CC} -shared -o udf_${MODULE}.so udf_${MODULE}.o -.endfor - -do-install: - ${MKDIR} ${STAGEDIR}${PREFIX}/lib/mysql/plugin -.for MODULE in ${MODULES} - ${INSTALL_PROGRAM} ${WRKSRC}/udf_${MODULE}.so ${STAGEDIR}${PREFIX}/lib/mysql/plugin/udf_${MODULE}.so -.endfor - -.include <bsd.port.mk> diff --git a/databases/mysql-udf/distinfo b/databases/mysql-udf/distinfo deleted file mode 100644 index d1afcfd8f0c5..000000000000 --- a/databases/mysql-udf/distinfo +++ /dev/null @@ -1,3 +0,0 @@ -TIMESTAMP = 1467549429 -SHA256 (mysql-udf-0.3.tar.gz) = d9115aeecccfc06ccdc209a761a6a4d0dba70f15c9319ab76d173b04737beaf2 -SIZE (mysql-udf-0.3.tar.gz) = 6714 diff --git a/databases/mysql-udf/files/patch-mysql_4.1 b/databases/mysql-udf/files/patch-mysql_4.1 deleted file mode 100644 index 992f6a4d1554..000000000000 --- a/databases/mysql-udf/files/patch-mysql_4.1 +++ /dev/null @@ -1,490 +0,0 @@ -diff -C3 -r mysql-udf-orig/udf_colwidth.cc udf_colwidth.cc -*** mysql-udf-orig/udf_colwidth.cc 2004-07-16 00:35:05.000000000 +0200 ---- udf_colwidth.cc 2005-10-05 14:37:55.000000000 +0200 -*************** -*** 42,47 **** ---- 42,48 ---- - my_bool colwidth_init( UDF_INIT* initid, UDF_ARGS* args, char* message ); - void colwidth_deinit( UDF_INIT* initid ); - void colwidth_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); -+ void colwidth_clear( UDF_INIT* initid, char* is_null, char *error ); - void colwidth_add( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); - long long colwidth( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char* error ); - -*************** -*** 93,102 **** - - void colwidth_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char* message ) - { - struct colwidth_data* data = (struct colwidth_data*)initid->ptr; - - data->maxlength=(long long) 0; -- colwidth_add( initid, args, is_null, message ); - } - - ---- 94,110 ---- - - void colwidth_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char* message ) - { -+ -+ colwidth_clear( initid, is_null, message ); -+ colwidth_add( initid, args, is_null, message ); -+ } -+ -+ -+ void colwidth_clear( UDF_INIT* initid, char* is_null, char* message ) -+ { - struct colwidth_data* data = (struct colwidth_data*)initid->ptr; - - data->maxlength=(long long) 0; - } - - -diff -C3 -r mysql-udf-orig/udf_confidence_higher.cc udf_confidence_higher.cc -*** mysql-udf-orig/udf_confidence_higher.cc 2004-07-15 23:39:09.000000000 +0200 ---- udf_confidence_higher.cc 2005-06-01 10:19:48.000000000 +0200 -*************** -*** 38,43 **** ---- 38,44 ---- - #include <mysql.h> - #include <m_ctype.h> - #include <m_string.h> -+ #include <math.h> - - #ifdef HAVE_DLOPEN - -diff -C3 -r mysql-udf-orig/udf_confidence_lower.cc udf_confidence_lower.cc -*** mysql-udf-orig/udf_confidence_lower.cc 2004-07-15 23:38:17.000000000 +0200 ---- udf_confidence_lower.cc 2005-06-01 10:20:17.000000000 +0200 -*************** -*** 38,43 **** ---- 38,44 ---- - #include <mysql.h> - #include <m_ctype.h> - #include <m_string.h> -+ #include <math.h> - - #ifdef HAVE_DLOPEN - -diff -C3 -r mysql-udf-orig/udf_correlation.cc udf_correlation.cc -*** mysql-udf-orig/udf_correlation.cc 2004-07-16 00:31:41.000000000 +0200 ---- udf_correlation.cc 2005-10-05 14:14:22.000000000 +0200 -*************** -*** 36,41 **** ---- 36,42 ---- - #include <mysql.h> - #include <m_ctype.h> - #include <m_string.h> -+ #include <math.h> - - #ifdef HAVE_DLOPEN - -*************** -*** 49,54 **** ---- 50,56 ---- - my_bool correlation_init( UDF_INIT* initid, UDF_ARGS* args, char* message ); - void correlation_deinit( UDF_INIT* initid ); - void correlation_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); -+ void correlation_clear( UDF_INIT* initid, char* is_null, char *error ); - void correlation_add( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); - double correlation( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); - -*************** -*** 134,139 **** ---- 136,147 ---- - - void correlation_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char* is_error ) - { -+ correlation_clear( initid, is_null, is_error ); -+ correlation_add( initid, args, is_null, is_error ); -+ } -+ -+ void correlation_clear( UDF_INIT* initid, char* is_null, char* is_error ) -+ { - regression_data *buffer = (regression_data*)initid->ptr; - buffer->count = 0; - buffer->abscount=0; -*************** -*** 156,162 **** - buffer->valuesx=(double *) malloc(BUFFERSIZE*sizeof(double)); - buffer->valuesy=(double *) malloc(BUFFERSIZE*sizeof(double)); - -- correlation_add( initid, args, is_null, is_error ); - } - - ---- 164,169 ---- -diff -C3 -r mysql-udf-orig/udf_geomean.cc udf_geomean.cc -*** mysql-udf-orig/udf_geomean.cc 2004-07-16 00:10:42.000000000 +0200 ---- udf_geomean.cc 2005-10-05 15:06:05.000000000 +0200 -*************** -*** 34,39 **** ---- 34,40 ---- - #include <mysql.h> - #include <m_ctype.h> - #include <m_string.h> -+ #include <math.h> - - #ifdef HAVE_DLOPEN - -*************** -*** 43,48 **** ---- 44,50 ---- - my_bool geomean_init( UDF_INIT* initid, UDF_ARGS* args, char* message ); - void geomean_deinit( UDF_INIT* initid ); - void geomean_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); -+ void geomean_clear( UDF_INIT* initid, char* is_null, char *error ); - void geomean_add( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); - double geomean( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); - } -*************** -*** 104,109 **** ---- 106,117 ---- - - void geomean_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char* is_error ) - { -+ geomean_clear( initid, is_null, is_error ); -+ geomean_add( initid, args, is_null, is_error ); -+ } -+ -+ void geomean_clear( UDF_INIT* initid, char* is_null, char* is_error ) -+ { - geomean_data *buffer = (geomean_data*)initid->ptr; - buffer->count = 0; - buffer->value=0; -*************** -*** 111,117 **** - *is_null = 0; - *is_error = 0; - -- geomean_add( initid, args, is_null, is_error ); - } - - ---- 119,124 ---- -diff -C3 -r mysql-udf-orig/udf_intercept.cc udf_intercept.cc -*** mysql-udf-orig/udf_intercept.cc 2004-07-16 00:29:17.000000000 +0200 ---- udf_intercept.cc 2005-10-05 14:45:26.000000000 +0200 -*************** -*** 48,53 **** ---- 48,54 ---- - my_bool intercept_init( UDF_INIT* initid, UDF_ARGS* args, char* message ); - void intercept_deinit( UDF_INIT* initid ); - void intercept_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); -+ void intercept_clear( UDF_INIT* initid, char* is_null, char *error ); - void intercept_add( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); - double intercept( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); - -*************** -*** 133,138 **** ---- 134,145 ---- - - void intercept_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char* is_error ) - { -+ intercept_clear( initid, is_null, is_error ); -+ intercept_add( initid, args, is_null, is_error ); -+ } -+ -+ void intercept_clear( UDF_INIT* initid, char* is_null, char* is_error ) -+ { - regression_data *buffer = (regression_data*)initid->ptr; - buffer->count = 0; - buffer->abscount=0; -*************** -*** 155,165 **** - buffer->valuesx=(double *) malloc(BUFFERSIZE*sizeof(double)); - buffer->valuesy=(double *) malloc(BUFFERSIZE*sizeof(double)); - -- intercept_add( initid, args, is_null, is_error ); - } - - -- - void intercept_add( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char* is_error ) - { - if (args->args[0]!=NULL && args->args[1]!=NULL) ---- 162,170 ---- -diff -C3 -r mysql-udf-orig/udf_kurtosis.cc udf_kurtosis.cc -*** mysql-udf-orig/udf_kurtosis.cc 2004-07-15 23:55:53.000000000 +0200 ---- udf_kurtosis.cc 2005-10-05 14:47:25.000000000 +0200 -*************** -*** 34,39 **** ---- 34,40 ---- - #include <mysql.h> - #include <m_ctype.h> - #include <m_string.h> -+ #include <math.h> - - #ifdef HAVE_DLOPEN - -*************** -*** 46,51 **** ---- 47,53 ---- - my_bool kurtosis_init( UDF_INIT* initid, UDF_ARGS* args, char* message ); - void kurtosis_deinit( UDF_INIT* initid ); - void kurtosis_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); -+ void kurtosis_clear( UDF_INIT* initid, char* is_null, char *error ); - void kurtosis_add( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); - double kurtosis( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); - } -*************** -*** 116,121 **** ---- 118,130 ---- - - void kurtosis_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char* is_error ) - { -+ kurtosis_clear( initid, is_null, is_error ); -+ kurtosis_add( initid, args, is_null, is_error ); -+ } -+ -+ -+ void kurtosis_clear( UDF_INIT* initid, char* is_null, char* is_error ) -+ { - kurtosis_data *buffer = (kurtosis_data*)initid->ptr; - buffer->count = 0; - buffer->abscount=0; -*************** -*** 131,137 **** - - buffer->values=(double *) malloc(BUFFERSIZE*sizeof(double)); - -- kurtosis_add( initid, args, is_null, is_error ); - } - - ---- 140,145 ---- -diff -C3 -r mysql-udf-orig/udf_longest.cc udf_longest.cc -*** mysql-udf-orig/udf_longest.cc 2004-07-16 00:34:09.000000000 +0200 ---- udf_longest.cc 2005-10-05 14:48:58.000000000 +0200 -*************** -*** 41,46 **** ---- 41,47 ---- - my_bool longest_init( UDF_INIT* initid, UDF_ARGS* args, char* message ); - void longest_deinit( UDF_INIT* initid ); - void longest_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); -+ void longest_clear( UDF_INIT* initid, char* is_null, char *error ); - void longest_add( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); - char *longest(UDF_INIT * initid, UDF_ARGS *args, char *result, unsigned long *length, char *is_null, char * /*error*/ ); - } -*************** -*** 97,102 **** ---- 98,109 ---- - - void longest_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char* message ) - { -+ longest_clear( initid, is_null, message ); -+ longest_add( initid, args, is_null, message ); -+ } -+ -+ void longest_clear( UDF_INIT* initid, char* is_null, char* message ) -+ { - struct longest_data* data = (struct longest_data*) initid->ptr; - if (data->result_string != NULL) - { -*************** -*** 105,111 **** - } - data->length = 0; - *is_null = 0; -- longest_add( initid, args, is_null, message ); - } - - ---- 112,117 ---- -diff -C3 -r mysql-udf-orig/udf_median.cc udf_median.cc -*** mysql-udf-orig/udf_median.cc 2004-07-16 00:11:52.000000000 +0200 ---- udf_median.cc 2005-10-05 13:49:00.000000000 +0200 -*************** -*** 46,51 **** ---- 46,52 ---- - my_bool median_init( UDF_INIT* initid, UDF_ARGS* args, char* message ); - void median_deinit( UDF_INIT* initid ); - void median_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); -+ void median_clear( UDF_INIT* initid, char* is_null, char *error ); - void median_add( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); - double median( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); - } -*************** -*** 116,121 **** ---- 117,128 ---- - - void median_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char* is_error ) - { -+ median_clear(initid, is_null, is_error); -+ median_add( initid, args, is_null, is_error ); -+ } -+ -+ void median_clear( UDF_INIT* initid, char* is_null, char* is_error ) -+ { - median_data *buffer = (median_data*)initid->ptr; - buffer->count = 0; - buffer->abscount=0; -*************** -*** 131,140 **** - - buffer->values=(double *) malloc(BUFFERSIZE*sizeof(double)); - -- median_add( initid, args, is_null, is_error ); - } - -- - void median_add( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char* is_error ) - { - if (args->args[0]!=NULL) ---- 138,145 ---- -diff -C3 -r mysql-udf-orig/udf_skewness.cc udf_skewness.cc -*** mysql-udf-orig/udf_skewness.cc 2004-07-15 23:56:06.000000000 +0200 ---- udf_skewness.cc 2005-10-05 14:51:28.000000000 +0200 -*************** -*** 34,39 **** ---- 34,40 ---- - #include <mysql.h> - #include <m_ctype.h> - #include <m_string.h> -+ #include <math.h> - - #ifdef HAVE_DLOPEN - -*************** -*** 46,51 **** ---- 47,53 ---- - my_bool skewness_init( UDF_INIT* initid, UDF_ARGS* args, char* message ); - void skewness_deinit( UDF_INIT* initid ); - void skewness_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); -+ void skewness_clear( UDF_INIT* initid, char* is_null, char *error ); - void skewness_add( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); - double skewness( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); - } -*************** -*** 116,121 **** ---- 118,129 ---- - - void skewness_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char* is_error ) - { -+ skewness_clear( initid, is_null, is_error ); -+ skewness_add( initid, args, is_null, is_error ); -+ } -+ -+ void skewness_clear( UDF_INIT* initid, char* is_null, char* is_error ) -+ { - skewness_data *buffer = (skewness_data*)initid->ptr; - buffer->count = 0; - buffer->abscount=0; -*************** -*** 131,137 **** - - buffer->values=(double *) malloc(BUFFERSIZE*sizeof(double)); - -- skewness_add( initid, args, is_null, is_error ); - } - - ---- 139,144 ---- -diff -C3 -r mysql-udf-orig/udf_slope.cc udf_slope.cc -*** mysql-udf-orig/udf_slope.cc 2004-07-16 00:28:02.000000000 +0200 ---- udf_slope.cc 2005-10-05 14:53:30.000000000 +0200 -*************** -*** 49,54 **** ---- 49,55 ---- - my_bool slope_init( UDF_INIT* initid, UDF_ARGS* args, char* message ); - void slope_deinit( UDF_INIT* initid ); - void slope_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); -+ void slope_clear( UDF_INIT* initid, char* is_null, char *error ); - void slope_add( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); - double slope( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); - -*************** -*** 134,139 **** ---- 135,146 ---- - - void slope_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char* is_error ) - { -+ slope_clear( initid, is_null, is_error ); -+ slope_add( initid, args, is_null, is_error ); -+ } -+ -+ void slope_clear( UDF_INIT* initid, char* is_null, char* is_error ) -+ { - regression_data *buffer = (regression_data*)initid->ptr; - buffer->count = 0; - buffer->abscount=0; -*************** -*** 156,162 **** - buffer->valuesx=(double *) malloc(BUFFERSIZE*sizeof(double)); - buffer->valuesy=(double *) malloc(BUFFERSIZE*sizeof(double)); - -- slope_add( initid, args, is_null, is_error ); - } - - ---- 163,168 ---- -diff -C3 -r mysql-udf-orig/udf_stdnorm_density.cc udf_stdnorm_density.cc -*** mysql-udf-orig/udf_stdnorm_density.cc 2004-07-16 00:00:20.000000000 +0200 ---- udf_stdnorm_density.cc 2005-06-01 11:43:29.000000000 +0200 -*************** -*** 34,39 **** ---- 34,40 ---- - #include <mysql.h> - #include <m_ctype.h> - #include <m_string.h> -+ #include <math.h> - - #ifdef HAVE_DLOPEN - -*************** -*** 42,48 **** - { - - my_bool stdnorm_density_init(UDF_INIT *, UDF_ARGS *args, char *message); -! double stdnorm_density_(UDF_INIT *initid, UDF_ARGS *args, char *is_null,char *error); - - } - ---- 43,49 ---- - { - - my_bool stdnorm_density_init(UDF_INIT *, UDF_ARGS *args, char *message); -! double stdnorm_density(UDF_INIT *initid, UDF_ARGS *args, char *is_null,char *error); - - } - -diff -C3 -r mysql-udf-orig/udf_weightedavg.cc udf_weightedavg.cc -*** mysql-udf-orig/udf_weightedavg.cc 2004-07-29 21:15:43.000000000 +0200 ---- udf_weightedavg.cc 2005-10-05 14:55:18.000000000 +0200 -*************** -*** 44,49 **** ---- 44,50 ---- - my_bool weightedavg_init( UDF_INIT* initid, UDF_ARGS* args, char* message ); - void weightedavg_deinit( UDF_INIT* initid ); - void weightedavg_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); -+ void weightedavg_clear( UDF_INIT* initid, char* is_null, char *error ); - void weightedavg_add( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); - double weightedavg( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char *error ); - } -*************** -*** 111,116 **** ---- 112,124 ---- - - void weightedavg_reset( UDF_INIT* initid, UDF_ARGS* args, char* is_null, char* is_error ) - { -+ weightedavg_clear( initid, is_null, is_error ); -+ weightedavg_add( initid, args, is_null, is_error ); -+ } -+ -+ -+ void weightedavg_clear( UDF_INIT* initid, char* is_null, char* is_error ) -+ { - weightedavg_data *buffer = (weightedavg_data*)initid->ptr; - buffer->count = 0; - buffer->datasum = 0; -*************** -*** 118,124 **** - *is_null = 0; - *is_error = 0; - -- weightedavg_add( initid, args, is_null, is_error ); - } - - ---- 126,131 ---- diff --git a/databases/mysql-udf/pkg-descr b/databases/mysql-udf/pkg-descr deleted file mode 100644 index 6525feaf70a7..000000000000 --- a/databases/mysql-udf/pkg-descr +++ /dev/null @@ -1,10 +0,0 @@ -This package adds several user-defined statistics functions -to the MySQL server providing the ability to: - - * calculate the median of any values, - * calculate the skewness and kurtosis of a distribution of value - * retrieve the effective length of the longest value in a STRING column, - * get the longest value from a STRING column, - * calculate the faculty of a value, - * calculate linear regression parameters (intercept, slope, correlation - coefficent) of any values diff --git a/databases/mysql-udf/pkg-message b/databases/mysql-udf/pkg-message deleted file mode 100644 index 157d9ddb2bc8..000000000000 --- a/databases/mysql-udf/pkg-message +++ /dev/null @@ -1,31 +0,0 @@ -[ -{ type: install - message: <<EOM -To add the custom functions to your MySQL server use the following syntax: -(you may install only the functions you need): - -CREATE AGGREGATE FUNCTION median RETURNS REAL SONAME 'udf_median.so'; -CREATE AGGREGATE FUNCTION correlation RETURNS REAL SONAME 'udf_correlation.so'; -CREATE AGGREGATE FUNCTION intercept RETURNS REAL SONAME 'udf_intercept.so'; -CREATE AGGREGATE FUNCTION slope RETURNS REAL SONAME 'udf_slope.so'; -CREATE AGGREGATE FUNCTION skewness RETURNS REAL SONAME 'udf_skewness.so'; -CREATE AGGREGATE FUNCTION kurtosis RETURNS REAL SONAME 'udf_kurtosis.so'; -CREATE FUNCTION confidence_higher RETURNS REAL SONAME 'udf_confidence_higher.so'; -CREATE FUNCTION confidence_lower RETURNS REAL SONAME 'udf_confidence_lower.so'; -CREATE FUNCTION stdnorm_density RETURNS REAL SONAME 'udf_stdnorm_density.so'; -CREATE FUNCTION stdnorm_dist RETURNS REAL SONAME 'udf_stdnorm_dist.so'; -CREATE AGGREGATE FUNCTION geomean RETURNS REAL SONAME 'udf_geomean.so'; -CREATE AGGREGATE FUNCTION weightedavg RETURNS REAL SONAME 'udf_weightedavg.so'; -CREATE FUNCTION noverm RETURNS INTEGER SONAME 'udf_noverm.so'; -CREATE FUNCTION faculty RETURNS REAL SONAME 'udf_faculty.so'; -CREATE AGGREGATE FUNCTION COLWIDTH RETURNS INTEGER SONAME 'udf_colwidth.so'; -CREATE AGGREGATE FUNCTION LONGEST RETURNS STRING SONAME 'udf_longest.so'; - -Example for deinstalling a function: -DROP FUNCTION median; - -For function descriptions, see the following webpage: -http://mysql-udf.sourceforge.net/ -EOM -} -] |