FUNCTION ANY_VALUE does not exist MariaDB 10.1.45

[Somesh Zade]

We have migrated some accounts on the client's VPS and one of the accounts replicating this issue. Your help will be highly appreciated.

Error Number: 1305



FUNCTION gstprime_latest.ANY_VALUE does not exist



SELECT ANY_VALUE(SUM(taxableAmount+freightAmount)*currencyFactor) as total, ANY_VALUE(date_format(str_to_date(invoiceDate,'%d/%m/%Y'),'%Y-%m')) as newDate, MONTHNAME(date_format(str_to_date(invoiceDate,'%d/%m/%Y'),'%Y-%m-%d')) as month, ANY_VALUE(Year(date_format(str_to_date(invoiceDate,'%d/%m/%Y'),'%Y-%m-%d'))) as year, ANY_VALUE(date_format(str_to_date(invoiceDate,'%d/%m/%Y'),'%Y-%m-%d')) as chartDate FROM `seller_transactions` WHERE userId = '25' AND set_up = '12' AND cancelled != 'Y' AND date_format(str_to_date(invoiceDate,'%d/%m/%Y'),'%Y-%m-%d') >= '2020-04-01' AND date_format(str_to_date(invoiceDate,'%d/%m/%Y'),'%Y-%m-%d') <= '2020-07-17' GROUP BY month



Filename: models/ReportModel.php

 

[cPanelLauren]

There is a longstanding open case with MariaDB [MDEV-10426] ANY_VALUE function as a workaround for ONLY_FULL_GROUP_BY mode and compatibility with MySQL 5.7 - Jira on this issue.

I found a workaround suggested there as well as one here: MariaDb does not support ANY_VALUE() function