after changing FLOOR(pmy83.c3) to FLOOR(FLOOR(pmy83.c3)) in group clause,the col_1's value floating-precision unexpectedly change #262
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)