Details
Major Description
after changing RTRIM('sample_21') to RTRIM(RTRIM('sample_21')),the ROUND value unexpectedly change
mysql> WITH cte_840 AS (SELECT ST_ASWKT(dku42.c11) AS col_1, EXP(dku42.c8) AS col_2 FROM t3 AS dku42) SELECT DISTINCT JSON_ARRAYAGG('sample_71') AS col_1, RTRIM('sample_21') AS col_1_2, ROUND(subq.col_2) AS col_1_4, subq.col_2 AS col_2 FROM (SELECT JSON_OBJECTAGG(s627.col_1, s627.col_1) AS json_objectagg_547, s627.col_2 AS col_2 FROM cte_840 AS s627 GROUP BY s627.col_2) AS subq GROUP BY RTRIM('sample_21'), subq.col_2, ROUND(subq.col_2); |
+---------------+-----------+-----------------------------------+-----------------------+
|
| col_1 | col_1_2 | col_1_4 | col_2 |
|
+---------------+-----------+-----------------------------------+-----------------------+
|
| ["sample_71"] | sample_21 | 373324199679900150000000000000000 | 3.7332419967990015e32 | |
+---------------+-----------+-----------------------------------+-----------------------+
|
1 row in set (0.00 sec) |
|
|
mysql> WITH cte_840 AS (SELECT ST_ASWKT(dku42.c11) AS col_1, EXP(dku42.c8) AS col_2 FROM t3 AS dku42) SELECT DISTINCT JSON_ARRAYAGG('sample_71') AS col_1, RTRIM(RTRIM('sample_21')) AS col_1_2, ROUND(subq.col_2) AS col_1_4, subq.col_2 AS col_2 FROM (SELECT JSON_OBJECTAGG(s627.col_1, s627.col_1) AS json_objectagg_547, s627.col_2 AS col_2 FROM cte_840 AS s627 GROUP BY s627.col_2) AS subq GROUP BY RTRIM('sample_21'), subq.col_2, ROUND(subq.col_2); |
+---------------+-----------+--------------------+-----------------------+
|
| col_1 | col_1_2 | col_1_4 | col_2 |
|
+---------------+-----------+--------------------+-----------------------+
|
| ["sample_71"] | sample_21 | 100000000000000000 | 3.7332419967990015e32 | |
+---------------+-----------+--------------------+-----------------------+
|
1 row in set (0.00 sec) |
How to repeat
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 ( |
c8 MEDIUMINT NULL, |
c11 GEOMETRY NULL |
);
|
|
|
INSERT INTO t3 (c8,c11) VALUES (75, ST_GeomFromText('POINT(80.697149 18.381227)')); |
WITH cte_840 AS (SELECT ST_ASWKT(dku42.c11) AS col_1, EXP(dku42.c8) AS col_2 FROM t3 AS dku42) SELECT DISTINCT JSON_ARRAYAGG('sample_71') AS col_1, RTRIM('sample_21') AS col_1_2, ROUND(subq.col_2) AS col_1_4, subq.col_2 AS col_2 FROM (SELECT JSON_OBJECTAGG(s627.col_1, s627.col_1) AS json_objectagg_547, s627.col_2 AS col_2 FROM cte_840 AS s627 GROUP BY s627.col_2) AS subq GROUP BY RTRIM('sample_21'), subq.col_2, ROUND(subq.col_2); |
WITH cte_840 AS (SELECT ST_ASWKT(dku42.c11) AS col_1, EXP(dku42.c8) AS col_2 FROM t3 AS dku42) SELECT DISTINCT JSON_ARRAYAGG('sample_71') AS col_1, RTRIM(RTRIM('sample_21')) AS col_1_2, ROUND(subq.col_2) AS col_1_4, subq.col_2 AS col_2 FROM (SELECT JSON_OBJECTAGG(s627.col_1, s627.col_1) AS json_objectagg_547, s627.col_2 AS col_2 FROM cte_840 AS s627 GROUP BY s627.col_2) AS subq GROUP BY RTRIM('sample_21'), subq.col_2, ROUND(subq.col_2); |
|
Version
mysql> select version();
|
+------------------------+
|
| version() |
|
+------------------------+
|
| 12.1.2-MariaDB-ubu2404 | |
+------------------------+
|
1 row in set (0.00 sec) |