Skip to content

udf_infusion incompatible with MariaDB 10.11 and 11.5: median(), percentile_disc() and percentile_cont() are already defined #30

@dreibh

Description

@dreibh

udf_infusion is incompatible with MariaDB 10.11 and 11.5: median(), percentile_disc() and percentile_cont() are already build-in functions. However, these built-in functions are window functions, not aggregate functions. My particular use case is to compute percentiles as aggregates, on really large tables used by HiPerConTracer, i.e. the built-in MariaDB functions are not efficiently applicable. udf_infusion provides the functions needed for this purpose.

I noticed the pull request #27 , which is working. That is, simply renaming the three functions fixes the issue with MariaDB.

For reference, this is the work-around to apply the pull request and get udf_infusion working with MariaDB:

git clone https://github.com/infusion/udf_infusion.git
cd udf_infusion
git remote add ngaro https://github.com/ngaro/udf_infusion.git
git fetch --all
git merge ngaro/nonative
./configure
make
sudo make install
mariadb [OPTIONS_HERE ...] < load.sql

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions