# 1305 - FUNCTION ANY_VALUE does not exist

1

I am replicating a linux server database on my laptop, but in the queries it occurs an error that #1305 - FUNCTION ANY_VALUE does not exist whose query I did myself in servidor linux which runs without problems, I just installed the version of xampp 3.2.2 and phpmyadmin 4.8.4 which is more recent and was included in XAMPP .

SELECT
    estado AS estado,
    ANY_VALUE(ano) AS ano,
    ANY_VALUE(fecha) AS NAME
FROM
    (
    SELECT
        f.estadoF AS estado,
        YEAR(p.fechaP) AS ano,
        MONTHNAME(p.fechaP) AS fecha
    FROM
        pagos p
    INNER JOIN factura f ON
        p.idFactura = f.idFactura
    WHERE
        (f.estadoF = 'Pagado') AND(
            p.fechaP BETWEEN '2018-01-01' AND '2018-12-31'
        )
    GROUP BY
        p.fechaP
) pagos
GROUP BY
    mes

Regarding the versions of MySQL on the server is MySQL 5.7.* and XAMPP is MariaDB 10.1.* which works fine, but does not recognize ANY_VALUE() .

Any suggestions for Update or Optimize judgment?

    
asked by user75463 28.12.2018 в 23:19
source

0 answers