polardb / polardb/polardbx-sql

after changing FLOOR(pmy83.c3) to FLOOR(FLOOR(pmy83.c3)) in group clause,the col_1's value floating-precision unexpectedly change

Open
#262 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Java
Stars
1.7k
Forks
337
No merged PRs in 30d

Description

description: after changing FLOOR(pmy83.c3) to FLOOR(FLOOR(pmy83.c3)) in group clause,the col_1's value floating-precision unexpectedly change.And the result order unexpectedly change from desc to asc.Additionally, the order should be asc because of ORDER BY pmy83.c1 ASC

mysql> SELECT DISTINCT AVG(hyq21.c3) AS col_1, pmy83.c5 - INTERVAL pmy83.c4 DAY AS col_2, FLOOR(pmy83.c3) AS col_3, pmy83.c1 AS c1 FROM t3 AS pmy83 INNER JOIN t2 AS hyq21 ON 1 = 1 GROUP BY pmy83.c5 - INTERVAL pmy83.c4 DAY, pmy83.c1, FLOOR(pmy83.c3), pmy83.c1, pmy83.c1, pmy83.c1 ORDER BY pmy83.c1 ASC EXCEPT SELECT tvg1.c9 AS col_1, tvg1.c4 AS col_2, tvg1.c8 AS col_3, tvg1.c8 AS col_4 FROM t3 AS tvg1 WHERE ((RIGHT(LTRIM(tvg1.c12), tvg1.c6) = 'sample_83'));
+-------------------+----------------+-------+------+
| col_1             | col_2          | col_3 | c1   |
+-------------------+----------------+-------+------+
| 501.4467000000000 | 20170628062647 |  6313 | 9910 |
| 501.4467000000000 | 20170621193245 |  6313 | 7823 |
| 501.4467000000000 | 20170620013112 |  8704 | 7324 |
| 501.4467000000000 | 20170702101641 |  5597 | 5531 |
| 501.4467000000000 | 20170619015818 |  4133 | 1009 |
+-------------------+----------------+-------+------+
5 rows in set (0.03 sec)

mysql> SELECT DISTINCT AVG(hyq21.c3) AS col_1, pmy83.c5 - INTERVAL pmy83.c4 DAY AS col_2, FLOOR(pmy83.c3) AS col_3, pmy83.c1 AS c1 FROM t3 AS pmy83 INNER JOIN t2 AS hyq21 ON 1 = 1 GROUP BY pmy83.c5 - INTERVAL pmy83.c4 DAY, pmy83.c1, FLOOR(FLOOR(pmy83.c3)), pmy83.c1, pmy83.c1, pmy83.c1, FLOOR(pmy83.c3) ORDER BY pmy83.c1 ASC EXCEPT SELECT tvg1.c9 AS col_1, tvg1.c4 AS col_2, tvg1.c8 AS col_3, tvg1.c8 AS col_4 FROM t3 AS tvg1 WHERE ((RIGHT(LTRIM(tvg1.c12), tvg1.c6) = 'sample_83'));
+-------------------+----------------+-------+------+
| col_1             | col_2          | col_3 | c1   |
+-------------------+----------------+-------+------+
| 501.4466670000000 | 20170619015818 |  4133 | 1009 |
| 501.4466670000000 | 20170702101641 |  5597 | 5531 |
| 501.4466670000000 | 20170620013112 |  8704 | 7324 |
| 501.4466670000000 | 20170621193245 |  6313 | 7823 |
| 501.4466670000000 | 20170628062647 |  6313 | 9910 |
+-------------------+----------------+-------+------+
5 rows in set (0.03 sec)

In mysql:9.4.0,the floating-precision problem has been solved,but the order problem exists

mysql> (SELECT DISTINCT AVG(hyq21.c3) AS col_1, pmy83.c5 - INTERVAL pmy83.c4 DAY AS col_2, FLOOR(pmy83.c3) AS col_3, pmy83.c1 AS c1 FROM t3 AS pmy83 INNER JOIN t2 AS hyq21 ON 1 = 1 GROUP BY pmy83.c5 - INTERVAL pmy83.c4 DAY, pmy83.c1, FLOOR(FLOOR(pmy83.c3)), pmy83.c1, pmy83.c1, pmy83.c1, FLOOR(pmy83.c3) ORDER BY pmy83.c1 ASC) EXCEPT SELECT tvg1.c9 AS col_1, tvg1.c4 AS col_2, tvg1.c8 AS col_3, tvg1.c8 AS col_4 FROM t3 AS tvg1 WHERE ((RIGHT(LTRIM(tvg1.c12), tvg1.c6) = 'sample_83'));
+------------+---------------------+-------+------+
| col_1      | col_2               | col_3 | c1   |
+------------+---------------------+-------+------+
| 501.446667 | 2017-06-19 01:58:18 |  4133 | 1009 |
| 501.446667 | 2017-06-20 01:31:12 |  8704 | 7324 |
| 501.446667 | 2017-06-21 19:32:45 |  6313 | 7823 |
| 501.446667 | 2017-06-28 06:26:47 |  6313 | 9910 |
| 501.446667 | 2017-07-02 10:16:41 |  5597 | 5531 |
+------------+---------------------+-------+------+
5 rows in set (0.00 sec)

mysql> select version();
+-----------+
| version() |
+-----------+
| 9.4.0     |
+-----------+
1 row in set (0.00 sec)

mysql> (SELECT DISTINCT AVG(hyq21.c3) AS col_1, pmy83.c5 - INTERVAL pmy83.c4 DAY AS col_2, FLOOR(pmy83.c3) AS col_3, pmy83.c1 AS c1 FROM t3 AS pmy83 INNER JOIN t2 AS hyq21 ON 1 = 1 GROUP BY pmy83.c5 - INTERVAL pmy83.c4 DAY, pmy83.c1, FLOOR(pmy83.c3), pmy83.c1, pmy83.c1, pmy83.c1 ORDER BY pmy83.c1 ASC) EXCEPT SELECT tvg1.c9 AS col_1, tvg1.c4 AS col_2, tvg1.c8 AS col_3, tvg1.c8 AS col_4 FROM t3 AS tvg1 WHERE ((RIGHT(LTRIM(tvg1.c12), tvg1.c6) = 'sample_83'));
+------------+---------------------+-------+------+
| col_1      | col_2               | col_3 | c1   |
+------------+---------------------+-------+------+
| 501.446667 | 2017-06-28 06:26:47 |  6313 | 9910 |
| 501.446667 | 2017-06-21 19:32:45 |  6313 | 7823 |
| 501.446667 | 2017-06-20 01:31:12 |  8704 | 7324 |
| 501.446667 | 2017-07-02 10:16:41 |  5597 | 5531 |
| 501.446667 | 2017-06-19 01:58:18 |  4133 | 1009 |
+------------+---------------------+-------+------+
5 rows in set (0.00 sec)

