Description:
after changing MAX(ynt23.c9) to MIN(ynt.c9),the col_3's value unexpectedly become greater.
Additionnally,ynt23.c9's type is longblob
mysql> WITH cte_565 AS (SELECT ynt23.c12 AS col_1, MAX(ynt23.c9) AS col_3 FROM t2 AS ynt23 GROUP BY ynt23.c12) SELECT DISTINCT cte.col_1 AS col_1, cte.col_3 AS col_3 FROM cte_565 AS cte WHERE cte.col_1 = 21 GROUP BY cte.col_3, cte.col_1 ORDER BY cte.col_3 DESC;
+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| col_1 | col_3 |
+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 0x15 | 0xECAF910DE092A857CB9629EC949A3BD886D5AA0FEDA9B01AE182A9C59E79CC9ADD83C2AAEA8F90720FCBA3D3A2D3BA2CEBA1AF5508D9ABD2BFE997A551E0A98AECB1B161E8B49164C9914004EFA4B0D8A2EE9593C7AF34415E4147D4AFDFBF4FD4A2DF8DD098C082CAAAD484EF88A2ED8DBAC09BEAAD8F21CA926CCBA17AE49DA1E7A19BE79C9862E4BD87E59989E4B9AAE18EA1EF8094E7B1BB070C |
+--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)
mysql> WITH cte_565 AS (SELECT ynt23.c12 AS col_1, MIN(ynt23.c9) AS col_3 FROM t2 AS ynt23 GROUP BY ynt23.c12) SELECT DISTINCT cte.col_1 AS col_1, cte.col_3 AS col_3 FROM cte_565 AS cte WHERE cte.col_1 = 21 GROUP BY cte.col_3, cte.col_1 ORDER BY cte.col_3 DESC;
+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| col_1 | col_3 |
+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 0x15 | 0xDEB7D592CB9AEA80846DC69DECB6B7E59395C68EE581893757C9B1DFA1EFAE98DAB1D2B1DC9F236DD9B7EC9781EAA98AEA92B2DEA7EF9395C089DB8FEE98B0E6B191C280E5809DE8B9A6DCA6D6A0536EC8B0E4BC8065ED91AB13D780E59D86E69C9FEDA69131CCBFD789C7B90F4FEBA4997A7FD58D31E39FBFC6B8E393A2CA9DE7B895E09ABCE891ACCDABEFBCA5C384ECAE99C186DE8DE58E8B0AEDA0A40DD496E29D9CCEB56F0EE79999EB90A0DEAECFA167D294C7A5EC94B6D3A4D7A3E7B2B1CA8AEE829AD391E291B50CE38DA7C987CB8FD5A8173658E6BA992FE6BFAAED9C870375D5BBDB83D1BED1B7EE879AC6A4C99C04EDBAAEE69A95D6895654CCB21E16E88C94E8A59CD2873CE9A88DEB8DBBE091A351D4AC74E98D977F2BE6B885D5A1EDB0AFCBA4D7AAE3B3AFE5BB9A4BCFB2EFB1A9EB8E83EFB69EEE81A66B |
+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
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,
PRIMARY KEY (c1)
);
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (1214, 9368, 934.98, 'sample_ggm', '2025-06-11', 'sample_5BohNIDnG4rqmuIjGd861gc1no5JGRKdsKrPb1bclM8UX75sWpDtsihpx77IDJsTi5Vytttbpvql2IoKWGkr2nicFDIbj4wiwkk5MdJ5CgiKDBHNvtHJDddw9OnYnt5WnFfHerl8HBuOiLfcOZmILs5xBJEeMsBRbvUlVWRgpAbdijBckmbcKcCb2WQAjSN1ehLqj2lxZUni9i4ANptTCk3fS0DfliKdFt79UfifFwNM5WcIPgD3uYw4zDwGYS3nK7KR9iBsJthwarFGvPxKTXVnuEzWCe7z69Znrf0tLZbVPVG8b3pEfSezM8bpFmd6aMob7OUJCERMRkp3360lbwrIG0ncz04LxrEemua4Ne6zp5vr9gGi2HSFstUc1Mm7cmVO1YVThSKgxllF9Fp0EnixyL2eCMlJhjNMfuvurjBb1LW4LB3aoKYF9BESUcXVtNEEpOEMNRtvHsUX6ioNcLeAu0TRc2rEDmf3eg9hamlKEQsGgINCNbc3dyR2al6GFdsf1qnNMbPCr0ko6PzvgErbqb8ptFJRRu4RAkSUspOXOBi7QsxkwS1hTBjtRrZiFLE9RVqBhJDJzMHYy0bGrSDcB0G6bFPqMXaTwhqcOAwhRkIItgR', X'1CE48ABBE1A8A5EFBA81E79083E0B9A1D7B0E3868DD9ACEF95AAE3849221E88582EBABB668CB867ADDB1DE8145D5A5D097E992BD53E68186EE80AFC896C783', 'value3', 'c', b'10100010', '2025-04-16 23:57:06', 21.73, 37.73);
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (577, 4847, 972.81, 'sample_PkNlMG5xXiJEQBotwJddZgieb2TF4', '2025-03-07', 'sample_McuYtKzyYbUMaqEgD05XiPRE9xrYtFNByPUAeUZfQ7NWb9x5toioxqP1EuggbveEMXJ4GY2YotlAvBd2vzAzq54EAIlQ5FIH1hsK8nzgkH9FINKYcNEnKN0koKXoO9jNOvPEe7EO8d3aJVBwnilObKiB6qh53qSd7F1lLbfczineOzKSHg2AlUD6wB9BfVSPC6GmtGXRVNjVaqyGZyUK1VEPH5f3aPK', X'E58FA9CE8FD997E896BE0FE38187E0BC8CEFB484C29FDA8AE9B98A30CA96ED8DAECBA40237E4A2A3D682E2BCBBC58458E88D93E29F84D7906519CAB4D683EEAE9FE184B0310FD0A1E787A9E3A994C287E2AB89DE8DE592ADD698E6818CC3BBEB988A7319D590DEA0D5980D1764CA9EE88BA51A2BE1AEAF76E8B9ACE39D96D2ABEB8991E7AB9237DCBD6FE9B2A3E9A894D7ADEFAFAC1B44E59A8BE5B790320CDEAC412BEBB788E0BC8CCFB0EFBC9EC6B2CD8274CABFECB090E7B2BADCB9EF93B503EA82A0CDA7ECB79D04CF9979DBBBDEA8DB99E7AF8645C38B49DFAE45CE8DD1B7DCBE6F527EE18D95D398E384A702E892B47FC39967E0B8A9C6BAD9A3EDB988CDAF09EBBEA4333EE58D9760D49A2EECADB5DEB00A3F1B1DDCAFC5B4E2ACA00CD2B379D283D7A8CDBBE59C90E0968C33EFB9A4EEAD8C40DBACCDBAD097E1B793D1AD2CDB9DEC9ABAEC8CA756E3B08065E593A17A60C696506233E89584620ED0BDCF8A08E39D96EFA0B400EFBF8FEFB6B2CDA15BE5B391CEBAEEA88CCBB2E1AD9CDDB4C69DC1A8E2969AE6ACBDE1BC9C4AE79FB2D1915B2EEC828AC791D09EEC99ADD0AB2DED848FC2A0E48FB75815D182D4B7EA83B1D5B7EC85A76AC3A8C8ABEFB28AECB9B7D5823113EDB3B8C095423DE39C8D1B', 'value1', 'c,a', b'11001110', '2024-10-19 15:56:07', 89.72, 56.24);
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (5828, 5008, 39.27, 'sample_UFO6bS2giPZyb8vDIaiDJAh', '2025-01-07', 'sample_IV3eYTN8SXzD4AlxOLQ5oQSJNzFV2nOuJLwcA8TNCVXwFhWWWjtY1jJvva5evxxXl1FGknUiitLzPDRTXKgmJ5mFG5bAo58Kq1MKkny0apvFYK9bt4TVQJ1kGZmWVCpA4xNiLT5nPusCFqLiyKBvcV6GwR6UMPcc5p9DG1u8pWk1t6wOarfKFTmzZv3DdeMgpOIkbbGG3c1nwbB80PAr1FH98PkXKATPaKTeCzRqrGBQ9boCeVbcBJb2NDFa4Z7J7yjqScKIHfdM5yLaKTwFiDk5s9Xbxtzj1XIzfe2sjaHLKmQgZKwF3dqicV62W3lujstWLZQdKsmpyRYSblyTFWExJ2Zu6u8sp2wH3UF0cMRjjMO3QphjiizvzbIjTBHM1VvI3ZA0iUutOFeCUt0PvDh3VMMjD62FemoyBjZP6hABrPFxJMhWoYE31DY1NfYaiYtJFaYSGVPV65QhbzwRqwF37Rk5wimUoJvgN5zJcHyGFfBISBcZTyPv6sO4XCixW4KAId8zoaA4ya2hBThpNJaX7Y2uEjZX3V9Ajuq8ox6bfmaLGcHAWJmU7plkrjVhP54cuYNtcXKnq2PqBp5GSjvCyJiX9ayplzvSk7QUJ9mREAktF4I0yUJWcJKqsRt6CLS6Ia1PkfB7aFlYXj5Ht1', X'1A49D8AFEFAD9B0C75C2BBCCB6E792B0E69EA704C08E2614D495D28EE084BBD986CEB3E799A3C4B15840CB96E3B987CFA152D7ADC186C4A9E1B8A8C9967FDB8DE8B0AED282D59100DF9DE389A6C8A4E499A1DB9AE4AF804E', 'value2', 'b,a,c', b'10101011', '2025-03-23 15:22:59', 30.58, 96.54);
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (6599, 5505, 83.52, 'sample_MNcstouXOwEPpD', '2024-12-05', 'sample_i3cGBeYfGg8mYSzT9hBDKre808T0KeVvwCd1cz9nDa3smZigpOTCNKknDcHJgyPNrznMFeJIyXiVywVB9nTUwZrIA2F2xHDqF3RwPl853tbVqQTod3Oi3yGaIdfc0k9tWTkdS2jZ1frtWhyoSuH4wTX7R9fJbL7zCiYm9cvwDcmP488dfWA4YJt1wigegiuWzgzRrF0vwDKZGs1qpRfw827rxrYrF7SIK0QW0Szbb6dnzAbPTPoBg54iWKjD1SqKKLGwTDwQa1bYaMDf9kzNGdpn9PVU6ekkDcen9lNv7dmTPKcJ4s7H55AWoRCk6ulfrToPMWuM7BUTRqu6KcwhdIK1QN2BwmoyrbO4qWUr3vfHIf2yO6GXBBTIK1jY0yNb1yN7VMOOslbwuvNCZHsd8UH6247hGF2b7vanz5oREkNJ9JZ61LyeVUD7EqbtAQUC4VHlwEmba6yS2yHNxD8OjHCCAeqfxKsPds7EfzxArIClTrNXJ04fqlKIRG2Uexhyot8mE15XrlCriEF0v82ukSdwdA2lt8SIva9F8gC0VNbWCMJUgPPWqlFRaGMIRWizhLh1INZKZaM5N3O421S3LrJ9xWfN8Q0Jw71DQrCbQcRofRfp9bsc5slfPJvOmICqPlpCTmXKiYekWT1HkR5HLJejTnzSthBx9Z1BBgtcoeVdnCTQZ3YUltxgvbBhtFtwIm8ig4pfW2DFDmzjrZfRRa5hfMbKxc3qM1TP5ss1cPaLZIJgy4D1Obbvq31qhndZJT0D1NQlQ6zrkyaXiuay1DEg78tAExE9cmZOANOvwswRm549WNvPc8GFxw3i', X'ECAF910DE092A857CB9629EC949A3BD886D5AA0FEDA9B01AE182A9C59E79CC9ADD83C2AAEA8F90720FCBA3D3A2D3BA2CEBA1AF5508D9ABD2BFE997A551E0A98AECB1B161E8B49164C9914004EFA4B0D8A2EE9593C7AF34415E4147D4AFDFBF4FD4A2DF8DD098C082CAAAD484EF88A2ED8DBAC09BEAAD8F21CA926CCBA17AE49DA1E7A19BE79C9862E4BD87E59989E4B9AAE18EA1EF8094E7B1BB070C', 'value3', 'b,a,c', b'00010101', '2025-07-25 07:59:16', 42.44, 75.28);
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (6874, 1216, 936.42, 'sample_j', '2024-10-29', 'sample_mfl9j0Gk0HyixzdbdSYYFzZocQdAwQBMkATDTVcWz0P4OaOJ9za3DPx1LER9EZxN5WFaRx9kJZVBYRUo49x05JT8Moiyp7vCGLIu7lkr0fUrRRdb8olOHWMRX0e95PGLQzDKnU3N2FxMtHRsNni5imWV0pzXuxwtlsoWUTuRVBAFH6mHpT2LUZkrx7sWtyE4CUqekZ3CRCzuu46Sye7zxbM68lxbwLCxOyqXkWg2pTDFK5vGRNgSp1yrQ5M835SBExDVrw9WKRZsP21SM2xyILt6qTYSEYsrmvB9Y5653zhLSVvzXT8Rh0yPlBXkisVetVI4Rx1zjpklX54IhPfq2mYyyn4yAUs8cJ1xwQV', X'646C7DECB19243E9B0BEC19FD3AE13EBA588C4BFE3808BEDA6AC6EDA9FD2B1D5974EDFABE5878BE6BC80C1B4C8B0E6BD8DDEB4CEB5D996E3B798CFBB3E763C3F', 'value1', 'b,d,c,a', b'00100101', '2024-12-16 00:48:58', 7.60, 4.88);
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (731, 1548, 867.91, 'sample_RiEeUdgwqk6Q3Of6fodGg14Ub3rLKY', '2025-07-03', 'sample_UZH5InrdtZD0RAFKnTt71nQIOPGGN81j9hDFtHQx21GJuKFfIguaUtcFQQ7bTdwWImUM7A3qGAiHlEjvfPCDke0SkTg4g58HDz7HYQTxuAeP8CjN4HMZB7Ec2xzAhhXq2yolGQQhtomqgPC3ce5v6Aj4OZbyqvny5Uw0PDXCDhDwln6AfnPP6mDwp23hQIJemUVC2zoPV9V4BHYJsfqRTcbafxldN6fsse4qkLU4w876N4CoRaq3S08zLc5BnpUywGNVbIcAKj2M8SgfXJEN1ODMWAxLVokJVkYVweI0B8EGxudIHjqPR1FsidZCDfCN9JatqkWr1x0AnI8OL1p9OEKPmQWWNvUb6XZ3O7JcN8nedV1KOLUDCFa4bitEUBRuCr5BFgodUKnZRS3ZXVQBDXrrCKwn2u8nNRHhMAeZIYJxzOPIhjUoGROTse40VFH7DgXUunsnZuV3aTtSg2whtSB2xuYSwrwBthsaFnTrNtV8lnpVyvpkOmhStfmLwk3KN2glfPjEMU0CLwmOgyoKiv2xlr8hMVvgtM8eEegDSSeC4sgTpRRXoOPCsN3LKTrEUNqUrUvRLmwJ9a6MWsZkDE0G9qFhB4Ki34Iv8mwWBkQ7D2MG6B0c16BxvddOHrMiv1d0fxgiU9rXil4tazfsGl1pdPeZnZiJRGBiUZK3qz5XNpRmSZjqbhan0B0U02G4Y21jsQlKhSpdHkS3uJU3XuhXh6PtALICjs2gcuwR89XhQb4SrvqhHv9ICkcKZNc43lnDj4myzSh6aMGbVIENDeGmYyWuZJMkhK9N0vunwcBNmhRAXDXAuOSCVaqmnbqSS6IYpZTGFURoJxYA5RtXF76ek9rUIJhxfjZb34mrLtOAo8vdcinx9r7gAPYIm6A8GKSdrG5QaspL4s1rMvHAMM5VcDFfb8v', X'C98B4BCF97EFBA8EE88FBECC956B7FCDACEE9FA8DBA7CF95D6A4EEB2ACC484622235185ED3B308E7BFAFD4A6E6948AEEB7B150CD81CB89DFBBD296D8A711E09D88E299B8E993A2C9AFC9B0EDA1A8E3A4BBE4B2A2E19FBD6535D88E56C99A46EF87B048E59AA0D49CECB2BDE59CA52BEEB289CFBC53E19C931FEBA0BD5BD0BFE8ABACE1A1ADC1B42AEF8D8BC2A4E183B5D681EABBA7234A5BD29BE4AAB8DCA5D29DEBB78BD6B5C2B03AE3BA89EF93905BE99BA7E597BC0FC5A7E89681E7A18F325C666AEBBD9720E8858248EEBBBFE791BEC6A807C3A7E9B696EEB5A400EF90B54A3ED4AEC5B3EFBF85EFB681D29B01EC9F9C58CFB0DEA20831CFBCD49DD1B8E397A2C196C29576C58EDE9ACA895FEBB992ECB2A2E0AFA5CB95C891EC9B8B422E44E4A6B8C4B2D6A8E69F8CE29489EE9D8D57EF8F95C08423D08FE68A807D23E9B3B47824CCBFCBA9E88490E1B7B1C7B4CB9AC1BFE5B8B7E7A2A0CDAD0D7A5149C3A806ED8E9F', 'value3', 'b,c', b'00110100', '2025-10-08 12:09:22', 0.96, 30.68);
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (1638, 7276, 941.86, 'sample_W', '2025-06-14', 'sample_PvuAiR5ovTBemlClTefhUE5vPO551vAhP6jtglEWVnqvpMD8mllNZbpSyYKzFz4QJH0lc8YOQt2opNIVhtXfPySwEuxBSK6fY4iemJ6KuncMSQIbGYmJWzP4E2V3rFZNUtANh5rb5JpmskvaILNv494DuUxhLJN5vIjwjENcbrv9nbiFWJ4NbeV7WwyAkVJKPRp23f8kdh66ahlb25GqtAvFQwpJOzGhn5kPSR6dX31wTsHJCgX', X'CCB6EDA3A56CC6AF', 'value1', 'd,b,a', b'00111000', '2025-03-18 20:16:14', 0.27, 18.42);
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (7789, 1591, 940.66, 'sample_EjFnCL4e9', '2025-07-17', 'sample_9v4jrGZl1WsSXFB50Rg1uoePT9d4Ay2G93JlqxiZYQn03y3zz7Vziv8pKBiJY', X'DEB7D592CB9AEA80846DC69DECB6B7E59395C68EE581893757C9B1DFA1EFAE98DAB1D2B1DC9F236DD9B7EC9781EAA98AEA92B2DEA7EF9395C089DB8FEE98B0E6B191C280E5809DE8B9A6DCA6D6A0536EC8B0E4BC8065ED91AB13D780E59D86E69C9FEDA69131CCBFD789C7B90F4FEBA4997A7FD58D31E39FBFC6B8E393A2CA9DE7B895E09ABCE891ACCDABEFBCA5C384ECAE99C186DE8DE58E8B0AEDA0A40DD496E29D9CCEB56F0EE79999EB90A0DEAECFA167D294C7A5EC94B6D3A4D7A3E7B2B1CA8AEE829AD391E291B50CE38DA7C987CB8FD5A8173658E6BA992FE6BFAAED9C870375D5BBDB83D1BED1B7EE879AC6A4C99C04EDBAAEE69A95D6895654CCB21E16E88C94E8A59CD2873CE9A88DEB8DBBE091A351D4AC74E98D977F2BE6B885D5A1EDB0AFCBA4D7AAE3B3AFE5BB9A4BCFB2EFB1A9EB8E83EFB69EEE81A66B', 'value2', 'a', b'00010101', '2025-02-25 04:53:23', 19.14, 68.35);
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (1136, 8970, 637.52, 'sample_zlMjqK85cpNHll', '2024-11-25', 'sample_QubZOQcjJkCOV2YMkt6s14q9OPuWBoWgTIGOPpu3SiWfQyssWCgapVMgiiwh0LXhq9Tg6pacjzwfS6G9hWILyCZv0qNUkRn2hJkFl1wIX6dWl7FypTG8KneXumtffWm2SZT70QTDkDfnOqU4NaGKsLnmqtvaDeQFOHganLuGaTRDBuh0lWC3LJ54lFHVuEfcD6b050LTZJcIPxMMemU90Q6C1', X'C783DB9E6A31DABFC8B137E0858C70CE93EA91976148EC9A82E3B993DF8257E38787DC8EDB9DCFB94EDC90E8B08A593CEFB8B6EE82BE4E05403AE2B994EEB787DF86D1AADBAEE1ACA9E5A59D3656ECA58DC5A2E795B9E1A5BCE0BAB5EFA2BDC18CCDBA0F6FD2A2C791E7A7AECAB9ECA188E08AAAE9BD9B5DD89C1DD2AB43C7B8C9AE1BD6B9E1BBBF1E34E28089C1AB4A68E599BCE4A885CDA4E48EA9D7905376D4AF59', 'value1', 'c,d,a', b'11010000', '2025-03-16 04:17:08', 29.88, 40.90);
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (1777, 5301, 880.63, 'sample_epCubekxcn1Hl0Ta', '2025-02-15', 'sample_LtU7Lbepyv3z0WujIMwwijIkWLnOWyrvBIY8rudn271qCK1zd9XxNf7VX6NTkzs97jHYOzql9fI2UeRhpJ6yijgpyyTIang4DpqOt5CHiMCNQrPlKCGo8AMIf2ROdURDkCYNjdzJzVQbbgQ0Z2XxdDeU4SsrFSANT9c1O9Z4hWiL3jnk5TIBGjd7N4gzSFPYNFAzcoUSBSXDvQA2ashsndtHuWQeOgoAOpJqYHsdDlp2HsvEHwnBTWRn6qyE9njqHrduvjT6RkuJ72xWHlswNslTT9dQ0ZV5vcWbS8oVWtyIPb5E81rh2TsgH9KjexhiN8BpruGkztec0k9ByrrtS2BN3MPbeuWAANXwcrl8jhPTx8FWRwIABxUl17BdZe0J6A0VKmcAzKsHVY392WYB1WurWELWOmvMMYIrY7aTNfUe4seUxxVBZoRnAqZRi1lgESkqZuOWzH3YzXMRSvaMsF4q8aOtZgK16V7yikQWjotfDeXnDhHW59PMiWclWrjDDgwiJXPzHjn9v7Q4mw4cBkHaT9pTp1EdCYyHPPmXiw70MRsB73XixzKYnOMHDr5qqhkkEqmJRGvt5cTbGE26arSZT0rHjRuOIHTvBh0ozYheAV8yiA0U05MrcAb1Vo5DmxW8s7vujyMpaP8qEyYvaOFBrt8UZUKhvnm3zELDbBHNPbyixbjs4KriJ1qPPKBXIcQ0r66Vz4wMI4HP3HpMEcR1OWoBroZ21twSroiU', X'45DEBECB8319D794EDAEA710D587DCA41A54EEA699E28AA619D2BCCEA213E5ACAED18D5FD2AB6DCEBC4EECB58CE68A9AC9BBDB8550435C6DC48EE4AB8ADBA242E3B5B7ED9D81C4B1EEAFBB6157D9B8CA89E8ABB942D987E29C97CF93DC86C6BFD5AB6B345CE1B2AAEFBDAAD9B2D69F00D4BAE3AAB4DDA6C39EEF81822A3CEBA5BA6F3CE9A8AC0976E9A4BA4D', 'value2', 'b,d', b'00000001', '2024-12-06 05:54:08', 42.26, 2.66);
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (8306, 1556, 122.41, 'sample_tI1UUpc52cCJ9l1664Lg4ZUVZ4IBy1HQOgn4ejFHv', '2024-10-16', 'sample_bMOk3xoCKgEFr4HIUL6VXX3rOATtusLXeFR2mBpvn3jZNttqt8wKRqv3A5PC5qn4WrW3NS3HER8nczdhl8HNt6IvKl5m5wQm0ZzEetbQIZZFi6hStC5NhhkaUakg9vjf3gxgv4mV4Ot1U0RY36fc5CdjNmqdF3U7eK0bppK9ZPYOPGOS3XGWd4xjLuqMqsGDWQN0X9fSAcKT3tCsm79JqZ61q4jMvBUa97KPPozUrLPNpV18WVE0u8AqYnai4axHdy2jTMCdfGnhAQF0VHxzr6Wls8VXCnMKQxUFqwuYa9Kg09lvEdD0nUP4xsWA1VAPjfGMCzKaOhU7GM5t5WYyHRO25ZNo8TJ5DHn0Op', X'CCB4C29DCCA14DEDB9BEE1AA9E37D489EBA7B2ED829FDAAACFBD36EC9A8AE094ACE9A69CC5B44350E69C86D4A7E9AD9414E19B8D7CDEB2DE92E98EB3E9ACBFDFB83FE986B1EEBB9469E0A4A1551ACA89D3BFDFBDCBA84BE1AB8DE5AB87CD8AED81B9EF89B9E8A087D4A1723C2EEB8EB2EC98A1EB86A003E69EBCD987D2A5D5AD24DAB80B4BE49B82D494EEB1A5DABDD883EFB0B057C895CAA61B3C1CDD9443467124C0B3DB980824CA99DB8A50D68FEFA3AF04DAAD16EC89924F18C3B5D0814CE69284E086812A7BE699A2E1B9A45A63D2A4DABBE5969DE9A799C7B41AD0B136D49C7D24D7B6DEA0E8B5917E5AD1ADCD8FEC899AEBA28DEAB59EE3A38117C687E29986C4BA2B62EF8583E6A5A276C685253B71E29781171FE787B711C4A0DA930A140DE9979CC4B9C4BBE58898CCA4EF89B33D3E1ED0A0E385A5C182E8BBA1CF8D', 'value3', 'a,b', b'01010100', '2025-02-26 00:38:38', 92.33, 69.53);
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (2036, 5767, 600.01, 'sample_bKUnO9E6vE', '2025-03-16', 'sample_MdYNeIUJyHJTAP1O4iF93tSs6OPAtUOR03SbUTtdgbZhJYzTO4CobjWlqe2cu1Z1Z6bmDBKw06WCTHw833aImJHaZbg5Tknblqfdze0RMPkCMlaGbMgx1Ohw8rfVYY6rCD1N2laNNTJTMEzMbCub9vrm9OKlOX4Nnwp3SyC6fWsMOrk0gJ4EXMwM5wfucM1X0GgSsAdtmNW6vUyJBkt4uXdoAafAVboNu7iMjMUKj0VX2vqcCiBkUh2toomTughWI8UWYrQkDDWPuTeDyy5v1GnyQwUOAskKicEztY2cFZLOJEfk3B9IMTd6tLIsUAzVAH2cOJjbeKOpn8s2dG4cMhcwDdaYQTSo6IL4akCFoGwI1jopZCiFpvC8hhV3xyhWadMVDIiWKOTriEAUcV6aKRwGo0qJ8jNcwGDivuiMmlQVXrsHj4JK1lZL9NtyGu9zG7x1nDstGlRYZfafcz4cYAcbGg4193PfKQq7VXsyRSElnqVlMOG3cdDr7RTjNkTvEVxyXK', X'E3A9BBE18B8CC69D05D1B5CAABD3A5CA92E986A5CBB2E4AC86E1B394E6B2A0CC8527', 'value1', 'b', b'10001010', '2025-08-15 01:51:14', 11.32, 60.45);
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (1141, 5505, 558.70, 'sample_sJKYBvl2SH70H', '2025-06-08', 'sample_zjsCtWR0ubxSbhcOJbIF64vhjLakOV6EuGlCrLkYAPdKwoKGWSxOKKh1O1oekdnMwPwQ9Hm7Feme2RSfo0HHhqKOouagQ1SodJdoJ3m9Du76UMBQpmNt7TmiCoUT56D9egymdxwTzQkIYwwOR29gFtfOZCaIZnVOkRFCw8csu19I7NKMAsUfvpwmWc8le6uXbK3tbKgpCN6BTLKQq4hxlISeYjsA0Vx3zC5sVuaBvZpuy1ddpXyqbuVTugwzis3nipnr5ElUeTMl0s4d1zFgjECGL0mYk7Zf0mUBOOGyWmcWR2J6gamjUd3ZdwH2mwS2CB8wOV6hthXdrbPxO0vaUtGZv4tIkR7woLP1v9DpEC7mj5nzNPVH4UvD3F9F7QskZMEpD7BLJWNdJdVfTj8DyHjvVBySlEHCwYi7q0kZKTn65Z0FPUcPw8709LxIjdNUBaeEVmZPbY4XPBm3Glz2fg8bZ3fQ1PMQheGDauVPIdYwqDTWI5cc0NoyiSYHxVFNL4BQQHAjhWOtBdYu3d5bTpSAZr4utaRQlzuAvS0ZRmCyHQUPsKynoB2YkzBFyA5PjzZVWCgjfpeiwhatdAEfHAfpRuhTJrbGXQiadqPuS6QorfDOnXK2EypkdGb6raDHMhlwxb24NOIc6eaTL9i5rnjbGldBrlOWHnzD2fohJ8t88YySHWchpfu8fPS5iHM4qpgAaaYW9hAlRgljmN4CDRsCCBHgB6GiaNLfkJugV60UuZrwhhRBzdytOLigLcCNsnbNFLEdMZs5gGExxhwy93o4Qlor7wjZrv0EF3ISu9RIynqN5PU2F4j0kHDZwdX4EQmxOlo40giiKvJOJ9m01POZEiXLNWMbSnWBqIF9DeCBmoN8rBy5JafLUV67Jbp9hiWr50tc9GybRIrpj7DVVi33ndCxmkAE3jQoyi8NJeDT9HW43f9xGSvfcPwnZY', X'C887DA8EEAB8B0ECA684D2A6D2973BD8B1E0A2B5DF9965EA9692D2BC26C4BDCEB4304AD59FC49230CC8EEA8782EFACA3DD8977EEBD9ACD872624E088B879DA9BE984A12BC09E37E6B1A1C38BE3A3A8C5A0CB91E8AA86ED8D90E0B49FE8A7ACD6A9E2B89BD888E09AAF4DE6B78FE8B99EC799E49F89D5A1DDBBEE858ECFBCEA9999E79CB2ECAE8D0AEE8EA2CA93C8B02DE880A104CB9BD8A136C0B353ED9ABE79DD96D689D99D7A6E7159E79389CA85C790E1998B', 'value2', 'c,a', b'00011011', '2025-03-17 20:46:07', 0.97, 1.83);
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (7163, 7276, 772.99, 'sample_R42gUuqNzN8DzREqFdmQ', '2025-03-14', 'sample_zBqIGrmHpsYGgw7KHhPQ1HqIqeuVbwlswBFn9azzBhX0hALuZ1kK5yS53vANcAPf2TSNltUduMFZkVudpFUltm2WD8AeOcqfbK0enyvNlSOv6uvKOJjJ4XovM57WIkhWExGivpNMNyE2qwGfbs4djhnddOV145EWHuXonhLtFYHQf7k09F3QIm8dBoYlgEt4kdLOq8AhZY7RV3934xK4jC7ROXvWxELVbSMkWlpkLKtdfIgCgdfO5ncv1VVoCVvcf4ekw5hbz9iSk0y2eCyJo7Z2Pbx3m9GKDZ5kjNp2El2locg7DNasOaLuvfd80vNLuHmdACpJ2OSVVDcpHzGWpmtrXgZJXYiZSu6SByZgwu51Ntxn9Yj6TGKMfrDL1PCk84M8K1E6HweWzKTmQf9mIn0ySF1yUHmFY8VFTeTBb4q3Kn8otshzHhMBcUOdfLix5ybpIa8mw9Sfn8wY4lAkZxqSXvn9IYei1vwN2tVq3Zyu8ft5HnVpcVlchCu2oDJsJ4ZOOsWaPVqsDaZPUU63jJlHibzBCipRa4ruaNuFf2v7M2nbeBEg9rrHKSAVVrp5Ze6QK1SaRWkhUew98XedeYGWGqyAHOIGdz9kiQAskWGluNnQWJPNNhOvB0YrirG1AeLxSDbPVphsXVZVIhivC23d35THVitjPdi0EBSBbAmQ7GERl1R', X'6FD7A3CE9D43E8B4BFDF972EC995E894ABE0A28BDABBED9DB55FED9EA505DCAF0CCCBCE989ABC395CD9E1520D79C7743EBBE88DDB8EDBF9465E3AAB2CBBE6CE286A2CFB1300B52CAAEEA8D8B547A6EE4B282D39B5FDD8FE093BDE48D99DFBD50E3B49D5963E48D8DE4AF82E48097DEBCE087A06FC78730E68E8D15E2B19BC09FD29A5E294A68DD9B27D18DD280E3A2A525E3A385E0828A7D5818EFB098CCBBCFB8EAB7B5DCA6EEBCA3E0A9BD782ECCB570C494E98BB076D0A2DC996B3426D9B562326A29CA8EEFA89C16DD8059D28313D288D1A4E0A387E9808BE98F98D699D3A676D1BACCBBCE87E59ABF02EAA098ED9EB7EF938DEC85B0DEA934DF9FE1BA88DF8769C0900DC2BEEDB6A640E3B89BEAA5B4042DE38CB36DD691D2A35A0BC28AEEA2A4E485ADEDBAACE8BBBFE0B6B6CEA3E1B582C8B405D9B373', 'value1', 'c,b', b'10101100', '2025-04-25 14:00:25', 85.74, 20.39);
WITH cte_565 AS (SELECT ynt23.c12 AS col_1, MAX(ynt23.c9) AS col_3 FROM t2 AS ynt23 GROUP BY ynt23.c12) SELECT DISTINCT cte.col_1 AS col_1, cte.col_3 AS col_3 FROM cte_565 AS cte WHERE cte.col_1 = 21 GROUP BY cte.col_3, cte.col_1 ORDER BY cte.col_3 DESC;
WITH cte_565 AS (SELECT ynt23.c12 AS col_1, MIN(ynt23.c9) AS col_3 FROM t2 AS ynt23 GROUP BY ynt23.c12) SELECT DISTINCT cte.col_1 AS col_1, cte.col_3 AS col_3 FROM cte_565 AS cte WHERE cte.col_1 = 21 GROUP BY cte.col_3, cte.col_1 ORDER BY cte.col_3 DESC;
© 2026, Oracle Corporation and/or its affiliates
Description: after changing MAX(ynt23.c9) to MIN(ynt.c9),the col_3's value unexpectedly become greater. Additionnally,ynt23.c9's type is longblob mysql> WITH cte_565 AS (SELECT ynt23.c12 AS col_1, MAX(ynt23.c9) AS col_3 FROM t2 AS ynt23 GROUP BY ynt23.c12) SELECT DISTINCT cte.col_1 AS col_1, cte.col_3 AS col_3 FROM cte_565 AS cte WHERE cte.col_1 = 21 GROUP BY cte.col_3, cte.col_1 ORDER BY cte.col_3 DESC; +--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | col_1 | col_3 | +--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 0x15 | 0xECAF910DE092A857CB9629EC949A3BD886D5AA0FEDA9B01AE182A9C59E79CC9ADD83C2AAEA8F90720FCBA3D3A2D3BA2CEBA1AF5508D9ABD2BFE997A551E0A98AECB1B161E8B49164C9914004EFA4B0D8A2EE9593C7AF34415E4147D4AFDFBF4FD4A2DF8DD098C082CAAAD484EF88A2ED8DBAC09BEAAD8F21CA926CCBA17AE49DA1E7A19BE79C9862E4BD87E59989E4B9AAE18EA1EF8094E7B1BB070C | +--------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.01 sec) mysql> WITH cte_565 AS (SELECT ynt23.c12 AS col_1, MIN(ynt23.c9) AS col_3 FROM t2 AS ynt23 GROUP BY ynt23.c12) SELECT DISTINCT cte.col_1 AS col_1, cte.col_3 AS col_3 FROM cte_565 AS cte WHERE cte.col_1 = 21 GROUP BY cte.col_3, cte.col_1 ORDER BY cte.col_3 DESC; +--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | col_1 | col_3 | +--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 0x15 | 0xDEB7D592CB9AEA80846DC69DECB6B7E59395C68EE581893757C9B1DFA1EFAE98DAB1D2B1DC9F236DD9B7EC9781EAA98AEA92B2DEA7EF9395C089DB8FEE98B0E6B191C280E5809DE8B9A6DCA6D6A0536EC8B0E4BC8065ED91AB13D780E59D86E69C9FEDA69131CCBFD789C7B90F4FEBA4997A7FD58D31E39FBFC6B8E393A2CA9DE7B895E09ABCE891ACCDABEFBCA5C384ECAE99C186DE8DE58E8B0AEDA0A40DD496E29D9CCEB56F0EE79999EB90A0DEAECFA167D294C7A5EC94B6D3A4D7A3E7B2B1CA8AEE829AD391E291B50CE38DA7C987CB8FD5A8173658E6BA992FE6BFAAED9C870375D5BBDB83D1BED1B7EE879AC6A4C99C04EDBAAEE69A95D6895654CCB21E16E88C94E8A59CD2873CE9A88DEB8DBBE091A351D4AC74E98D977F2BE6B885D5A1EDB0AFCBA4D7AAE3B3AFE5BB9A4BCFB2EFB1A9EB8E83EFB69EEE81A66B | +--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 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, PRIMARY KEY (c1) ); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (1214, 9368, 934.98, 'sample_ggm', '2025-06-11', 'sample_5BohNIDnG4rqmuIjGd861gc1no5JGRKdsKrPb1bclM8UX75sWpDtsihpx77IDJsTi5Vytttbpvql2IoKWGkr2nicFDIbj4wiwkk5MdJ5CgiKDBHNvtHJDddw9OnYnt5WnFfHerl8HBuOiLfcOZmILs5xBJEeMsBRbvUlVWRgpAbdijBckmbcKcCb2WQAjSN1ehLqj2lxZUni9i4ANptTCk3fS0DfliKdFt79UfifFwNM5WcIPgD3uYw4zDwGYS3nK7KR9iBsJthwarFGvPxKTXVnuEzWCe7z69Znrf0tLZbVPVG8b3pEfSezM8bpFmd6aMob7OUJCERMRkp3360lbwrIG0ncz04LxrEemua4Ne6zp5vr9gGi2HSFstUc1Mm7cmVO1YVThSKgxllF9Fp0EnixyL2eCMlJhjNMfuvurjBb1LW4LB3aoKYF9BESUcXVtNEEpOEMNRtvHsUX6ioNcLeAu0TRc2rEDmf3eg9hamlKEQsGgINCNbc3dyR2al6GFdsf1qnNMbPCr0ko6PzvgErbqb8ptFJRRu4RAkSUspOXOBi7QsxkwS1hTBjtRrZiFLE9RVqBhJDJzMHYy0bGrSDcB0G6bFPqMXaTwhqcOAwhRkIItgR', X'1CE48ABBE1A8A5EFBA81E79083E0B9A1D7B0E3868DD9ACEF95AAE3849221E88582EBABB668CB867ADDB1DE8145D5A5D097E992BD53E68186EE80AFC896C783', 'value3', 'c', b'10100010', '2025-04-16 23:57:06', 21.73, 37.73); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (577, 4847, 972.81, 'sample_PkNlMG5xXiJEQBotwJddZgieb2TF4', '2025-03-07', 'sample_McuYtKzyYbUMaqEgD05XiPRE9xrYtFNByPUAeUZfQ7NWb9x5toioxqP1EuggbveEMXJ4GY2YotlAvBd2vzAzq54EAIlQ5FIH1hsK8nzgkH9FINKYcNEnKN0koKXoO9jNOvPEe7EO8d3aJVBwnilObKiB6qh53qSd7F1lLbfczineOzKSHg2AlUD6wB9BfVSPC6GmtGXRVNjVaqyGZyUK1VEPH5f3aPK', X'E58FA9CE8FD997E896BE0FE38187E0BC8CEFB484C29FDA8AE9B98A30CA96ED8DAECBA40237E4A2A3D682E2BCBBC58458E88D93E29F84D7906519CAB4D683EEAE9FE184B0310FD0A1E787A9E3A994C287E2AB89DE8DE592ADD698E6818CC3BBEB988A7319D590DEA0D5980D1764CA9EE88BA51A2BE1AEAF76E8B9ACE39D96D2ABEB8991E7AB9237DCBD6FE9B2A3E9A894D7ADEFAFAC1B44E59A8BE5B790320CDEAC412BEBB788E0BC8CCFB0EFBC9EC6B2CD8274CABFECB090E7B2BADCB9EF93B503EA82A0CDA7ECB79D04CF9979DBBBDEA8DB99E7AF8645C38B49DFAE45CE8DD1B7DCBE6F527EE18D95D398E384A702E892B47FC39967E0B8A9C6BAD9A3EDB988CDAF09EBBEA4333EE58D9760D49A2EECADB5DEB00A3F1B1DDCAFC5B4E2ACA00CD2B379D283D7A8CDBBE59C90E0968C33EFB9A4EEAD8C40DBACCDBAD097E1B793D1AD2CDB9DEC9ABAEC8CA756E3B08065E593A17A60C696506233E89584620ED0BDCF8A08E39D96EFA0B400EFBF8FEFB6B2CDA15BE5B391CEBAEEA88CCBB2E1AD9CDDB4C69DC1A8E2969AE6ACBDE1BC9C4AE79FB2D1915B2EEC828AC791D09EEC99ADD0AB2DED848FC2A0E48FB75815D182D4B7EA83B1D5B7EC85A76AC3A8C8ABEFB28AECB9B7D5823113EDB3B8C095423DE39C8D1B', 'value1', 'c,a', b'11001110', '2024-10-19 15:56:07', 89.72, 56.24); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (5828, 5008, 39.27, 'sample_UFO6bS2giPZyb8vDIaiDJAh', '2025-01-07', 'sample_IV3eYTN8SXzD4AlxOLQ5oQSJNzFV2nOuJLwcA8TNCVXwFhWWWjtY1jJvva5evxxXl1FGknUiitLzPDRTXKgmJ5mFG5bAo58Kq1MKkny0apvFYK9bt4TVQJ1kGZmWVCpA4xNiLT5nPusCFqLiyKBvcV6GwR6UMPcc5p9DG1u8pWk1t6wOarfKFTmzZv3DdeMgpOIkbbGG3c1nwbB80PAr1FH98PkXKATPaKTeCzRqrGBQ9boCeVbcBJb2NDFa4Z7J7yjqScKIHfdM5yLaKTwFiDk5s9Xbxtzj1XIzfe2sjaHLKmQgZKwF3dqicV62W3lujstWLZQdKsmpyRYSblyTFWExJ2Zu6u8sp2wH3UF0cMRjjMO3QphjiizvzbIjTBHM1VvI3ZA0iUutOFeCUt0PvDh3VMMjD62FemoyBjZP6hABrPFxJMhWoYE31DY1NfYaiYtJFaYSGVPV65QhbzwRqwF37Rk5wimUoJvgN5zJcHyGFfBISBcZTyPv6sO4XCixW4KAId8zoaA4ya2hBThpNJaX7Y2uEjZX3V9Ajuq8ox6bfmaLGcHAWJmU7plkrjVhP54cuYNtcXKnq2PqBp5GSjvCyJiX9ayplzvSk7QUJ9mREAktF4I0yUJWcJKqsRt6CLS6Ia1PkfB7aFlYXj5Ht1', X'1A49D8AFEFAD9B0C75C2BBCCB6E792B0E69EA704C08E2614D495D28EE084BBD986CEB3E799A3C4B15840CB96E3B987CFA152D7ADC186C4A9E1B8A8C9967FDB8DE8B0AED282D59100DF9DE389A6C8A4E499A1DB9AE4AF804E', 'value2', 'b,a,c', b'10101011', '2025-03-23 15:22:59', 30.58, 96.54); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (6599, 5505, 83.52, 'sample_MNcstouXOwEPpD', '2024-12-05', 'sample_i3cGBeYfGg8mYSzT9hBDKre808T0KeVvwCd1cz9nDa3smZigpOTCNKknDcHJgyPNrznMFeJIyXiVywVB9nTUwZrIA2F2xHDqF3RwPl853tbVqQTod3Oi3yGaIdfc0k9tWTkdS2jZ1frtWhyoSuH4wTX7R9fJbL7zCiYm9cvwDcmP488dfWA4YJt1wigegiuWzgzRrF0vwDKZGs1qpRfw827rxrYrF7SIK0QW0Szbb6dnzAbPTPoBg54iWKjD1SqKKLGwTDwQa1bYaMDf9kzNGdpn9PVU6ekkDcen9lNv7dmTPKcJ4s7H55AWoRCk6ulfrToPMWuM7BUTRqu6KcwhdIK1QN2BwmoyrbO4qWUr3vfHIf2yO6GXBBTIK1jY0yNb1yN7VMOOslbwuvNCZHsd8UH6247hGF2b7vanz5oREkNJ9JZ61LyeVUD7EqbtAQUC4VHlwEmba6yS2yHNxD8OjHCCAeqfxKsPds7EfzxArIClTrNXJ04fqlKIRG2Uexhyot8mE15XrlCriEF0v82ukSdwdA2lt8SIva9F8gC0VNbWCMJUgPPWqlFRaGMIRWizhLh1INZKZaM5N3O421S3LrJ9xWfN8Q0Jw71DQrCbQcRofRfp9bsc5slfPJvOmICqPlpCTmXKiYekWT1HkR5HLJejTnzSthBx9Z1BBgtcoeVdnCTQZ3YUltxgvbBhtFtwIm8ig4pfW2DFDmzjrZfRRa5hfMbKxc3qM1TP5ss1cPaLZIJgy4D1Obbvq31qhndZJT0D1NQlQ6zrkyaXiuay1DEg78tAExE9cmZOANOvwswRm549WNvPc8GFxw3i', X'ECAF910DE092A857CB9629EC949A3BD886D5AA0FEDA9B01AE182A9C59E79CC9ADD83C2AAEA8F90720FCBA3D3A2D3BA2CEBA1AF5508D9ABD2BFE997A551E0A98AECB1B161E8B49164C9914004EFA4B0D8A2EE9593C7AF34415E4147D4AFDFBF4FD4A2DF8DD098C082CAAAD484EF88A2ED8DBAC09BEAAD8F21CA926CCBA17AE49DA1E7A19BE79C9862E4BD87E59989E4B9AAE18EA1EF8094E7B1BB070C', 'value3', 'b,a,c', b'00010101', '2025-07-25 07:59:16', 42.44, 75.28); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (6874, 1216, 936.42, 'sample_j', '2024-10-29', 'sample_mfl9j0Gk0HyixzdbdSYYFzZocQdAwQBMkATDTVcWz0P4OaOJ9za3DPx1LER9EZxN5WFaRx9kJZVBYRUo49x05JT8Moiyp7vCGLIu7lkr0fUrRRdb8olOHWMRX0e95PGLQzDKnU3N2FxMtHRsNni5imWV0pzXuxwtlsoWUTuRVBAFH6mHpT2LUZkrx7sWtyE4CUqekZ3CRCzuu46Sye7zxbM68lxbwLCxOyqXkWg2pTDFK5vGRNgSp1yrQ5M835SBExDVrw9WKRZsP21SM2xyILt6qTYSEYsrmvB9Y5653zhLSVvzXT8Rh0yPlBXkisVetVI4Rx1zjpklX54IhPfq2mYyyn4yAUs8cJ1xwQV', X'646C7DECB19243E9B0BEC19FD3AE13EBA588C4BFE3808BEDA6AC6EDA9FD2B1D5974EDFABE5878BE6BC80C1B4C8B0E6BD8DDEB4CEB5D996E3B798CFBB3E763C3F', 'value1', 'b,d,c,a', b'00100101', '2024-12-16 00:48:58', 7.60, 4.88); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (731, 1548, 867.91, 'sample_RiEeUdgwqk6Q3Of6fodGg14Ub3rLKY', '2025-07-03', 'sample_UZH5InrdtZD0RAFKnTt71nQIOPGGN81j9hDFtHQx21GJuKFfIguaUtcFQQ7bTdwWImUM7A3qGAiHlEjvfPCDke0SkTg4g58HDz7HYQTxuAeP8CjN4HMZB7Ec2xzAhhXq2yolGQQhtomqgPC3ce5v6Aj4OZbyqvny5Uw0PDXCDhDwln6AfnPP6mDwp23hQIJemUVC2zoPV9V4BHYJsfqRTcbafxldN6fsse4qkLU4w876N4CoRaq3S08zLc5BnpUywGNVbIcAKj2M8SgfXJEN1ODMWAxLVokJVkYVweI0B8EGxudIHjqPR1FsidZCDfCN9JatqkWr1x0AnI8OL1p9OEKPmQWWNvUb6XZ3O7JcN8nedV1KOLUDCFa4bitEUBRuCr5BFgodUKnZRS3ZXVQBDXrrCKwn2u8nNRHhMAeZIYJxzOPIhjUoGROTse40VFH7DgXUunsnZuV3aTtSg2whtSB2xuYSwrwBthsaFnTrNtV8lnpVyvpkOmhStfmLwk3KN2glfPjEMU0CLwmOgyoKiv2xlr8hMVvgtM8eEegDSSeC4sgTpRRXoOPCsN3LKTrEUNqUrUvRLmwJ9a6MWsZkDE0G9qFhB4Ki34Iv8mwWBkQ7D2MG6B0c16BxvddOHrMiv1d0fxgiU9rXil4tazfsGl1pdPeZnZiJRGBiUZK3qz5XNpRmSZjqbhan0B0U02G4Y21jsQlKhSpdHkS3uJU3XuhXh6PtALICjs2gcuwR89XhQb4SrvqhHv9ICkcKZNc43lnDj4myzSh6aMGbVIENDeGmYyWuZJMkhK9N0vunwcBNmhRAXDXAuOSCVaqmnbqSS6IYpZTGFURoJxYA5RtXF76ek9rUIJhxfjZb34mrLtOAo8vdcinx9r7gAPYIm6A8GKSdrG5QaspL4s1rMvHAMM5VcDFfb8v', X'C98B4BCF97EFBA8EE88FBECC956B7FCDACEE9FA8DBA7CF95D6A4EEB2ACC484622235185ED3B308E7BFAFD4A6E6948AEEB7B150CD81CB89DFBBD296D8A711E09D88E299B8E993A2C9AFC9B0EDA1A8E3A4BBE4B2A2E19FBD6535D88E56C99A46EF87B048E59AA0D49CECB2BDE59CA52BEEB289CFBC53E19C931FEBA0BD5BD0BFE8ABACE1A1ADC1B42AEF8D8BC2A4E183B5D681EABBA7234A5BD29BE4AAB8DCA5D29DEBB78BD6B5C2B03AE3BA89EF93905BE99BA7E597BC0FC5A7E89681E7A18F325C666AEBBD9720E8858248EEBBBFE791BEC6A807C3A7E9B696EEB5A400EF90B54A3ED4AEC5B3EFBF85EFB681D29B01EC9F9C58CFB0DEA20831CFBCD49DD1B8E397A2C196C29576C58EDE9ACA895FEBB992ECB2A2E0AFA5CB95C891EC9B8B422E44E4A6B8C4B2D6A8E69F8CE29489EE9D8D57EF8F95C08423D08FE68A807D23E9B3B47824CCBFCBA9E88490E1B7B1C7B4CB9AC1BFE5B8B7E7A2A0CDAD0D7A5149C3A806ED8E9F', 'value3', 'b,c', b'00110100', '2025-10-08 12:09:22', 0.96, 30.68); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (1638, 7276, 941.86, 'sample_W', '2025-06-14', 'sample_PvuAiR5ovTBemlClTefhUE5vPO551vAhP6jtglEWVnqvpMD8mllNZbpSyYKzFz4QJH0lc8YOQt2opNIVhtXfPySwEuxBSK6fY4iemJ6KuncMSQIbGYmJWzP4E2V3rFZNUtANh5rb5JpmskvaILNv494DuUxhLJN5vIjwjENcbrv9nbiFWJ4NbeV7WwyAkVJKPRp23f8kdh66ahlb25GqtAvFQwpJOzGhn5kPSR6dX31wTsHJCgX', X'CCB6EDA3A56CC6AF', 'value1', 'd,b,a', b'00111000', '2025-03-18 20:16:14', 0.27, 18.42); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (7789, 1591, 940.66, 'sample_EjFnCL4e9', '2025-07-17', 'sample_9v4jrGZl1WsSXFB50Rg1uoePT9d4Ay2G93JlqxiZYQn03y3zz7Vziv8pKBiJY', X'DEB7D592CB9AEA80846DC69DECB6B7E59395C68EE581893757C9B1DFA1EFAE98DAB1D2B1DC9F236DD9B7EC9781EAA98AEA92B2DEA7EF9395C089DB8FEE98B0E6B191C280E5809DE8B9A6DCA6D6A0536EC8B0E4BC8065ED91AB13D780E59D86E69C9FEDA69131CCBFD789C7B90F4FEBA4997A7FD58D31E39FBFC6B8E393A2CA9DE7B895E09ABCE891ACCDABEFBCA5C384ECAE99C186DE8DE58E8B0AEDA0A40DD496E29D9CCEB56F0EE79999EB90A0DEAECFA167D294C7A5EC94B6D3A4D7A3E7B2B1CA8AEE829AD391E291B50CE38DA7C987CB8FD5A8173658E6BA992FE6BFAAED9C870375D5BBDB83D1BED1B7EE879AC6A4C99C04EDBAAEE69A95D6895654CCB21E16E88C94E8A59CD2873CE9A88DEB8DBBE091A351D4AC74E98D977F2BE6B885D5A1EDB0AFCBA4D7AAE3B3AFE5BB9A4BCFB2EFB1A9EB8E83EFB69EEE81A66B', 'value2', 'a', b'00010101', '2025-02-25 04:53:23', 19.14, 68.35); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (1136, 8970, 637.52, 'sample_zlMjqK85cpNHll', '2024-11-25', 'sample_QubZOQcjJkCOV2YMkt6s14q9OPuWBoWgTIGOPpu3SiWfQyssWCgapVMgiiwh0LXhq9Tg6pacjzwfS6G9hWILyCZv0qNUkRn2hJkFl1wIX6dWl7FypTG8KneXumtffWm2SZT70QTDkDfnOqU4NaGKsLnmqtvaDeQFOHganLuGaTRDBuh0lWC3LJ54lFHVuEfcD6b050LTZJcIPxMMemU90Q6C1', X'C783DB9E6A31DABFC8B137E0858C70CE93EA91976148EC9A82E3B993DF8257E38787DC8EDB9DCFB94EDC90E8B08A593CEFB8B6EE82BE4E05403AE2B994EEB787DF86D1AADBAEE1ACA9E5A59D3656ECA58DC5A2E795B9E1A5BCE0BAB5EFA2BDC18CCDBA0F6FD2A2C791E7A7AECAB9ECA188E08AAAE9BD9B5DD89C1DD2AB43C7B8C9AE1BD6B9E1BBBF1E34E28089C1AB4A68E599BCE4A885CDA4E48EA9D7905376D4AF59', 'value1', 'c,d,a', b'11010000', '2025-03-16 04:17:08', 29.88, 40.90); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (1777, 5301, 880.63, 'sample_epCubekxcn1Hl0Ta', '2025-02-15', 'sample_LtU7Lbepyv3z0WujIMwwijIkWLnOWyrvBIY8rudn271qCK1zd9XxNf7VX6NTkzs97jHYOzql9fI2UeRhpJ6yijgpyyTIang4DpqOt5CHiMCNQrPlKCGo8AMIf2ROdURDkCYNjdzJzVQbbgQ0Z2XxdDeU4SsrFSANT9c1O9Z4hWiL3jnk5TIBGjd7N4gzSFPYNFAzcoUSBSXDvQA2ashsndtHuWQeOgoAOpJqYHsdDlp2HsvEHwnBTWRn6qyE9njqHrduvjT6RkuJ72xWHlswNslTT9dQ0ZV5vcWbS8oVWtyIPb5E81rh2TsgH9KjexhiN8BpruGkztec0k9ByrrtS2BN3MPbeuWAANXwcrl8jhPTx8FWRwIABxUl17BdZe0J6A0VKmcAzKsHVY392WYB1WurWELWOmvMMYIrY7aTNfUe4seUxxVBZoRnAqZRi1lgESkqZuOWzH3YzXMRSvaMsF4q8aOtZgK16V7yikQWjotfDeXnDhHW59PMiWclWrjDDgwiJXPzHjn9v7Q4mw4cBkHaT9pTp1EdCYyHPPmXiw70MRsB73XixzKYnOMHDr5qqhkkEqmJRGvt5cTbGE26arSZT0rHjRuOIHTvBh0ozYheAV8yiA0U05MrcAb1Vo5DmxW8s7vujyMpaP8qEyYvaOFBrt8UZUKhvnm3zELDbBHNPbyixbjs4KriJ1qPPKBXIcQ0r66Vz4wMI4HP3HpMEcR1OWoBroZ21twSroiU', X'45DEBECB8319D794EDAEA710D587DCA41A54EEA699E28AA619D2BCCEA213E5ACAED18D5FD2AB6DCEBC4EECB58CE68A9AC9BBDB8550435C6DC48EE4AB8ADBA242E3B5B7ED9D81C4B1EEAFBB6157D9B8CA89E8ABB942D987E29C97CF93DC86C6BFD5AB6B345CE1B2AAEFBDAAD9B2D69F00D4BAE3AAB4DDA6C39EEF81822A3CEBA5BA6F3CE9A8AC0976E9A4BA4D', 'value2', 'b,d', b'00000001', '2024-12-06 05:54:08', 42.26, 2.66); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (8306, 1556, 122.41, 'sample_tI1UUpc52cCJ9l1664Lg4ZUVZ4IBy1HQOgn4ejFHv', '2024-10-16', 'sample_bMOk3xoCKgEFr4HIUL6VXX3rOATtusLXeFR2mBpvn3jZNttqt8wKRqv3A5PC5qn4WrW3NS3HER8nczdhl8HNt6IvKl5m5wQm0ZzEetbQIZZFi6hStC5NhhkaUakg9vjf3gxgv4mV4Ot1U0RY36fc5CdjNmqdF3U7eK0bppK9ZPYOPGOS3XGWd4xjLuqMqsGDWQN0X9fSAcKT3tCsm79JqZ61q4jMvBUa97KPPozUrLPNpV18WVE0u8AqYnai4axHdy2jTMCdfGnhAQF0VHxzr6Wls8VXCnMKQxUFqwuYa9Kg09lvEdD0nUP4xsWA1VAPjfGMCzKaOhU7GM5t5WYyHRO25ZNo8TJ5DHn0Op', X'CCB4C29DCCA14DEDB9BEE1AA9E37D489EBA7B2ED829FDAAACFBD36EC9A8AE094ACE9A69CC5B44350E69C86D4A7E9AD9414E19B8D7CDEB2DE92E98EB3E9ACBFDFB83FE986B1EEBB9469E0A4A1551ACA89D3BFDFBDCBA84BE1AB8DE5AB87CD8AED81B9EF89B9E8A087D4A1723C2EEB8EB2EC98A1EB86A003E69EBCD987D2A5D5AD24DAB80B4BE49B82D494EEB1A5DABDD883EFB0B057C895CAA61B3C1CDD9443467124C0B3DB980824CA99DB8A50D68FEFA3AF04DAAD16EC89924F18C3B5D0814CE69284E086812A7BE699A2E1B9A45A63D2A4DABBE5969DE9A799C7B41AD0B136D49C7D24D7B6DEA0E8B5917E5AD1ADCD8FEC899AEBA28DEAB59EE3A38117C687E29986C4BA2B62EF8583E6A5A276C685253B71E29781171FE787B711C4A0DA930A140DE9979CC4B9C4BBE58898CCA4EF89B33D3E1ED0A0E385A5C182E8BBA1CF8D', 'value3', 'a,b', b'01010100', '2025-02-26 00:38:38', 92.33, 69.53); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (2036, 5767, 600.01, 'sample_bKUnO9E6vE', '2025-03-16', 'sample_MdYNeIUJyHJTAP1O4iF93tSs6OPAtUOR03SbUTtdgbZhJYzTO4CobjWlqe2cu1Z1Z6bmDBKw06WCTHw833aImJHaZbg5Tknblqfdze0RMPkCMlaGbMgx1Ohw8rfVYY6rCD1N2laNNTJTMEzMbCub9vrm9OKlOX4Nnwp3SyC6fWsMOrk0gJ4EXMwM5wfucM1X0GgSsAdtmNW6vUyJBkt4uXdoAafAVboNu7iMjMUKj0VX2vqcCiBkUh2toomTughWI8UWYrQkDDWPuTeDyy5v1GnyQwUOAskKicEztY2cFZLOJEfk3B9IMTd6tLIsUAzVAH2cOJjbeKOpn8s2dG4cMhcwDdaYQTSo6IL4akCFoGwI1jopZCiFpvC8hhV3xyhWadMVDIiWKOTriEAUcV6aKRwGo0qJ8jNcwGDivuiMmlQVXrsHj4JK1lZL9NtyGu9zG7x1nDstGlRYZfafcz4cYAcbGg4193PfKQq7VXsyRSElnqVlMOG3cdDr7RTjNkTvEVxyXK', X'E3A9BBE18B8CC69D05D1B5CAABD3A5CA92E986A5CBB2E4AC86E1B394E6B2A0CC8527', 'value1', 'b', b'10001010', '2025-08-15 01:51:14', 11.32, 60.45); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (1141, 5505, 558.70, 'sample_sJKYBvl2SH70H', '2025-06-08', 'sample_zjsCtWR0ubxSbhcOJbIF64vhjLakOV6EuGlCrLkYAPdKwoKGWSxOKKh1O1oekdnMwPwQ9Hm7Feme2RSfo0HHhqKOouagQ1SodJdoJ3m9Du76UMBQpmNt7TmiCoUT56D9egymdxwTzQkIYwwOR29gFtfOZCaIZnVOkRFCw8csu19I7NKMAsUfvpwmWc8le6uXbK3tbKgpCN6BTLKQq4hxlISeYjsA0Vx3zC5sVuaBvZpuy1ddpXyqbuVTugwzis3nipnr5ElUeTMl0s4d1zFgjECGL0mYk7Zf0mUBOOGyWmcWR2J6gamjUd3ZdwH2mwS2CB8wOV6hthXdrbPxO0vaUtGZv4tIkR7woLP1v9DpEC7mj5nzNPVH4UvD3F9F7QskZMEpD7BLJWNdJdVfTj8DyHjvVBySlEHCwYi7q0kZKTn65Z0FPUcPw8709LxIjdNUBaeEVmZPbY4XPBm3Glz2fg8bZ3fQ1PMQheGDauVPIdYwqDTWI5cc0NoyiSYHxVFNL4BQQHAjhWOtBdYu3d5bTpSAZr4utaRQlzuAvS0ZRmCyHQUPsKynoB2YkzBFyA5PjzZVWCgjfpeiwhatdAEfHAfpRuhTJrbGXQiadqPuS6QorfDOnXK2EypkdGb6raDHMhlwxb24NOIc6eaTL9i5rnjbGldBrlOWHnzD2fohJ8t88YySHWchpfu8fPS5iHM4qpgAaaYW9hAlRgljmN4CDRsCCBHgB6GiaNLfkJugV60UuZrwhhRBzdytOLigLcCNsnbNFLEdMZs5gGExxhwy93o4Qlor7wjZrv0EF3ISu9RIynqN5PU2F4j0kHDZwdX4EQmxOlo40giiKvJOJ9m01POZEiXLNWMbSnWBqIF9DeCBmoN8rBy5JafLUV67Jbp9hiWr50tc9GybRIrpj7DVVi33ndCxmkAE3jQoyi8NJeDT9HW43f9xGSvfcPwnZY', X'C887DA8EEAB8B0ECA684D2A6D2973BD8B1E0A2B5DF9965EA9692D2BC26C4BDCEB4304AD59FC49230CC8EEA8782EFACA3DD8977EEBD9ACD872624E088B879DA9BE984A12BC09E37E6B1A1C38BE3A3A8C5A0CB91E8AA86ED8D90E0B49FE8A7ACD6A9E2B89BD888E09AAF4DE6B78FE8B99EC799E49F89D5A1DDBBEE858ECFBCEA9999E79CB2ECAE8D0AEE8EA2CA93C8B02DE880A104CB9BD8A136C0B353ED9ABE79DD96D689D99D7A6E7159E79389CA85C790E1998B', 'value2', 'c,a', b'00011011', '2025-03-17 20:46:07', 0.97, 1.83); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c9, c10, c11, c12, c13, c14, c15) VALUES (7163, 7276, 772.99, 'sample_R42gUuqNzN8DzREqFdmQ', '2025-03-14', 'sample_zBqIGrmHpsYGgw7KHhPQ1HqIqeuVbwlswBFn9azzBhX0hALuZ1kK5yS53vANcAPf2TSNltUduMFZkVudpFUltm2WD8AeOcqfbK0enyvNlSOv6uvKOJjJ4XovM57WIkhWExGivpNMNyE2qwGfbs4djhnddOV145EWHuXonhLtFYHQf7k09F3QIm8dBoYlgEt4kdLOq8AhZY7RV3934xK4jC7ROXvWxELVbSMkWlpkLKtdfIgCgdfO5ncv1VVoCVvcf4ekw5hbz9iSk0y2eCyJo7Z2Pbx3m9GKDZ5kjNp2El2locg7DNasOaLuvfd80vNLuHmdACpJ2OSVVDcpHzGWpmtrXgZJXYiZSu6SByZgwu51Ntxn9Yj6TGKMfrDL1PCk84M8K1E6HweWzKTmQf9mIn0ySF1yUHmFY8VFTeTBb4q3Kn8otshzHhMBcUOdfLix5ybpIa8mw9Sfn8wY4lAkZxqSXvn9IYei1vwN2tVq3Zyu8ft5HnVpcVlchCu2oDJsJ4ZOOsWaPVqsDaZPUU63jJlHibzBCipRa4ruaNuFf2v7M2nbeBEg9rrHKSAVVrp5Ze6QK1SaRWkhUew98XedeYGWGqyAHOIGdz9kiQAskWGluNnQWJPNNhOvB0YrirG1AeLxSDbPVphsXVZVIhivC23d35THVitjPdi0EBSBbAmQ7GERl1R', X'6FD7A3CE9D43E8B4BFDF972EC995E894ABE0A28BDABBED9DB55FED9EA505DCAF0CCCBCE989ABC395CD9E1520D79C7743EBBE88DDB8EDBF9465E3AAB2CBBE6CE286A2CFB1300B52CAAEEA8D8B547A6EE4B282D39B5FDD8FE093BDE48D99DFBD50E3B49D5963E48D8DE4AF82E48097DEBCE087A06FC78730E68E8D15E2B19BC09FD29A5E294A68DD9B27D18DD280E3A2A525E3A385E0828A7D5818EFB098CCBBCFB8EAB7B5DCA6EEBCA3E0A9BD782ECCB570C494E98BB076D0A2DC996B3426D9B562326A29CA8EEFA89C16DD8059D28313D288D1A4E0A387E9808BE98F98D699D3A676D1BACCBBCE87E59ABF02EAA098ED9EB7EF938DEC85B0DEA934DF9FE1BA88DF8769C0900DC2BEEDB6A640E3B89BEAA5B4042DE38CB36DD691D2A35A0BC28AEEA2A4E485ADEDBAACE8BBBFE0B6B6CEA3E1B582C8B405D9B373', 'value1', 'c,b', b'10101100', '2025-04-25 14:00:25', 85.74, 20.39); WITH cte_565 AS (SELECT ynt23.c12 AS col_1, MAX(ynt23.c9) AS col_3 FROM t2 AS ynt23 GROUP BY ynt23.c12) SELECT DISTINCT cte.col_1 AS col_1, cte.col_3 AS col_3 FROM cte_565 AS cte WHERE cte.col_1 = 21 GROUP BY cte.col_3, cte.col_1 ORDER BY cte.col_3 DESC; WITH cte_565 AS (SELECT ynt23.c12 AS col_1, MIN(ynt23.c9) AS col_3 FROM t2 AS ynt23 GROUP BY ynt23.c12) SELECT DISTINCT cte.col_1 AS col_1, cte.col_3 AS col_3 FROM cte_565 AS cte WHERE cte.col_1 = 21 GROUP BY cte.col_3, cte.col_1 ORDER BY cte.col_3 DESC;