after changing abs(x) to abs(-x),the value unexpectedly change

mysql> WITH cte_991 AS (SELECT ST_OVERLAPS(hpn91.c11, hpn91.c11) AS col_2 FROM t3 AS hpn91) (SELECT (SELECT s211.c12 AS subq_col FROM t3 AS s211 ORDER BY s211.c12 ASC LIMIT 1) AS col_1, AVG(rzi5.col_2) AS col_2 FROM cte_991 AS rzi5) UNION SELECT 2 AS col_1, ABS(60) AS col_2;

+------------+--------+

| col_1      | col_2  |

+------------+--------+

| sample_6UD | 0.0000 |

| 2          | 9.9999 |

+------------+--------+

2 rows in set (0.00 sec)

mysql> WITH cte_991 AS (SELECT ST_OVERLAPS(hpn91.c11, hpn91.c11) AS col_2 FROM t3 AS hpn91) (SELECT (SELECT s211.c12 AS subq_col FROM t3 AS s211 ORDER BY s211.c12 ASC LIMIT 1) AS col_1, AVG(rzi5.col_2) AS col_2 FROM cte_991 AS rzi5) UNION SELECT 2 AS col_1, ABS(-60) AS col_2;

+------------+---------+

| col_1      | col_2   |

+------------+---------+

| sample_6UD |  0.0000 |

| 2          | 60.0000 |

+------------+---------+

2 rows in set (0.00 sec)

DROP DATABASE IF EXISTS test;

CREATE DATABASE IF NOT EXISTS test;

SET GLOBAL sort_buffer_size = 64 * 1024 * 1024;

SET GLOBAL read_rnd_buffer_size = 8 * 1024 * 1024;

USE test;

CREATE TABLE t3 (

    c1 INT NOT NULL AUTO_INCREMENT,

    c2 INT NOT NULL,

    c3 INT NOT NULL,

    c4 YEAR NOT NULL,

    c5 DATETIME NULL,

    c6 TINYINT NULL,

    c7 SMALLINT NULL,

    c8 MEDIUMINT NULL,

    c9 BIGINT NULL,

    c10 LONGTEXT NULL,

    c11 GEOMETRY NULL,

    c12 TINYTEXT NULL,

    c13 TINYBLOB NULL,

    c14 SET('x','y','z') NULL,

    c15 TINYINT(1) NULL,

    PRIMARY KEY (c1)

);

INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (9473, 3166, 7923, 2009, '2025-10-28 00:33:04', 64, 33, 23, 5, 'sample_zTTcDyJQiepslGYJ3zx7HK7FrfiC27HYfiM2DyjEqVaxZXyJQZAk243c5b7yltsU3bDVzF2sv1hGOpsKD5u5Vsxz394dHEEgy83H8xb47ex2oB6Sq0o7pOfwoVHbKZu6RgdQZDvfErgKcrI6jjhxlh5vvf4A5bMHspZVCHf6xQTLobsltrxVRPWcVEpcFa5j1I95z3Z4Rjv7rhDXeACav9XF6AozF9GisKKaR6TZV1uqxe9tbHTweWshIEX8yNnrU3IxQZKPJKdvzuZULMFQtInIhk96d8YG30AdQ5pBtYaX65GusSaJXGMp3Ihk3IErQfBpVTu29NJzaMcfVkaVMp2xAwfBSI3cvVabVv8biqnHJEPV5TWpfuyEyNERmQB3uT4QchyRMQMwZvjD7dLdhzAswCYPfR1cgVswYIJ1uRUY5JmnVxXSazO9HaCdk42BhmyWoXGzKbcNQ4D5uw3C9jIuse73AKzFL2LkIeEwgZAsimZuiM7Q4EwQWxy7B09PFzXlmKpILqGuT0hKw5wsTyKNl0wjI2FNH2bPoVq4ujSAQDwJr4jSz38', ST_GeomFromText('POINT(-7.208789 -111.046928)'), 'sample_lo1SDGmMjznqDAbPH7lv1PLIycmmGnug3w9c1EMVaOOvVY0FM7GLWSZHVE6MVSrkzdR1XlrSer0Ae6U0ldCAgDDUG', X'CBBA34E99F8CDA95E4A2AFDF8210', 'z', NULL);

INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (2882, 1936, 8493, 2010, '2025-07-10 05:01:44', 81, 27, 4, 2, 'sample_wnGS7ObmR9bgXPg3HD1WWsqqVsu3pRQvkGlSu5JlNdpySbCYa0jrO24e0QXl8vVW8qp2ogfomqclWaVOmSJtLeysozpT5TAfPOr21SHckfRzC6uNedURG2jRQgzSBcgUY8SvzuutEaUryqUnVw3Ifcg3TfVqr3QSQ1HuxVGt5v5c3zid5noraDwZyTvDEjQITKvyknj1mDn7jrmYNXW9BkzsYexjbSwFmeS4M6EMvNwn4SQuxMIHGJtEfsNzpmW53SDj98b8VWWv53TApPFamxbGjtiJI1Gap0sPHU1MmaL0jGvhVpdF3q83QrINoEiPkOBwupcep0KjlPiyz2TECYjEWj6SnDcjHIGcGeoq9voScZ0MynwxNKuz8b8fe0AWeSDvv4141gAK', ST_GeomFromText('POINT(87.889954 -13.631796)'), 'sample_6UD', X'6ADA9114CBA457391E', 'y,z,x', NULL);

WITH cte_991 AS (SELECT ST_OVERLAPS(hpn91.c11, hpn91.c11) AS col_2 FROM t3 AS hpn91) (SELECT (SELECT s211.c12 AS subq_col FROM t3 AS s211 ORDER BY s211.c12 ASC LIMIT 1) AS col_1, AVG(rzi5.col_2) AS col_2 FROM cte_991 AS rzi5) UNION SELECT 2 AS col_1, ABS(60) AS col_2;

WITH cte_991 AS (SELECT ST_OVERLAPS(hpn91.c11, hpn91.c11) AS col_2 FROM t3 AS hpn91) (SELECT (SELECT s211.c12 AS subq_col FROM t3 AS s211 ORDER BY s211.c12 ASC LIMIT 1) AS col_1, AVG(rzi5.col_2) AS col_2 FROM cte_991 AS rzi5) UNION SELECT 2 AS col_1, ABS(-60) AS col_2;