How to repeat

DROP DATABASE IF EXISTS test;
CREATE DATABASE IF NOT EXISTS test;
USE test;

CREATE TABLE t2 (
    c1 INT NOT NULL AUTO_INCREMENT,
    c2 INT NOT NULL,
    c3 DECIMAL(10,2) NOT NULL,
    c4 VARCHAR(50) NOT NULL,
    c5 DATE NOT NULL,
    c6 MEDIUMTEXT NULL,
    c7 LONGTEXT NULL,
    c8 MEDIUMBLOB NULL,
    c9 LONGBLOB NULL,
    c10 ENUM('value1','value2','value3') NULL,
    c11 SET('a','b','c','d') NULL,
    c12 BIT(8) NULL,
    c13 DATETIME NULL,
    c14 FLOAT(8,2) NULL,
    c15 DOUBLE(12,4) NULL,
    c16 JSON NULL,
    PRIMARY KEY (c1)
);

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 t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16) VALUES (6226, 5529, 359.57, 'sample_vRhGD', '2025-05-15', 'sample_J42mWK9IGvQq6lnewa1tiQm26472eERoZvnjkLfDKhFkj7rHocNZo0Mqda2Sm78GztKtaCTO8Zij9jRmZ6e7mCnhn3A0atWNfpDonWFkpC3y63Ohej7KJT3RgMcIjWoijnSBtCWeHI9EnayOM5EFd9hddBKkq2DSg6wlCRZNDz4Mc84HgRyxbkhyWHfBlLi55rqwJE4PrW3chEAUv6zgtFaJ3Fv53gNM3dgKlE0iTXvF597ew3xIkn4eVXX3VTl0OeT247l8jkYoymrc0qjTh5IgX12qDiu70yeYfHaQJC0FjkjkJpSlwkQhuI52PDL6STVxVJgscsLxOynHkECNKn5wz5wSIihcQjTr4IddBVeRK9BfVGgBzXoi19nx9O5whQgXBMm6Docktsfnq546ds9IngbMx043', 'sample_jWIS3sgeEmBcQKKFLF0bfj7etj2LLbOvkkBpSmGlEdCNG37mVmAwH5WytIuVsrmMNiJpx3Wtq6xXHkro9MAkftzpbVXpSfuLCj9CUjMB2DvI9DglfAK6GV6lXl9YeKoXeyBqHcKS1Kk0EJru9EEgxRakNM7tlaVfcwnoOQA8oOR4KaXemzXFMcnJUxe6xWsPnctUqW7n2zJpMHrUXWBt8w6kVv3ujspufE4SXzCdyz739kFDhvoeyowVekJH2dZv2IaKDeg6WNbUDdXI0jy3jD61v0IYQsX9eoRpFx3CCeQ1sSEY8asAeHa3K8vZMZdfuVyvmzQcNADk5kmKjZpy8WIM8nW2q6C2NUNJD5BvbIgwJxkNnTQwUkgqslQo1xhoYYxVXG0g1VQUcjzTGc9wYosgHDjxRZFK8iJhRpHub1IVVpbKwB7VPxEPJ5bJsA4lIjaFXeroNTLDTfuBkSCTkSF9nBULj4C4gidX90sGwgL0qsEGGJ8JOMBbfqC45WblwpHcPt0c8l7GIstwjcHU2VNBZfCmcCGCgvJEYm8R1h7xSzSGC88Imvb8fXvwcEY6zVZgx1dSq7xJpfUj45YkEZgHTS5F1Q3ZLKKnL2qtMLlumWnKZ6UlFW9Wp2NpyUxs6jiOVXen5vbz7vH6yw6d7TDGv3MB7isfH1FUmJnbfLCpWm6LYl82V7GLV1DK7LG2TySsFVUGdpSQzWnhV1LVtvQ6jaoEPwqEm3IQbnU1RxtOV2sXlQuxIRubLKucA4Ux0vHK2PtyqjVla6zFqjrGMvdsPjBOjFY3p6zVrrbQoV1CNgAhPXjZMWxa1Zdxl7gR4M2qXsTZA705r9QivMKWQ94xDO8UWCLtUhD04D4RsjA21NbmIkG10iEoiPVwT57sCfRZzYWs6q5JqdGNIQz2WEmwMRrmpYlRwqsKm1cX1OPYrsbpH5M04E1z3DFfEXKZOptqrdaY9A30U4tgTt01lELKhiaDw5RBosSJOhLqySQmRv4xPhh1rOFD1Wg8mScyeE11HDjcWoG28wKL0lQrkDq8j1sOhZjGbT1QloY9H76peumxFoteTHUSiQBKBzFa2AseS61E9EsxXsMBVuSrndjdFbIBon2EMyWPvKemgwe7OvPg8FCzzIdamgTZwyer40WHtELV51bMvlgoUx3fXilEfYIn4fD8tAV2FgPhTDfQ30NSHlZHDSHflp76gyWc8L8uW1GaCOHq1ntaB348hLBgk2oUQRALzRHZyY9YZAsGN79Af', X'5CD8B8CFA620', X'EB89B1E987916914E7AFA9C1886ACAA435DFA0E5B8995AE89389E9B3BFE0AF87C8AF075456', 'value3', 'a', b'11110011', '2025-07-24 01:01:26', 46.80, 70.50, '{"k1": 135, "k2": "mixed_93", "k3": ["tag_90"], "k4": {"k5": "C", "k6": [10, 16], "k7": {"k8": "user_43", "k9": "2025-12-03T14:34:08.823738"}}, "k10": true}');
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16) VALUES (2227, 2579, 707.81, 'sample_X', '2025-06-25', 'sample_kdTfJBN9MKbOhohv89oejHSTsaBwFHqKzilHnp5LLQwCDrv0pOx8WsPPAlP7gk2BiK8wYX8IA7OQrwV3ti5vEjQUKqNtm9jhASAK', 'sample_HKdWWW5bRbRilrNuwm8mzSJSfUvIB7SPuyIj2suHsqZlletZpOG9WHb2ZoMdiAjPnqqT1e7yZdAMnImCb1FbRdQ2ZdpElcKU3NanU2xwIGuYGJx9gxPq6zT7VxvSu4jz9wXWqneRmu3PHzAmFGJSNETNeJi2LmMEh4vwMzozjnNsbANOMqNTjNBfm78BF5lEDu9XgChyzWFEO8GcPB2RDXx6dypbTG8Wp2buP42XUB3JNFMqbPzdo60TGTYVqmRW1bbe6YI73jHboZCqMMp1A0wwDQGofRvqTXQyv3FPya7uR1FWe2zHQgH7LkZ9VEU53Ash1YM6KhMFDz0V7p5f9pCMTScOFgbk4tDoZ3SIZf7nbjsGy4hrJ1KGhCSxt7AFmeqd76LUwTN9Xt7CrTEfm9nVsjtdTgjzaTeI16r5OQ1Q8ZF1rjqNL9Lwh7oUUQeQHIDsVlHHxTME2KtovTJicVUUqaDCMkiOghVJcGw7SC3RwCZ011teMnKBbcKQdsk8wLZCSeVHr1jJTRpZlgs0UqJiZAaI0TbAywPNyd1foEg6L5tZlgN3OFsfU15IjR4KewSQny4r0KyuRoc21sgexF6UTUYBHa7gBGBHwUBOSL8bi2ilUN0mnde62FHBb8AvtyxwRC05zPYSlhVzp9ptdgiu34l2zMRULupcSZWmOQ0Yrn7qc3xZIliUtaBbWkoIfEl3xOGH9P0XmmLcYUwe68ovD3elnWMn5gT4W1tEjY3WFaBQ7RobPdRQgv4TQSbFNTPAqGxQY0oCIbiwFSoyrlXhe9zr9wITMVIgVf3hMlHyCdSlLJzXpR4lJ4l1as7rEL9lKhbucHlWarTGLOm4PMQyOXFH7V2BhaIclsAjBFl3HQocHpQVFNehLRhFnzqNVCKG06QukU1M2VltDHYrItKmh0kgDxoLefBzYJ5VzAESre5cRnAMpwJDXTiee1TijDWZyMX9C37WHTUiwwGC44efwmmgEGnKI362Y1qWMdscj2DtKXAC7BChL18lG3PTiaHw6X3TCPfeIHotuNf1yaNFTPJcoUEvQKc5IeseXmuT5Ps5fsZB46IkPvQRreEdmNUCezNYBtSkQ4Z6fTfF0IOFBXIVxCF5QSvI97coqAnATdZVphtvf2JeIH4VTdTKJ3c9vSBcuCbEroDfRNP0I2ptY4HxIwuPgc1AMg1aTHEfJgPMNzgkyO8iddt17pOZdBnQpPhmt6wnyxkLBxM85coaT1dceTPkJTKXD89GPMjDxyo5sIev8mvYSnRyJE4g0UKONu4peJGcafESqJa5hckvrWjWuAQcaguzKjF1CeTdA5HqdiF1pjh5ytIjBSpyICLdqCz55X9UnLZDFKKoIU9ymkm7gLDWUFv81E7iSYHIRvSuvk5vg4z21YhRIQsmze4eHqzoioLYqA8IvSpCL7TQGZCNqlmrm3tK2ULa8ccG26Rh32vNy3awD1STuLrn6DU2JOcNz3mX8t9S2iJWi91RhFqq8PWBmg542RObkpG7Ua47KcxIUULKYUQ1exL2EuQliH79iZjik6DaDhmmXxZCizi4mCgY2DqYz8XhG3P0kn97CEH4O5n470Ke3dEKx5QR3TQ3KBWLwuyqgrLLPJ3QQTPqjI1H9NP7S1lVZY77R6p0j9OzFtHcECmUzijyK8uq9B8NvYN9KRBAlIP1X2SIH5ya7IH3a6ECSpDHgcrmFV4RjY0QbBzArmLjIjx7kuDrfYBoDSUhmMS1aa7xAGXJ1AVDq5A9bjpNpHGuv2hCF8nCmzH6s3jkSuyK3L6gnU6vg3zmbujeNvn3iRkJSZiLBCwXLLFQQ6IgmY53UqeJk3udXL6FX7Xnwn', X'247ADD8AEAADBC3CE098B9E7ABA95F3A', X'DBBEE886911D62EC9693E995ABE7969CDAB3E2B08FC0B9D8B5', 'value2', 'b,a,d,c', b'10110001', '2025-07-11 03:50:34', 49.25, 80.36, '{"k1": {"k2": 290, "k3": "user_90", "k4": {"k5": 49, "k6": "user42@example.com", "k7": {"k8": "city_39", "k9": "Sample Country"}}}, "k10": "2025-12-03T14:34:08.823738"}');
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16) VALUES (2355, 8871, 217.43, 'sample_Rv0gI4CjvisCF3N0hpzSMjgFBd3QA9kgY', '2024-12-20', 'sample_yeiV178NAu3YSHy8SpJoXk07NWEDhbcA2Mqct1RONz4DpOcl4QPmoLOObGGlR0XIVvyA9GidZgJw7gNndMNVFryNdRZnrzUWwfHoiDUgkTLttYPVgiTJYGaXwVA5mTWuLxxtyE1eVKO6u5aeNzqFMcjbjfUP6ZH4jrUgNzIkmtGgtvV0Cfbg4cfKN003HgnMafJNYGwa8ha1dcfZkUzrQxRLdAwgcmDga3eM4ItGpzlKZhOcjkGSlRnfJV7PWeNyZQ', 'sample_pOBLpXKw7RFxgt5efTddfm4VoXAld4EpOkC1gfflDwHL8Cfaxo474xgKi9cb46Kh6ehFcT3IlwVvcgVFWaSSP7SJd8lXRPVHMlQ49KgJuiuvNHsSb07PyYPTLAgG9OctEP2q3uwDA492Y5TZRmahj10J5glwDRQnwDDIrQmsxYbBL1074jm8WmeHYw8JgcOi49z71XVpW5PAW61Hwsw8cfdxb10jj833IV0FHc89JNEqhujbtMKXVYOtvnnhiISPrsUh2uoCxb9cZCHzHBONqVknnNJINWSrPoIHEm6P3LeG1wcEfqYnIc2vrqjeeYNWG3UQSce6QJh3xF8EjDtMQeDMgdo2dZhxlT6DJfuQEtHEao0vSm37eGW0shzrH54ub2GObAZxnEfDvp89KxcROgY6SymyX3q2ZeLuwwsGFRL8K2rTBYgvaY8JmrbsUDpG7oKr4RwJ2P9ahcCCq2thNl3E0heMsSy102mKI4gx8V', X'1806D19F3CED95A5CA8EC4ADEB87881A6BEF9780E2A2A4E7BC806D4FE1BEBCE6BAB7DF8A11EC84B3C99E3D24ED8FA603', X'27E3A6B7DE81EDB296DAAFEEB08BE3B08AD69B5CDB88E2939C707ED2977F1C01D79F05C89E20E3B8A5484E', 'value1', 'c,a', b'10000111', '2025-02-28 01:10:41', 99.51, 1.50, '[{"k1": 0, "k2": "item_0", "k3": 85.86915892835093}]');
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16) VALUES (6040, 2644, 953.79, 'sample_FmLs', '2025-05-22', 'sample_voMjYlYT1PYWru1rIObmF7dvXCkj3pmrN6mPoBqyYzsa4cy52tYKesQOkWr9qzosQEjx6GT15b0FfCpHIdwczWNizWtqpLKPzKN6u1sZnbgBNdn28YevPpyUaeb3a1MyMbvPuXDCwOsQGJxxBfFKnd8lnlZ5gDdsPFSza2kWkBR5Xl7pdPCDaGcVXSAnOloAlf23vV2JQsVnODTacuIAKrDvhP2pSJ8xXbFiec38jxl483nfC82rtu6jCOhvQiB4fnHp9xE49Sp3aBvjEWDpkVlNwOb7MCdl', 'sample_a0HduYSdEF6lJiDOt3dDhTJxwE2xYUDQtspt176F26rVyPguE1OoStOGKlTz3zDpFmWXAFkvGdC6S1QuMOQUBrNxWKwp0FOxh9Oz2ISoIezizCVN8jo9ZQzMnyIA0txY9pbMZsYHhuqjFGsOrXD6PaGzR7cPNq7G6Lf2ibgalxSIFrxKz6BiVQZyA81pldb9OqMwk66UTgB8NVWous8FqUCCH7tJMtyepXI3WcZbyZjNqWq8al1DSkJFQyZCfjhuWwNU8Lhia9LL1cfDysGVqe9NNfu9IsRzlB0MSlv8zb2UyT2XiXisyCF3CfJWU7XBs5zy5OuNrJX7JQau7TYtAeWnGrgMHCDTVNO5EatuE7si3fFmYmrTUYhXnsxBaUmaMowxjJyHS1fZxd9jcsbDpv6CMjHSPaEpU9adSJ16CudwQ6RS1LiPlPcX7fTdnv8xbaNcfqRtoAfx0fySLyF3Dy2xSoFTFD34weNfwE2GUlhx2ME5jnpBu6b1lX7VfnxghYAlNnN7EEr1EtCDvJ9TrqrfkMJasFplkAEUFfEA4MzAqfBeNp93HDani6si3c6rVpDDrHRrKh3jYOeHM0Jfg9bVf30O1ToxS6l9qPBbyOAXNBl8kiY9yTku7bdiJs6IFpAuWtX3p6yY1eEPT4gfWdG0Ty0UarzN4XkMNrNY5dDh5aOziHV4JJbJd5cfIj8posZnzPOHW6d3snxDRpaifS7dlWvWP6z7ovaoPjmDekyEunkTOGiRjRku3GZ4DTdtJOJRWLe8rJyAiXoUGQAr7n6Yjvb8lVq2GcKiPAtqXIUr30fW8dkBkKhf5I3e1o9N9MeoxjrWgNejxGlNTafJxxnYFYGlapYBbJvfUWkXrZ1TL4dtDJ2STb88J25g3gcJepPcMSC1A9vQ2xJqfYTjHxXaveZtjNegH9heHB9LlPOxCRCpMYxWjXWw81jw9FPtZv1Mx6e1lDWpIdQ6HdJz6iY1NjJ5ey3hEVbQ7oTR67fYMpJYJDTNBYGrK6n17CsawpwZRdBxbFeJSfvQChJjP89Femi6PDPDDfbs72YVe0yJvMWIqEwXTlPhIXEtdL2ycViVqGlANGWPldIpCxSVmJ5Cz1fqLSO6le7klLoJPtjulZZp0GMPbV8UpVHriNYbXHGsBk4Fdhnp9qOy5oAOmw3UmbaiJCbj3tF7AIl4zHweAg1dTbCLb1vXLwyYKF7HqW6uNDTbrZhVmBn2j45CFUaE5hLxu7GKVgz0o6g71MgJhPEqobXItfSP7YHWrK33q8xQW5qkx3DlzIRusigYPytZZOU8nM59yN497VbKB0LFidzbItg4lebCsCNgsvACsFxA7LWumMFaZCB0FZ9DC8KtznQpenasJa1BfuCEEJuuBZuCrY91coKV1SzOnUgYdqNjXYYA0vyIm6rYI87ViEd0PNLvL8Y8EBXHtWKJBIejp3SQAb9nFoZl8xG2ZpsQXq8PSDPMiQYRNewQ68eVPlCrizUD', X'4DE8AFAD1F7F', X'680513D3A6CCA3C59DCFA4CB95DFA8E7BFB0CE8FECBBB965E3A78341', 'value2', 'c', b'00001110', '2024-12-11 14:46:51', 16.60, 19.66, '{"k1": {"k2": 503, "k3": "user_23", "k4": {"k5": 35, "k6": "user2@example.com", "k7": {"k8": "city_93", "k9": "Sample Country"}}}, "k10": "2025-12-03T14:34:08.823738"}');
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16) VALUES (6553, 5529, 214.68, 'sample_tvc5vnPE5tTtF', '2025-08-27', 'sample_mXPQsQUqtx5KpqsjXIsOqkGqLbXZc8od2SmKC0ehpsQXKZQSQuwkepA6JuwO6vQCC6aeBmPalfOalAsNegv4TwG8gzSgpFYj3qCOu8NYXBejGuAwAxKq5iZjjNpbNn5LzEdemhZg7OrCg', 'sample_GAtrkke2YnktbYPEXyVbvaUm43qz5pqQdCshDBrpQCkQNtU4TOwEee78AMB7OhRPGTGHj4LK5F7HUsqtTjaJChR280gzaVbRHHQtUlpLn4AWV3b3LaSPHVzKvSMI4weZHduvv3RV44QKKXDLMY3FM9aNQcJeHJr93A27nTRLtljs2ljH3gSltsJwSBmLe1W1FjWe1uDNK1GR5pBDLZqBlqDn23Pg3Y2QxwMdyoaoNafsl54TDIFZRyA9U2YKIWSbCqnij32qiTaQ5cCjLySMp8D29AmBrcFVYMmByXWorCrDVzuaCd7ODdCF7dnpkls7WOq2WT9D5R2YMQQASQSII4y0KWnvQLaNPecA6WjfJLpkSkcODSy1o5319wg5riaRRwlctkOOEjkC6QpPFmRCYkn7YdSOCPdjmUTcgEUgkaUWLkia0SFgFafEBvDAzQ9dZS0UIMjR7P2mfDY1atsEj84jD8dD3RGlM014padQt5wfYGsFTGmfNA2nSNb8tEhwJ6L47P5AVp0hTDiLJRTENVaVizUhKsQ8zsVfIz32c5bUzu1IuNoQSdds8Q5uGFspthgBTTBdFGDhvyxpYb76P8V8BDQu7vp1IKSh1jEgPzi2wceyUY4CXRyyVCPI5DddsD8HkJpEdX95YptT4oHihHcwvdmc125TyBjnzAcQbs3uYPN8wksSaSqtfeX0IEsedUfIaO6B4dBbpJaM067XB8d10cmvRu03YxKqckx6tdLUjIN3bFeTixlVYdtxoWl0Y0DWTi6xzeqtJkwk1YKsbdGOEmpoQTu8MB2CPbzSr025GaAXTYaKHAhai5a4WqwVkLPWlITuWoYLQARjbiDpZdL4DNNkzEOZ8rdidXwIHM2DQquDIXvkvVvKE1A0oJrqjrjwo8rFICe4s3HSTDmbuZbIrIWosRgPe8arOkhsD3Y0X7fN6sbDhMCxkYCMjMEIQzWVWfUFoFzcLjnaVj00lmpvvUGeoNoTlb4f9VYsHVbcxLWZLXOvAW4HZpo6IW2PKi6fHd3ITY2wDk9cCqA1Er9YKX3VoH905nJND1SSf1rdTn0U6RR3zB3eo3ZydJLEF0VI1dpUD4CEGGz4tyWHCnWehNitj4lURPHZUdM97k7i1zPd8VmZE5ZfLJ7AoVAY7crfkOdfn1Lxou12uxcN2lDFSW5TwoYoeoMP2B9wsTeF0307XWxlBnHtBzKTIVQj2VcmeQkqStUwbS813S7homs66JYieSb3jujyKZZYQR1mh17ov1CDyKRpplDlRAyM4Y3Z3n05', X'7676E2B298013F4B1DEC8FA96BC3B9E4B1BDEC86ADE3ACA2CF86C99A22D682DF8EC8A7C28101', X'613FE6A286E3929817C797094DEA92877BE2B8894F', 'value1', 'c,a,b', b'01001101', '2025-10-07 03:01:31', 38.22, 27.52, '{"k1": {"k2": 964, "k3": "user_64", "k4": {"k5": 50, "k6": "user14@example.com", "k7": {"k8": "city_49", "k9": "Sample Country"}}}, "k10": "2025-12-03T14:34:08.823738"}');
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16) VALUES (5597, 918, 555.40, 'sample_hpjP9YrOoncruC1d', '2025-07-22', 'sample_l9qDVd4ZJ5DXBqjp740dzs7njB1LUPkxQfVq7YnPEaHt6O2bg36bG80QHErauOh6xSC0jKWHNy67w8M3AVv6x8z16ARgxg48RnUm4jxve4Hg4MGdH9WwbTrPVQHtW0djcGjZOJoFpQ21QwymasyoYlSqRpUqjLzwqmCSUhhDhP2Caz3ENVVXM6PGZCAcvud6XYNk0bF3GiWvTi9WkNCevNu8CoUyAnOaPzK9531LPasYriSrDQ3eYz9VonVSz92HYBOaxOXsw3rAtgELNO0ebh4KcBIRpJWAF3RGlnlpeNvgDgoEgXKj4wDtn8lasZld1zlYES9T57qKaRoJrZwEI9ovbqCpQwSvMImDRChAO3fhoh9GufzdSwvveFd4OiGgsQbJ3l30omTTTJOdbpDG5Pcg5chIGByvtU50VNVogaQjdyh26Zap8cmL0WnkR19UPLiR0WEE1hvzvnDG', 'sample_vKqQaBU5B21C8J0gKUckLlphLusEQTm3FIU0tgSnw13V6nZ9jzMXIbU8JpGQVHxMxU77IS1ZqPdlXpo3CJEpSnLSwfyUgAVRt1CAt8NV5JdQaSlJS38rJa6PRK5Q4uSp8hLZHvyHku1BAKNThmk8UUrjQKTCNzPX5GnbeMACgdpm3x2D52qi7v2az8OcvDhu4AQ1RYNuhwBEaEeRzsDD68Vv5Ys1GdYvzmhX7rqckq5zfXdwSZmCFVc9AuKQLzLJt76VrFt0V7YLjUjq125JxhQEVOn3PK7WExJVcBG7rODMCdVXdxpl2yYTY0FadZLlGzQGMQ7v9CufkWqjay0rmb629xRjSDPWBghecv0YonDQj0PDfUM5qQpHnyvLIPWIGKgkzfF3EmMdhL1ykMQnUWQJNb2EpcGrFenIjKcUC4uT6k38BW6BblCvKbMQpqSh2EKhvbLojpazjU4TGqNTn2NVRzpEVtxWOZPvhIFbIIaBrH8gyiVGHiJDspaBV5zedOmLv7dIDYr6XUh77JrGva4fSiZ8osmcy9DoD3ByuKJdF4t5coBmOzHcnmrqxml8ne3S3q6oM3jqbynlisVdpOsKtrceFElo2zpNv8p0LYkLxOSLaLis8ybsfG8Y7gke4SKprpUfG9EpWVMSWwr5rgnsWoOGbd9CPshCxJi5CjZGLuOQGZLYjlC9aLrWck1NQ1mXGUCmuIJJqCr20lJndKNim6v1YXfOOpnRxLKiAVsW96thyCAK4OOjSPMVIebzXp1PLq2l2x5tyjxrNf0qfjfMEpyB9rC16xFtOLTAQnSfT7RpLblhY9hJoy1XOoi474BMBH73Vv6ahDSAQhW3GgWI9uXQov1KZOgbmd8xtdcjXxj22ZENgFqhd43ptM0aQMgSHULLFDvnkLgzqk55cVH1it9xgruHydymAmk77KCc6fxXPzlafiWzbO9r0cEPsmJMyNkjtUrmfPRBb8Gquu9Obw1ahO9hXOcSNIkVrnUR6TGZCgLTnz6AvI1q34xUvqpm96Z2tILSuZv4lMP7zVkf6AeaM3Q1sIWTtINEq9FZKRk9o5Y408JctRJOd4zmeKK3CHpYFCqvhYCSj66AxJatPKAErdodQtraJvGXh2mtzsH1JGbWaBIbmhQkHq8F4IlHJCDmihhFLVwYTSapdOGwsmFJIyuYue1JIcP05S030mgqdo8LjnMkVBVmBmrCzjixuB4ajMUMyHN7Ww2dIti5OTUAPsN9vkK4prFFQrRV3kf7L7GpSdxTKatkRob0S8g3YpqzLlQg5fgdwEh3n7i69PRbv5grhAsESxrurKUKWqsVCItpRXvq3k2ow4Qq6SdD04p8Ngbl6WDwDqNC8uko8sgBWkmsFFjMufd0biF5EfmpcmyytGWHe3CxWcAM5EWD3ywq2tHwS5agxEUW9q5hYvE0yBowz3IWBWlLIvJMnSdwtrwdVrDB9iXLfLVJ1oMmmovnHTKYMqYT6cLpeBq6jc2OpmIVITRQa6MIlYWzUEEih1fTiT6yUbIaeEs5WbSBmyAxKx1QZJo74PjjULqiP6aD3d99ukQKitARsQXFQTDKz5gBo2BgIThliHlAMWazzMjKH9uSPOHu6l3Nb7RyPubLBtAEA2b0pPuLD6q7IGZH8dNM7A1qaVtetQMHClRztNCH9NpfWQAGBwutQGY2qsgOUQvVERhmwTbuf4934Y3Kh3CKroxCXhp0GwvDLXhTV6SMDPYJfDo3hEFInm9Flpnb8MZYCbabPlBhuAR9EOOyUXpBy3LIZUraDjRqdZuufjvpryIbBnoO37uTi1diUBTuPIzvLDJcq2tnhpLBs467vlUfWJt18HLd0y5NQSZkjSQEim7YuK6Mnxr6uCTu4ONgGXzBOj', X'E5AC860BE294A0E0ADB9C6B8E98EB414613EC6B2EAB6A5E0998D6A42D0B3527FD29EE89A8CEC838ECFA8EC85A72E0863D29E', X'DD8910DDB3CBA0C5ABE6A5B5EFAC98EEBB9C4A', 'value2', 'c,a,b,d', b'10110111', '2025-05-13 04:36:52', 44.95, 55.66, '{"k1": 319, "k2": "sample_44", "k3": 379.74173005813475, "k4": true}');

INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (1009, 8871, 4133, 2022, '2023-01-01 01:58:18', 76, 34, 51, 19, 'sample_pDek9jnwphEgfzuklg8OOzGZR9uSloHVq9U7AgaRKgPjN0XI9e7cXabbIdcQ3R6kC94kqfDpBRumDUzMfg5HJAr', ST_GeomFromText('POINT(-59.066767 132.07659)'), 'sample_FXwsfFfXtlkCbB0CmCxYydm55btQoFSsrYSs1JXyCtZhdoFv0Go4cb2foZdoGBxtqGCrcgC72lh9LoXSbc1n4Mm72kc1xFVRyNfrH4pdp8wxLqbZYobWoGyNzCUb3C9McjAfurENvJJQO1DiTKbIs8Bfnpryb', X'E988971932207F', 'z,y', NULL);
INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (7823, 9505, 6313, 2020, '2023-01-01 19:32:45', 81, 47, 6, 40, 'sample_6r8Lj4U1pQKpGZK9I2JadW8YEtpoygL8U6AXVhCQPeOmDYjomJLNH1NXrR5qnEySiZuZ54T7ubGXU6tFCtnr2mVZgc65eNYY4rEHjqY8t2QKOCMjdNBTCI9TnDEhaesyUZnLzbYvUnhVETUDebB9nXQpuBtwsnypwSkGZSdniKIK9Q2gMgVTe030jE7D1bG78HibeBEmXp8kwYse8AqckbCJuQkujjnqU4XbXpygyRfBcQCiYpOk7gIkIDxPFnTBf2CjPRNcPzPhLQGMxSc5T3vdDqslpPfjRdJL49NYqKFfSYIjKb8WqAfrhSn4Y5DCOLWrDUxtCdQqm0PgkS8hl9CKVoLfd17Y26rO2XJ0DqWE59JYhKiMf5cJem2R2qrJ4JQYRcDSBUPd4fxyygJ8SW2NQR0UQthwjLG17S24u3E9w151ws34MygDcFPON8ord1JnSLvIxvvXrd7INVuh6kwY4PHumiIDV9s1L5IyF3Z3syM34WWeakE1lVnHLRFOG2kWEpzVmp11YQwUa2yG5p7fd94g76OgO85iF9c5E5ziuEDa9gZ18eSdL3bnfLyXDAI1NQDTALfG89ZommZlLNsxlGBUQ8vuxuqmmU7oT2dzHhNuTkDBXZCMp6ThbeA1mHSOpachiaJgeZeCIHLFjlaM8lOtozn0FjtSShvcvKlTDJlis13WdnDLfpRD9FrdQkShem6gLrHbWjnOzWPdLBUebeipaAHud3kY5XSG9F9COC93cWCEBD4b9X8kS88J5rm80rj2SOrL7kv4cifZFZFEhBXLDoarr7xCcW26OXremXTMP30MStuC6a0uaIiuv883WPFfRjvmH4Uf64dciNweua7xyFqugJNs07wG0n2F1ktM1sttjiI3rBM0ZNx3d9G1IxmHvkF69BDGMCa8Eq9vFzXe5TryNkRgB0QkmLAZiBs1DH1Hg4H6vCsd5SH6LGhnh6XKO4IEhS8MB3JlwoJvrTNv9h2Cts3gg736uPeuwjxBxKdvEVNp8osJRPacoAN6VpwoeMJm4NN1s0glyL1NYuPlMxvMHotlZpN7PDq5QB2jloTADDCPLsDc8bzoKL3XQlF0BkTH8lyjEShodYM5G4ZvgOwfte3tPVfzhfifpBP203MRllSXCWQEHsdiwvPPNm9vZkNaAlEeXR7BbPQT8ddChLn8Y1qt97B7EnakFZYZ8vGqOpWEyNrpWu7k9uuCv19rX3hHtyJwEpXZmXzGhHjVi04j8GIn5al7NE25Z1kYN4RSmuAAI9MyvyxcIJ3IAzKXgYkPTgZvo1tUFkA0CoNHkdzOag2B4w3atuK6TkmMICEwbrWk8M9ok2bUcZf1pvoI4SNZYhm8Ldfxab34iXlwHwt2dGq831vLwTXqdogEH71PxFnP80gvemcEE4BbPnnTgXjyejjCqZeuwptbUqNSc4fozQA9q2CB7A8o7sNskHN5gjK6KCfx0dfqMqlEEwaAX9v4j8ywhMhEVXzShc3swsXzTrXixNTiK4mJVidCLRIDgLX1MoQ3PJ0rGPMMzn6K4WwH6sTbmA8NklSyhxNvHJ1qDqxqMpSL4Wq2r624QRHoskTZI5t59TN1NMdZxHvDbM6clBDZiCNjAwX9', ST_GeomFromText('POINT(75.983485 -102.163354)'), 'sample_ZfgkhEi0Z8GDwwCO2taZxqDCKd4OvbceqTI7KmBL3ti3kUjnqONU84AB74dZo9lK8CIkv9cBSndDqLqzA0G5ywpZRMkcRw72UMYbC1gzA9eDxi8A8X800pAQ5s5skOirxMoaonji5GaGpdl', X'59EAAE8A00EF8582CC84E6B49B7FD9BC20C9AAE296A046E388B05CEAB8B3D09C12CD8D2F3AE48280D2A3E595A04D', 'x,y,z', NULL);
INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (9910, 3663, 6313, 2013, '2023-01-01 06:26:47', 61, 85, 18, 21, 'sample_KlLUutrBAMIcTYBMFxukjyNIuQFS4SmY9EMolOHEenaQo7s8CUr4J8corqw0n7qbsn2kDf5MUyEe8MdHGJHaRuywTOwe8KH4mIrK3sLSaGmkcSiTtXk4wa3Plnw9ZHpDezE2DNyWjDOt1fCBDOsrp8PBm189cLJ6XF4b9vADcEtuGqhNzEK7yGtdFBQJFoJUW0tcm2h0ldtbEuAsTawy8e7t8s9ygXugJcliCeRdQzrL9DyM0VZTrdsT4Vbr8BP9yWqCGa1nQsnhdlTlgLGDOG9PtK6bHtTg3Ti5oQvfBqGhCkxXulHVfjGG65xZAJrIFwjH4kSgbOENloZZmDxPhlf4EjSUwPYKQQyFNhscA7HDMZY8xe6bi7dAZpxFF8fbTMDMCDb6Uw4OTWREwsS1Sc1ZiBpWm4INioKh80vrwryRDVDlKzFMxRzdqRHRbyKPnXbofXBpmQ2StdnN0O7Fo79594gmewPhezZRvKCD4LBn4zL9cdgdFAy4geAyr1m20T6e80xHIl9QwgjSMyUP9V6QGLUYg87IpuvFI9gRf9882kwuSXLYi1JFacvKMMg8dZFlCoVjm2U6JTc7mkKkAeKCpayjavF8avwRTIpMrPBtK18xoh6wuEz924eTdTHIukEAyMe3D2Yjwmu1Svw3oucq7bTxyaQmy4dggWKz2AizCoq33qVSwGcIfiZgmospT4nKFEwfhX5BWyXxmW8KxxO1WzFiaWrhWGdis76FPAm2G4hfdSakNRsT71lzeEXzIHlrEzZ59bjELU5huaRVX3AqETzi4SAjd37FUGgMHA4jr93TqOfX7j7vGcFOGwrW0uv4J8Q6uiQA2LR4YpNZYZAc7jRqVJRVylF5c8FTNcWyArfVkkjp5gi4VhbZ8h9DoVTnlNrnnKEFsQMYFYLe8TMWmsAMcmBPqoq3chhn27hOOKOojJiz1CrrfpfOxVUBNcO30Ni7wJq1LD0aHxyVB59nHxIinRvKq8oRNOsZRUmfsBht55t0J1NdnxFofqUM43BCuXaXm3xOiA1ALe3kVw4oxgeCW5vohDGtdMJ1UTeqs2PrCSSc28CZdHoic3xAXxNTcKEbfR0uGc6xCdr1LzSL102S38jeuqEhOPqHVPSwNg5jO3ie9EM4g8PaktxJITMWiOMRISWoFvrDiohoZlyTpGM3rCrZ9PdzWa9Pmp0HjpWS2Ii7R8QbXMx2OiJ6Vf9JqByuOIPGBhnshKl2P1O9j7IdKFvdni5vcruMVxlKPnQlVVbtoB1bp7fWLH0opaM19UKPAf0L8tndhCcrxrPipPBJuJmfHhnSZhHvNpHgbqHb4c2pp7HRMYJXSHVwjJviNct5izxojrOTZiWIkiZlQmdUO5fGO3azYI52EKU2fjlt8VEqJodMU1B8iR20kRrifmmac78KlG4fMVNnbkxMoYTAzVvajgP8vHzbnCigkNSI8e2IumFRUnX8njTVe8ndim8HyhOJ4Jc2Tsn5MYiHEGmEop4bkSSEIfk0A7QE8Eoi1Pvzuya6zZjCdezlqXkdPLkubFtTbW0iqnDsS5Ivc70eGt7sylABOF5Nq47XAi38To2BFDrkJYHNlh7o0PxtiSv63xFPCMVb4mdd0soEDYTfiAAS619zjmyDpuDVoSMKtrEAeyfcVljYhOKrhgGVW5YXL2tFFUsmcsXRRw6iWQYWL3T3trPxC8hgfYb4Kaxs1TRegVZhCcuHaW5LMu19Pz96K8KNwrUHgXUt4turLbq0qOgItntJNj9hFVkOj0sxokoBHX9QTBMwHNVKfrUGzY54', ST_GeomFromText('POINT(-39.294753 164.620988)'), 'sample_n2VAfonB6c4aDdS8OaXICQpNAYYkzJuV8dSxmASR', X'DCAF6B3DEBA1AFE2A0B9C0AD0CE7ABA17DCC93D3BCEB8BAC3CD18FC3A6', 'x,y', NULL);
INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (5531, 2579, 5597, 2009, '2023-01-01 10:16:41', 44, 87, 70, 23, 'sample_nG0xP18GNRGwL5UnVveqQ74potYSs4w0ikw7bptTXZ1TyqqGytFEBgRrGVLKB00yWHYciZE8BZMJthoKS00DKMsb58tCpor91YHOpykKbbcafFaWIaomunk1YJeuCjQi65YVhAdlU9n2a9H4vhUFRblJ7NYoGm7NuIZPW2tJlJyhzLY5hQcfImlwre61Cz335trQtXXlTdvBFCixgBQ1SOS5j15Pz935YvvfbL8PJldG67Haaz7PkMCA7QaAJJyAC6gRrZmKS1UyGctK6dYiyPFEJEQW0QDmac2VYZTwQM7nfuXUaPGeuKCGmWaGZb9l7uhE2KZ4fjV11Ir1QVd7hto6C0IQ0zfXOFLm3h7VkdMsvB9AnmDFzJMFOXSmRrD11u7tYmWcTNvx1mecI4YyhITbftx69EOpy7wTH9stzuRO2iRFsXQLbrfpkyidqI4CjAfOhe8BuA6nl2TtG8Hh5oBdSm1Z2MDoAlghiNgZqOf0PW4wqoeAscitW2tVCczwn2JhzQyORvvCgmhXDT0C0WULsXN', ST_GeomFromText('POINT(-6.310076 111.79888)'), 'sample_c', X'E5BAA9DA9AEAA79F1C46D4A632CFBAD280D5BEC88C05E0BD8FE29AA5D7A0DE8F7805C6BFCCADE3B3BCEE8395C1A66B', 'z,y', NULL);
INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (7324, 2965, 8704, 2021, '2023-01-01 01:31:12', 20, 27, 73, 23, 'sample_h0e7trxD5sHJpg0ikf8zBpr2buCYaVbVNeMJmvUFYgqGv8FnlrB4rCqCM3e6ajJO0fwsnoidpM0mXguoGwzNwCLG0HZr8pl50AhNsc3HUkLl6Ehoa4eYI16tFyyi2Jf1h8lpCf3k7u7VWXEiEEwAxtjZpiwpbmEtAyDmdN7xy2iYhk1qxjzBnyGHDT5z6Drmxw7dhR4BYLns1hAKtdM99te6lNLwGWfMowQKm8i77ERaFZzzlgjfoHTGSwDDVuxff3U4Ok0I3AtFFAJZIDgMi8IS3AxGW9V8wWobO8j1YeiCSRo1KMOvknXTaphRGujiqKVdkRojN8zbJbmzo6OX6msNw5Skc1hUJRrKJ5WbcoD3fKu6AodPeCoyOfime3AshKoK4WcRU72Ne3Jm2CA6c7BgmJyRZRh53RXUvbp62aYBcuLYeqhgAh2wrhvtRMjBbXripxeMEcODrWwyCe1Vd5K7fZVkx55dHuNAAmQy10LLZ8dR67Ol8upnODJzxNxi1OV8YmsOpoBTVwgsDY4M7umNmYCOX7Sata2Gqy0ZrDq1bqZgkY9X9en3v7H1Aup47SSKqF9in2XjTzebIHnZPSzOvR75boJQCFSVUQex9IMBFfSQagiRorRfeomsLfVxjF0slTjzb6ydYWXpGmlkNcosR5dWYNYRsApI9lThIlp5HPI2CoEBNPiLQNSJ24JRjjxJUhntD8lDL4ImAGlUE3mBORb8CJwdleh5aTJ45oLHuDF7xRSR2ZW673JVOa8H1IRLQMLw6hNTahkoMKUTt8bKC67CocvnKUuVXXDB1elM6eALHcECGffLOO2a0WJdpeZlAVoUHwV7GC6mDC8v36l9JJZO3W3otmO8oILacsx4PzxWoe2y608DXKDIgt5cA2M5RZHFyrJRQxkRB0lMkEO3rFuEullHe28V9Nr6yeADJkRgk8WkpeBsWY9v9sLOEPNySbHd5A9i0AsnIHfNOOKQxS0cEBoGUHdxJVfgPFHDdvRublu40VUOOEfYP5gvkXDw8tu3g1FQBPysDhLhMuz2cnkC2Uzv46aRW3IrXzvhuiqkHb74AgFOAkFxwjLvCKv2OfBtOQFnnZ0UDZBFmy3Cbtt1UeevVwF4b20JNx8QttE6oQwpPybUCf3PLfbZ1V1xVDiaZ3yfg4YLRJdaVUUDlrvpmQWSkOE3GRjRVl96dv3Fn6hkulgeBALxZJY76gHUnlHkGVwg6kgYPhD1fbbQlvwgiLki1NIeHO1ouH9qtOywCS2ZGz4A4eHG6sZO3ptctCTuSa1u7wFn52Cwe41DRTmo4ab0ITRxrnhAqgAc6H3mStKmDKbCjlHmDX4979KFwr1OHFOe6UggxUKGGhP6p2x0J2kdjxBUdpudxOlwxCzKPHrRT0XZH1D1voKEYbl7btIrRyJW6OP7OE33eHAE0YVty7uZfONrbhPIG81DRuGT2ObGL9f18d8TmiW1u3sMZPu3mM2k7QjllCFZX9FLhbGD8dPi7H9inpcEPsTr0P1wFhOMxM6F7MQotmPTTDkDS4ezeW2cySXyeCBpKXQvKczryQvhmSsx8Uy4P6pnkDSfgM9h2P5gHBMHjTgyx7eabsY6DGxbo9NweR5uvOcDRpOxdGUE2U7Tv0O4qSi6iKmv1tTblT2ieWpfFvVCJkb3UeioGRW7hmcJZkxCAZqF8yGZG8s1', ST_GeomFromText('POINT(-77.667948 16.906591)'), 'sample_LHZAINWPmJaOuFCvV0emk6rpt5Fy1TfzW5icXFstwqOybLD2hutatTm6j2MHwag1EVotupEHPKW', X'ECAA810C2130C3B3E3B299CE8C', 'z,x', NULL);


