Searches without login should now work. You must get asked to click a button.
Port details
mysql-udfSet of user-defined functions for the MySQL server
0.3_3databasesΣ=0 0.3_3Version of this port present on the latest quarterly branch.
DEPRECATED: Upstream last update was in 2007 This port expired on: 2023-12-31 IGNORE: cannot install: does not work with MySQL version 80 (MySQL 105m 106m 1011m 80 81 not supported)
There is no maintainer for this port.
Any concerns regarding this port should be directed to the FreeBSD Ports mailing list via ports@FreeBSD.org
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
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/
*/*: Refactor with IGNORE_WITH_MYSQL
- There are multiple ports which has MYSQL options and are non-DEFAULT.
Most of the time committers actually forget to check with the OPTION
enabled and in some cases they are BROKEN with newr versions of mysql.
So test with different versions of mysql and mark IGNOPRE_WITH_MYSQL
appropriately. Due to the EOL of 5.7 this has not been checked.
- Unbreak sysutils/cfengine* with MySQL 8.0 and later
- The primary purpose of running this check is having statistics of the
MySQL usability over MariaDB to explore the future possibility of
shifting to MariaDB as the default as major ports upstream have moved
their codebase to support MariaDB over MySQL.
- The following actions will also be taken after the sunset of MySQL 5.7
If a port is broken on all instances of MySQL/MariaDB:
- If a port has the option of multiple DB backends and MySQL is the
default then the DEFAULT will be changed to PGSQL/SQLITE before
2024Q1. And the OPTION will be removed before 2024Q2. If a
MAINTAINER is aware about such cases and want to prefer PGSQL over
SQLITE or vice versa please do so at your own accord. Otherwise
PGSQL will be preferred over SQLITE.
- If a port has the option of multiple DB backends and MySQL is not
the default then the the OPTION will be removed before 2024Q1.
Approved by: portmgr (blanket)
databases/mysql-udf: Mark DEPRECATED
- Upstream mentions about using MySQL 4.0 and has not been updated since
2007
- Set EXPIRATION_DATE on 2023-12-31 along with MySQL 5.7
- Add LICENSE=BSD2CLAUSE as mentioned in their homepage
- Mark to ignore with mysql 8.0 [1]
PR: 269203 [1]
Reported by: exp-run [1]
Remove WWW entries moved into port Makefiles
Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.
This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.
Approved by: portmgr (tcberner)
Add WWW entries to port Makefiles
It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.
Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.
There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.
(Only the first 15 lines of the commit message are shown above )
databases/mysql-udf: fix build on powerpc(64) with clang
Error:
ld: error: relocation R_PPC64_TOC16_LO cannot be used against symbol
compare_doubles(void const*, void const*); recompile with -fPIC
databases/mysql-udf: enable PIC on arm64 and i386, for lld
Shared objects should be built as PIC, and lld enforces this by default.
Add aarch64 and i386 cases to the existing set of per-arch CFLAGS, and
remove the BROKEN_aarch64.
Approved by: portmgr (lld blanket)
Sponsored by: The FreeBSD Foundation
databases/mysql-udf: Fix building with MariaDB
- Work around MySQL's include/mysql/mysql directory
- Add -I ${LOCALBASE}/include to CFLAGS
- Move from USE_MYSQL to USES= mysql
PR: 199556
This package adds several user-defined statistical 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
WWW: http://mysql-udf.sourceforge.net/