SELECT DISTINCT AVG(hyq21.c3) AS col_1, pmy83.c5 - INTERVAL pmy83.c4 DAY AS col_2, FLOOR(pmy83.c3) AS col_3, pmy83.c1 AS c1 FROM t3 AS pmy83 INNER JOIN t2 AS hyq21 ON 1 = 1 GROUP BY pmy83.c5 - INTERVAL pmy83.c4 DAY, pmy83.c1, FLOOR(pmy83.c3), pmy83.c1, pmy83.c1, pmy83.c1 ORDER BY pmy83.c1 ASC EXCEPT SELECT tvg1.c9 AS col_1, tvg1.c4 AS col_2, tvg1.c8 AS col_3, tvg1.c8 AS col_4 FROM t3 AS tvg1 WHERE ((RIGHT(LTRIM(tvg1.c12), tvg1.c6) = 'sample_83'));
SELECT DISTINCT AVG(hyq21.c3) AS col_1, pmy83.c5 - INTERVAL pmy83.c4 DAY AS col_2, FLOOR(pmy83.c3) AS col_3, pmy83.c1 AS c1 FROM t3 AS pmy83 INNER JOIN t2 AS hyq21 ON 1 = 1 GROUP BY pmy83.c5 - INTERVAL pmy83.c4 DAY, pmy83.c1, FLOOR(FLOOR(pmy83.c3)), pmy83.c1, pmy83.c1, pmy83.c1, FLOOR(pmy83.c3) ORDER BY pmy83.c1 ASC EXCEPT SELECT tvg1.c9 AS col_1, tvg1.c4 AS col_2, tvg1.c8 AS col_3, tvg1.c8 AS col_4 FROM t3 AS tvg1 WHERE ((RIGHT(LTRIM(tvg1.c12), tvg1.c6) = 'sample_83'));

Version

mysql> select @@version;
+-------------------------+
| @@version               |
+-------------------------+
| 8.0.32-X-Cluster-8.4.19 |
+-------------------------+
1 row in set (0.01 sec)

mysql> select polardb_version();
+---------+--------------+---------------------+
| TYPE    | VERSION      | RELEASE_DATE        |
+---------+--------------+---------------------+
| Product | PolarDB V2.0 | Distributed Edition |
| CN      | 2.4.0.5.4.19 | SNAPSHOT            |
| DN      | 2.4.0.8.4.19 | 20240430            |
| GMS     | 2.4.0.8.4.19 | 20240430            |
+---------+--------------+---------------------+
4 rows in set (0.01 sec)

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by running the two SQL reproductions from the issue on PolarDB-X and MySQL 9.4.0, comparing the results with and without the nested FLOOR expression. Trace the query planner or execution path responsible for GROUP BY, DISTINCT, and ORDER BY handling. Done means the reported precision remains stable and ORDER BY pmy83.c1 ASC produces ascending results.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.