Description:
after adding distinct bit value change unexpectedly.col_2’s value unexpectedly change
mysql> WITH cte_162 AS (SELECT ABS(qvp52.c15) AS col_1, qvp52.c15 AS col_2, qvp52.c12 AS col_3 FROM t2 AS qvp52) SELECT DISTINCT hmn40.col_2 AS col_1, hmn40.col_3 AS col_2 FROM cte_162 AS hmn40 WHERE (hmn40.col_2 <> 43) UNION ALL SELECT amc36.c4 AS col_1, amc36.c3 AS col_2 FROM t1 AS amc36;
+---------+--------------------+
| col_1 | col_2 |
+---------+--------------------+
| 53.9600 | 0x313036 |
| 85.9200 | 0x313638 |
| 84.9100 | 0x3536 |
| 39.5000 | 0x323438 |
| 87.7000 | 0x313339 |
| 22.6400 | 0x3635 |
| 79.5700 | 0x323135 |
| 36.0000 | 0x73616D706C655F76 |
+---------+--------------------+
8 rows in set (0.00 sec)
mysql> WITH cte_162 AS (SELECT ABS(qvp52.c15) AS col_1, qvp52.c15 AS col_2, qvp52.c12 AS col_3 FROM t2 AS qvp52) SELECT hmn40.col_2 AS col_1, hmn40.col_3 AS col_2 FROM cte_162 AS hmn40 WHERE (hmn40.col_2 <> 43) UNION ALL SELECT amc36.c4 AS col_1, amc36.c3 AS col_2 FROM t1 AS amc36;
+---------+--------------------+
| col_1 | col_2 |
+---------+--------------------+
| 53.9600 | 0x6A |
| 85.9200 | 0xA8 |
| 84.9100 | 0x38 |
| 39.5000 | 0xF8 |
| 87.7000 | 0x8B |
| 22.6400 | 0x41 |
| 79.5700 | 0xD7 |
| 36.0000 | 0x73616D706C655F76 |
+---------+--------------------+
8 rows in set (0.00 sec)
How to repeat:
DROP DATABASE IF EXISTS test;
CREATE DATABASE IF NOT EXISTS test;
USE test;
CREATE TABLE t1 (
c1 INT NOT NULL AUTO_INCREMENT,
c2 VARCHAR(255) NOT NULL,
c3 VARCHAR(255) NULL,
c4 INT NULL,
c5 DATE NOT NULL,
c6 VARCHAR(10) NOT NULL,
PRIMARY KEY (c1)
);
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 t1 (c1, c2, c3, c4, c5, c6) VALUES (3584, 'sample_AQJP3FCb7PX46hF2d3VoKsPIHtIgzieVgOK1Ue7iSbNProjjh', 'sample_v', 36, '2025-09-07', 'sample_J');
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (994, 3423, 181.05, 'sample_wfxp8dzD7XrFnPLzr', '2024-12-16', 'sample_pVtuVRHgHyCTAdMjTX5uDmgDFTTcRtYK4MA3VzWGhxyRAthAan095ltHnWC2wZqFzmNIz2BhrrY2h0fxo8UzijtqT3Qzyc7ydCZ760AbwzyWxKRhxPNIiXBNmglw9ylwoKoF0Q5QMAuWKKHLT07TyALEjZEq9SXDPPHZkG637npBmt2TKOxONpcXFVVrsW3jgaSAVhmwZMYON8YAyhzkhs0fsDZAohNdcrXeb43HI5de5EWnnY2lj8xyjRyfvWyVnBrhfeRiVnwUHuk0bcwoN3ueyVTRnXwQSF56ZbxUsw4hUmzUQ4GGRNJqlHOzrdMFLZHnsp5SamGZ0WPFJC1Vx1RuAnB5RdThXSIL8o2Fgebw5VIlETIWBvsuSQqrlbUxl0DbKa4xwcIiP23T8cVxdUgU4xKNvx6nab1kO47gdMcGoSGyXyvr23yKaVpjtw6XNe0uwE6zNt4nqZ1IMHxo', 'sample_oIxWhZ5PNoCnBUDNNG1t4uGQ80Jm3dOMyFRe0xsG8bqvWYFDuMqCy715ukwGqx4YD0tNg95vNkY49I1JPAbh5BBrcbTCYpkH1R37hDwaEo0Lzl91rc0tCeXUzOy258wzk7DX3Z11LNDgWU4awzLAAqwgg6l6QUVNdWbDUN3MQYXgivI8FcfivR8MVM40OIkt9fO8BNRyM2wTSSdov5M69ahQHUactc9lQyhXQfKFssG6OK2qKe2LIxK7FT1nHxPTNh7d41fB2bHcrjQ51tWpKJcLUFVVansOZC4fsvYKAamSAEMg3CsdHRNxw9dNCn5504tI75YCiAZT9DJEv7eTX7R07OJUaKE95P4VCs4XzftyMlVR4sPXkCsh7k7MYYBRd5d9iJdQLLOKXV3FUX5qjMRwF0oltoDkNGhVzUwlRuOptO8ROwzJLwCo5Zc7ce9l3bVoWQ3LsFymuRfVPQNPDkec3GZtAddEZBmIvzojWCpi0vhTzdYojxEdQwMHomRvrrYI7XWkrLrOOYwgMnPfHTeyO9oBFhEksiqIvbJHAEP2xCD2J0NvGcap1lZc2ueOUe6pJbZ95HmiFyRwwxMOxfLY4VCD5vgXNZTzeP0q8G0caUPPmLnaPcrw0vcnvR1gJnPdl8YyggslnNMOFmhPU2TK8EO5Xn6QVpvb6zPaM3Bw6sK3u10cw3i3jPuAYGSdMFNIdrU6L0zMUiI1LO4T7us2MUaXM', X'4DD6A6D687C6A9C08CDA93E9B48429DAA8ECBF93E891B67DDEBCDEBCE79C8A20', X'CF8CCBA2C880ED9DA9CF8644ECA5BD53E6B0AAED898E10C398D0AD', 'value1', 'a,c,b,d', b'01101010', '2025-04-25 18:28:30', 90.91, 53.96);
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (9219, 8711, 166.61, 'sample_b7C1trecK6yntdY4x3tkM8epFQtYVnoEfz17wiJ0h80', '2025-04-12', 'sample_lM7ywI1JmA9kqk0PwSZZlxesXZdCBedJvwYKBw9dR56w7WO7DzbB1ZVsW2uBiEHEd2wR0zfA4sx55xrLO89GGMf4F2mz0UofYA4LoqJgyFeasOQ0xqixQuPntbtFFaU0qHyeuRqR7GpKm67SSQeJQd5eZ7q71APzN3n0zFxL9bC0jVQUAA2zi4LuWSd0Py4RHM12FEZBN1KuHU5ZozMhLHirnlRKFd0CHuHyUguieTnEjt89dxMMgaDrETZaKHVR1ScgTZefc8hb2Y5a2zsDfzRCQbzUBuZhyxWPDkLMg5eJaLJRAGHMN71OJrpgGZCWwFkmvr3GquST0vH8CnT59cLY9O9v9udhzAtGCiQXbwB5Lj7KzeYHgjKr8X09e6EGFI4JxrFhFkCd8iyB8xSq8NysRpDP91m9AphkU', 'sample_pNAzvJ4VjAPSdNguloV4eVG6u3SzZdFFAOuhhV8Ossq2cFdieqfnhqXkFI4LI0JGQzZWBzSMVDPHQn0Oe3Nv7stxdJlPAXt4VIQTYH9MOQAhXAyMAoxBstAK6oYPsTItXFJytGz7Oa1izmP5LLD6Y2iqWh4faPfdfuygrPwm5cfs0z0bRCMeY6uz7TyAS0YbrZIi7JkCnI785BsewYQPZo7xjzdS47d1oKj4EPSzrSKsyoWNaBR6C1MRljtVdfaDibv5fO9sj9N4QHy0lP29cySiHWUKbcoGMCWqTOmi2c65M232CKXKPGJ1miY9cIhuTTZD5hGQqKQ6uuNKIYLIoZJ1mXCoZyJ85k02lYVhV3E0tlr01DgEDkpaICmjNTzVw35Zc9sU3JJCVlWKLa83FtS8kX3lvVtmWq4G8OWgzaOQKt5dw0H04Ibqj030OZQDqmj15XiBFAS2nXQunJRD8Kx7EkfsAG7FfyIz4P5wqDFJpSKziR8OmR8TZLmv2EVQUltHdy45PCO2AXC4x1sIfP9dmQ1aiECO4ed7urHtLvAZpow3BBcK8VgBugkQxVFqIrXg3RaziUH5wl5DoIAzZmMowtn0Vu2ZpGH5Zdf0RvhFUlAck0tL497tGQydIpqGp9PjEKf6QUCAB3ls7R2XPJaIWyS9U', X'3E00CE8341C791EE918038EE949521C58A15D0B301D3BBE09EADEBBDA75BE890B0D58D53', X'37', 'value1', 'c,b,a', b'11010111', '2025-01-23 17:58:04', 97.71, 79.57);
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (2340, 3423, 789.64, 'sample_JtpdkPugJClf6wBGA48lgU0DFFQny1d', '2025-01-19', 'sample_7R6EMmsSUYkMz6YCdnJKFiZabj1AjoceqELoBIvttyuANntWJL2Iguil0ggBEhhicCIyajZZCbnYcoia8z8m2xhobdtGwkvfOFQCJYstbgEOwNRMKP3JikRrYTGn6M16dllazrq68Ih1EE6ZgTAYVDzjsMXfYMHELWNupyYn5JJzpScnf9xkHTtu4IoNR4WeVzHt1nzkrI8VhXULipuUH1s9gmSc8Pean8HlBr9tXw2vG5E0N04ZbCricxniIf4xVAEc7Q8n7hVRH58ZsdYOhX', 'sample_xM8sdczNil1Jx36fI84ut9oSzWu5SqPDfYZi4oGkTM8e8szvLvPuJJV7ufUcfdPPSCnEVvClTOLQ4ggZi8YxN1ng6wu8deYRQg0vff9LLvND8uFplp5QAnaMFC6EZqlG92QyIBhLAPkq7AGh2QhQLCJwkeeqDjm03qJP7KPQ8C2ih7t5qJlHej24Bf3cBjBUpvJBNH1DtKhxoShGleC1Zt4yYWgEbnSwcHJTYy039h9MmMX0N18zFK8lgYMF4dQQArfoRoaNZeCzjGwWjbRmljfJYcynB7lrY9dQOLUgXQYICgCpQwSEJOO5VON75FroQixq0lJqw30iNKPCfGixCzj9NWZ2iafZo21ODDcN9GFZWpmpmRHIw7K7ivk4gPoEg2Q4Zdfv6FIvQcHVBPDtGwHifLxE3wj39CMEieAxj26kkyPwW2hsfys6UpnwLrjgMtdHetTMoCiRMjtT1r9f61nrBFnTgdoI7JOVTv2dnoOzQkBeYOrpQB186iI7MhBiGCgsoDz0IX2xaiuxQvC2BzUk2ZxOhZLwcbVm3xtdGzyjHvNKevZWruXIoRpg7DOF53zANQRRQ4qFlPj9NySq6ejLvAnppkuq1YVk9zSOnpSAmNf7SRNXjA6O7BwwwKuzHfEafG7JnZOgoqDDCE8Qy7cgMc3vmnndIVuiqZOn5eRWi69Sx1rMo', X'E4B6A42FC3B5E9B69AD0A3EB9DA6EF81A0', X'1CCFA9', 'value3', 'c,b', b'10001011', '2025-03-23 19:05:28', 76.33, 87.70);
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (4869, 3575, 142.83, 'sample_kvsDX71mAzReVmNhu7QiIsYUoE1SqxJ', '2025-10-06', 'sample_b2tJmbEH9Xv8uteXTPlST1X494SNpmvVq1720v7FGVRUf41HkgSGlHbdNDi7S4PUIH61lxw0fiBgWUlzJnNFFDDgA6rX48IWKuLWicZi3wOhD3YEvSyGCFy7AwHioanfBtXTqGK4lD0r9nTlUseyOO7YrWuynM6l757SbVZDUxv8Xb0oOHTMdwCulS7qmmYiJ6dwDSt8QGPmDvGMQXIrAThu06uVm5wa2nAg7bZe7OoPQ2VUbXtJKgYrCykTHK6eLVFYIs3tuenEamv4JvpqK9CVev7dtbHcvJ04YIv0VxGHElQwSDulhjO3xaR9mfyAlGK2PvjQKEWn7gFmNGwVVZzRNVV565pGEz4ozE6FKhKAxyBn49WCeouwUYI4U5DypiohZn16snUWj1nEMSjddGGGxgEuNFDzgAHV5ETeV1QTI7lxW1iCDJnsdkFtVlrBoaGAn8NRmP4sf3wbRIIGaPme4UPyjmFidD5mTclXdlp9RWJx6vAF96w6Vv1lKBEgcduQ78FXrzXq65hoRcYL8gzdvI86gUK5wRAGvsAzHzqlUNtEG4NWow3YCgwms0Tji0H7PxQKv6mfMrcAKIa6JXkpg0Z1VMBE8XNVm0Dvu85YEVbkTh1C05CYCitNZGSMD4d9lLhdCCdHAKPfEpJIjiYdRxB5Yu272TQDTdm7TEECixCoM4HqKgsay6q0ki94LgLat1M4iCoEA5znZuhPeBkWKINW01AMfgU7pPqhZWZKKapcNYJ6EqpuHP0MmDKcsx7bDd4dak7NpWSjG9pZ1AZAqi0eUgNaYPRxVD1kuRV16GD9Q6djkqwnhtJJOMH0iyUSzy', 'sample_yNZHZaFHLQgwQWXReALBSnzD7MedQ4MyNNoq2IkJcCBII1LsMJOxWnghWPoV7J6OioviMpRvYPhL5nVVL4lMipjQ8KMx1Nvb8lnAecdyZI4wjhOrsfTycULPar8lnvNq8LtqlQLIQ11yXh3m4iQmRQ02IE2j58K41wh5fyGhNz9TrpFSJhgNx2F4ur3QdqtXHwaWRUgUdIJoWoxmOO2VbaitXDUbHOuJQ5tIYOI5pGckmQ0Vvm5HcO63qGRVcI9dRsffTbVewbe8V9ILyVMVsGPLZtM6oSvbcJHmMHjQ5yeykw1xD4CXVPQ0akzZ5efk2xSWljsMPMMipqvWhxZ7bJAKQmEjJlqQxT2fpipbyZW9cQP8dPZJnENYgzbS95yIb6bfyM8W0rGKrfPQuouljwPS59KgjnKQnfoZhNtO1E1xPe545PknJFz54tjlBWrXqZddEJzhIDImuOxoCUA3ufUgW0yGWatfRF42ezcOZ86XAA5RBVGHyvcC81Co1T5HkOXKFt8ezOiJm9NJL2oglSgYmmWeGusXjGlfW2TZsZ3wIiihLAzhHakzBeNRzHkMDxhTZKpMh6ffzCbbx01w7Q39AJq56cARqTSVnezmruYNpbolbJW80TmA3HLre35IpFzwWXAnskRLK3pK0n2cS8Me1DOEdex8oOjt5xexovpSDTXjfP0n16NKfnN6mktohLiEaSQD4BX2TUPK1Hq27ilJVvrgWGmMTBCMfJoIs8slcahobaEaHenTQf8z7fFIOKSxf7Y5KGKGxRMYZ0eFzWqH93Vmxy0HQqZdrn3HrDp1FzeL6B7Fs414VEVG6MmXTE406DM4LprcOaIBfWZjrZfix3MtWhrTH01GQfjDEXnrmDNoS3d6CjLcfrXDFtUGVkq0JZgnGwt1xMimL5kLHwkdJstZfinf7u97PoFqQfLWpJB0YymynZqiMfzUW8Ob7JWu4KbbsnVz6G4qUsYgYSY4wxPKFfXH7ZfNamHiH4z3AQpGQzEX5ndr1ZwNNDKQzmGKbajKJ5UFeGqNwkytRDIMQdf1f6GxRUYtKYGXvrB1a0U3atr2OuWQAw2LqTbEBVlLAaEg2h8uuqsCB5LfG8NCk3vnHjQhY7IuNx7NAEFByTHvowl8WYBhKfkxzaW3i7S9sepXb18okFtcmBC8nUMJjSU1f7fIsQMBgGJaa3w9Zrl8gVk9MtiJ8u8BjelfqaXb3kf6obkJOfTdXtscFpimU8vuzf7CZPq8dTbAkFzLGbIyNigXiKSK1fAzABEn9qowlSmWstEoOFrK8YfK3k17ZKdrnwBOaayXyS5xTOPZtUniNo2xA6Q9kRcLeQt5pPxqxKDsqYTj55Q6tJ4qAkcGx5fGnOKlekCaOCKBmmz2kXpdgw2Oj1nAKZDD2H5sf3Ft72qE0BtJgmmrONar7PQSVJoDXiTG1IhN3n5OdW9XzV3V19Wr5dGg6wiOiVCyfIBqBw0QOsiA72ytK061bEPeMZgVb0bIJ8baepvqsB9PSas5AkTii5hVyVPSyu3gbzxWeomK8v0mAru84wOw6gWCvtFwrtb2npkR4acPVBFSgSXOmkUjS16uuCRHlePnuXlU5Ui0ZBADCbF2UnVB1Hln6oeuIe7udCnV1NUb9dmiOpYQjpnBEntitZii9cdh5orHjYzX86R2SeailHTHKlsgsnItuzhPfsjGhYYp3NsNQStB', X'3D1AE4B784D7AC78', X'D5B3D18ED3B57BDEA87764DCAFCB84C5B8E3B88A46E09A8574CB9AE8B8BEEA87B1E4A8A4E9BF99CBA3D68DE896AA4C190F', 'value2', 'a', b'01000001', '2025-06-18 19:15:19', 8.76, 22.64);
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (1830, 3584, 983.64, 'sample_dPiBN3CgbQXn', '2025-01-31', 'sample_vmOgQX3eh6woZTt3aNV0fq55qjVrLpBVAAhaYvNBYAeR1mA30XaRZQYQ1kgy7z1QJvy1MLc64QYNI3hrJIOiiAL8W28iE3Uoomv09eV058D9YoVS7FvIga3h7F7PPbNfpuau6TMJ4G3N3nsXvhTUnFMUsPsUHWucmLkAkIQvzFL1oB5lmIB3rDzeMTjb5eNsaZ7mQM5JKaOfF4Cu4KRGWC1J6ZLrHS92j1dVUp26mUdbpvtguGJN4FVCQC4fJIOuVO7Ow8nHq5twCWPfk1YsEbNQS3bXgyIoxIHhq53ZrYtBK9vJdgxhCHEDk9MLzEQeh7Ncitx8dZE8VoyW9MszIqDbwCg9xwen3ew1thD5TTYJocixCkAVygjivHtZu6yJnOGmxHpHRiukcd7RnLjdLR9RSsygMn6VRjYLQ5OxQayKGziX8Ob11prqFGuSnAKV7iSC8P5n5mHiQJKY2SKpFzKNdh7WMACfMv3pw71xtMp3lsZWPcg2Si0QNJJ768Ce98MY3futDqUQCUXL3WzItP8j31n9ajyuV2Sp', 'sample_fBGXCMkcuMzf36z7sXefqXGSwAUvNfnLCWdDXJyjVWrTr332CS5QHzxFzgcozBcYg2IFYZ3Rx5b1Ux4IVNWqJsG0IqDrTgNaoPYb8NdscYWTDmad7QMYjbpptk8rEcM5hLT2a5VpFpie8ZaCtnMMpwr1KzLmfHuCF7mXKGWbSRFcM9ypn6dfFSgSBBiiFDdtWzMrvREzGvhEF6T68RYH8hMzubRsbjsiSsRHAhVoYGLjC8WttHSiCm2Oc5cnATjNlcuUCPRTzDdMJEG3WCG3GLi32iO8dk27EvmqtMHZYkxop5wqz6zixVJksgoJtPJhzDt39jmwHIHK4dRC1EFFHI993mo6j6kxqJWkMe0hcy2Xscn51f5IJutYIBtXSTpUlDqO5gCfzDn2RASPkIDvrvgjMJ8zgi14HsW1lqPtAUxjKiHvIxc7TtWP9GTJxykRPaH0jzuTm3Jb8cXdljFym31gz1GpIsyzxkHEwytOZE0FoARvB0d5yGLhLk8odFWqS6U77LX13cCJyJ0vFhotTUkJib7lpZqJZD6isVywt63hm48jVdcJIs0RpU2HpLXzMVQl0m3oL4PFaSfeV4aCx4JJCK7t9UNNTQy9Bq4dusSgJHcT52ED1xkP9fbvsC93fOmi1eopUBs3mKAYINbE2jVPLDQoNcbVb1C0u6UaxUZJeYBmOmhERZcUlvb6B4SoXGIpnC3qD5L7jJQAGyV5PzCLOJsZL273wzDjXaMXXCjMLQQrUEtQBgULvnBQ2gkgoicoPxdtvrRC4a9pRMxWnwddO6nRYoxctKoTk6AN4EweE9wZgLFwXHNI8nUVbHi4RQg57VBTa6Avep7CgXTevBWoi8LDmJVFIVBPlYx6ElPW5ui5oc6wun4fZSJYWOhVn95w9W9depE76CB1w4ZQasMzq3kvE2gHvanB3DqiwYPtqjIGsxIPxfdE3B1tnOi4SmF0PI4i5lH4DEZhqoeTbNSWGPS8DrPp41ULYzltRMDBO0B0CaYMXCozxqUdKd38wUbKV8NF8qKKySpwRPkRrjygPkb2nQ0YFxwVS4HD1PyFE61k7XSYihVJecNf2iqDka2OX59DUXloitue9FWIuy7NuXa7FvT3ZFjrwDtWmS5SW1rPkRrl7k4j4k3jcdeXDuNTBz0VqY8wSgSPVx3pCCid90xvOhPzCzl8gXZkDJrYxuV0ViGaFDnphNgC5PTfRLopufAJrrXnouK8Q1JcgTwgGpcD2uQGjbf6CA8jUCkigOSDNF8dr4nEJfDclSn5borOR5jy1kFMgbzlbyXUI2b1TaIdkOLSMfL9dBIDJm19KfItM2qwVwIiwGyOnUn9i38DMJjkBXgee95evEKPyCG1eucwgIhTWWXEX7X62PtXoibUAH8LJFt7PRrAh08b3057w68coqJvA5Bkxp9RkC0XIPxAp2TZRJVyOQu5w4PVsliBC9NYmvTfUTq2K26rj9oHhUPcR19Ib1wf3Y4w2UKl49InpPEQsI7mj1P7de8brlPoTTn2xrNhJwgpnilpL5ttMxgXpPDmAXm4Jr53lhf3ZJ', X'2626', X'56E794A953CFAB30E39CA81DC98552E58B9D74C494E5979836EEA38EEE8C9305E895BCCFB465D49FC9BCC8B0', 'value2', 'b,d,a,c', b'00111000', '2024-12-04 05:24:10', 24.29, 84.91);
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (1159, 2015, 785.28, 'sample_hmgYY3osvIoyPtf7x8JCxaEg4Wrld', '2025-08-04', 'sample_maZ8HwjVvqPV9JUAqHLU2k14jWaUj9CZ33MuEjYe1JYwcAuN949ycgRAJzXz9pwy2UClE48Rfqw05HOnyI5t6dgsjXYqGyIL5gXN6d3OngfqUjLas1Nk4J7eUtFfBdP9bab8OOvi4qXaGweeWK2jSt4SWsPCfeBcynBHCemiZL4qlvv6AjRAq3MJuBejxevV4Pai0bYwmWGrjyPAwyqAjIwFRN7Wd90eIhmRvczKl60nzHmXDzS3OtyiQanMKG26QhMp82RYKxf0L1liqaC2sVBwh8Va1u0Kskpq2QXqNQWWNU25tqTA6ZliMPMSkDCDFkirpRzfFuSLolPwsFzQpJEoAbSt7LhSipjclYRyBv5AD4Qa', 'sample_yPrgJHgSEFM4dVCTdspg8j5CjtgTCPIOsesjXM32XJLmNEGXMQ6WfH1do4q83xMByYeZibXejW3zSoqwFzUZpY6wlDa7sW6A4gYlGKRq2d4doorSybFiVs0cQtvi0gghHLCCKAC0ZTRo92AFzXJiZcxMjkYjKSImASBQaw5sPoTNplp4AZDRhiGGRkej9urhBm67RLwYuvpcmWNmnwkpcu2hseG9EPLhMw7ggWcZwoS3ekKHaRd2tuqXR2n2GAEAV3DBdxnyKUi8VVyV6JF3uxmJSkO7hsr0FpWBu7A5Hy6ZaEg0x5K5IjUhaeqamsvMr4yNNorW1T1xCO4QBzh7D6nzM1BP8csASxmJuMPi17WfeSMhtOUHgRNdpLkatedBDp74jc5BRN5eleHVtaPSztRHv8VMTnvNfMbjONa8iKAwZiCcfwMxwQoNsUdNbvfbO7oVM2JbECgolMegZvOR9IHrqKKwXM5D4a2P9mJy0mN3ul6A9cM33gVAynHN4h1g81KZv0b55mGhkKk1IfSHDbc5D5mp4QQsckks4w0BNITiiSuO6PMVmlZ9I5hwrIxDUyPVaxinkxsBhP5EGNxKrwiWChDSTB5BecGUjk4jinFwGWYAx2fkCfBhKhgcyWvlDTutfZCI5HS1awiatwkc73zdR88wE2ssXeV4IrCQqd2jE3waj6LTbPam2XBTLKrOBMa72T0bDwL5gJkIu2j5mB0P4HlvGwKjmcBtBolPcevr3Cf9fE3nDphHExAmlaNfyAnTd7DQtApcGG9eabZfA8bqUipCYf1P0pf5u9DOuH6hfw8pVs2JSkkDrcwe61RbGsONoZflQtqXacqdil0kgpDCne8JBfX3LZt6RTGPMPqtIyR58WNYHTsozw95XPDvd3yt3I3Yi0Cvv3xZyzmtSO5PzdGHMgxlNUUJvsL4POGXGCmtLSthSWSXOujwKTSyESm41E3VPYMcGW25SxOFeXzui4ubFNGFxFgW33vVBpyTbeiWIQ17FSiMK3wzuQSmlsykE0qafY9C0vf12u7W0qWxuFjDxM7Ah39BK9Isz9eX55e16OWO1liV2Yadh2ps9fKAuyncWGtIo0FJBiPO9sNGuslJrpH1RJ8Ni9kmrmDfdzpE9H99Q3dat7DjECajFCd3R4o5tpUhLp5qXjvWCwfKUpZAYJz1X6aLU1830CmtTn2xazDC1dq9go0NN5UvoLRFSMGQM8nrDh94v17rypC8YebFvHYdL1zAWkiJj71FdnDtPJMw4cfHNEW6NXrHtUCMYgputt8yxqXwg1yDyNbuQyvv', X'D88EE391A9D2B3E2ABBAE88C96CA8B2CC3B0CEB55AE89BAD54C59344DAB4D085E683ADE88CB904D8B3', X'E4B59EE9BD9BE787A4EAAEB2E983B3E882B8D5BE205FC583C38EE2BDB5C199', 'value2', 'a,b', b'10101000', '2024-12-27 17:14:38', 71.52, 85.92);
INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (2120, 4556, 261.49, 'sample_72', '2025-05-08', 'sample_RTCJ7cXFqP0ulTRDUhqPaKaF2U0BUELQrpqjS19OjvN68TBJczxvT3jzyV43orgINYIpKrOpvUJZfKcBVFMGj5m7RRSe6kZM16DHBePxBgQrbOIvW1g6ObbbCRc4D41D1POH6qZqO0YFYFn7oqpdOqhQhYDQhfQl3WsVe8cY29Y95MveUIZo033Em3', 'sample_juw7gwm0vysGzQpBNecGHDEpYpZw2tgwPWIAdLW12JZDrqCggcmeiD1PP3ZsSFAz2uKQj5lFIxSq1R9Qio8TvQja3Up88Y0DsiMBOdt5AzCSKi69EVM7D8Acjn1WChSSHv2UocFzWiWq9km4s5jSr4q68l2vkKEksJfCDAmKX8P5ny0EoAaEWLQaSMtSiqe8sFeXzbgkcBnX7Wj0cypo1udQ9O6dPD9z5ORPk3GS9e432CFWm0ifkaQ08uML9pGV3TG0UyZ3TixxLcjGIJ8iO3eNMGq3KvADaLHLdZygF0sq0Pvas95UEtsmPpcxGUYGRFiOnJIn1rS3m6cdMdVXsyXVCnWcxVTOORIFJDbuvObvy9NH2qv4tDsKBwrZuEXEHEA8Z59CTjkz6dghnnIT3Asj0F6DIIUvMXOBBZ4XgbBYlTRaL9FZEUjjTE4oGEM0DYtEt0563odYxyL9hsnjP0w9BXpYUGOfXzqyD4b4y0RYFkAId7JXz8FgKmbaOaVMxnlPQvJX9GUemeIR71NZC5Cv6PdaFXVbMVwrGihcgzdFquQ91VzRwCsIuYWI7H0jfcfK5IKhaxl9OuoowEqb7cKNKwha3Kcdp6uCNQ3Pc5kmTEMynkZqE4dvvtrKVCXjcAfLcY3yI8sAkYsDrVwsXAhZaICKFEHsgYZAQMZBSNfOCn9k128vDeFoZYK9ClUGAEpcZHGEgKCNMJ7A81Wl0yrzN7yqPqq4yOGOruqlZPTEtbBjIbWOyzOy8VBYRxrOKdvuHrpSJ4Q3w0kBhTTgbI14SauWLQLbKhM5NcvcxBTjsW3UDlKrhzBO42AMtzoTu9imXudn5QyTLGRRotcx5vuhoSj2JP7PxhN4tpBaBytwYy4AYmsnMuXJA9cZsFZIlHvp7f9B1L4pNjyusv1ogFzFyYJuJUwqVcGTD2a6vEOecSB0zpLx8FX5O0tP9f87D4zzQS2kmDygrKGCoWG2GvjnJiQMz0hHQknn1WczXD6GoScT0st6X1UGr9UuwoXcQHkKTTfz5b6ToksdIkUqTMtAy2EmSkcm23AlpViGOv1bD87wxenBA2fRETUISIOlYjJy7YIh4x1I46V2o6HLCYrmjg5pzvROd4GWFNqXGsLBVcQZ44KFKgPp4QmMmGVNJiS5JyrUnYKlijFb3tWR9NgjMy78Bdlmpb00EOVl806VgfgNoIdzjra5zuzTNSDWGVz7CNUteBfRJkokT3CL6jMOmm', X'E1828E34067BDC94C691DBB2DEAACC80C5B6EF81BD3AD3B8E3AF9A04E8BFA0CF88E9AAB73E505FCA95', X'D086EDB79AD186EF9791CBA146DEBAC7A1C2B4E284B33241D3B2EF8A93D582DAB7EEBCA6CFB7ECBE98D186D3B27350', 'value1', 'c', b'11111000', '2025-06-03 05:07:18', 93.60, 39.50);
CREATE INDEX idx_t1_c2_c4 ON t1 (c2(63), c4);
WITH cte_162 AS (SELECT ABS(qvp52.c15) AS col_1, qvp52.c15 AS col_2, qvp52.c12 AS col_3 FROM t2 AS qvp52) SELECT DISTINCT hmn40.col_2 AS col_1, hmn40.col_3 AS col_2 FROM cte_162 AS hmn40 WHERE (hmn40.col_2 <> 43) UNION ALL SELECT amc36.c4 AS col_1, amc36.c3 AS col_2 FROM t1 AS amc36;
WITH cte_162 AS (SELECT ABS(qvp52.c15) AS col_1, qvp52.c15 AS col_2, qvp52.c12 AS col_3 FROM t2 AS qvp52) SELECT hmn40.col_2 AS col_1, hmn40.col_3 AS col_2 FROM cte_162 AS hmn40 WHERE (hmn40.col_2 <> 43) UNION ALL SELECT amc36.c4 AS col_1, amc36.c3 AS col_2 FROM t1 AS amc36;
Description: after adding distinct bit value change unexpectedly.col_2’s value unexpectedly change mysql> WITH cte_162 AS (SELECT ABS(qvp52.c15) AS col_1, qvp52.c15 AS col_2, qvp52.c12 AS col_3 FROM t2 AS qvp52) SELECT DISTINCT hmn40.col_2 AS col_1, hmn40.col_3 AS col_2 FROM cte_162 AS hmn40 WHERE (hmn40.col_2 <> 43) UNION ALL SELECT amc36.c4 AS col_1, amc36.c3 AS col_2 FROM t1 AS amc36; +---------+--------------------+ | col_1 | col_2 | +---------+--------------------+ | 53.9600 | 0x313036 | | 85.9200 | 0x313638 | | 84.9100 | 0x3536 | | 39.5000 | 0x323438 | | 87.7000 | 0x313339 | | 22.6400 | 0x3635 | | 79.5700 | 0x323135 | | 36.0000 | 0x73616D706C655F76 | +---------+--------------------+ 8 rows in set (0.00 sec) mysql> WITH cte_162 AS (SELECT ABS(qvp52.c15) AS col_1, qvp52.c15 AS col_2, qvp52.c12 AS col_3 FROM t2 AS qvp52) SELECT hmn40.col_2 AS col_1, hmn40.col_3 AS col_2 FROM cte_162 AS hmn40 WHERE (hmn40.col_2 <> 43) UNION ALL SELECT amc36.c4 AS col_1, amc36.c3 AS col_2 FROM t1 AS amc36; +---------+--------------------+ | col_1 | col_2 | +---------+--------------------+ | 53.9600 | 0x6A | | 85.9200 | 0xA8 | | 84.9100 | 0x38 | | 39.5000 | 0xF8 | | 87.7000 | 0x8B | | 22.6400 | 0x41 | | 79.5700 | 0xD7 | | 36.0000 | 0x73616D706C655F76 | +---------+--------------------+ 8 rows in set (0.00 sec) How to repeat: DROP DATABASE IF EXISTS test; CREATE DATABASE IF NOT EXISTS test; USE test; CREATE TABLE t1 ( c1 INT NOT NULL AUTO_INCREMENT, c2 VARCHAR(255) NOT NULL, c3 VARCHAR(255) NULL, c4 INT NULL, c5 DATE NOT NULL, c6 VARCHAR(10) NOT NULL, PRIMARY KEY (c1) ); 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 t1 (c1, c2, c3, c4, c5, c6) VALUES (3584, 'sample_AQJP3FCb7PX46hF2d3VoKsPIHtIgzieVgOK1Ue7iSbNProjjh', 'sample_v', 36, '2025-09-07', 'sample_J'); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (994, 3423, 181.05, 'sample_wfxp8dzD7XrFnPLzr', '2024-12-16', 'sample_pVtuVRHgHyCTAdMjTX5uDmgDFTTcRtYK4MA3VzWGhxyRAthAan095ltHnWC2wZqFzmNIz2BhrrY2h0fxo8UzijtqT3Qzyc7ydCZ760AbwzyWxKRhxPNIiXBNmglw9ylwoKoF0Q5QMAuWKKHLT07TyALEjZEq9SXDPPHZkG637npBmt2TKOxONpcXFVVrsW3jgaSAVhmwZMYON8YAyhzkhs0fsDZAohNdcrXeb43HI5de5EWnnY2lj8xyjRyfvWyVnBrhfeRiVnwUHuk0bcwoN3ueyVTRnXwQSF56ZbxUsw4hUmzUQ4GGRNJqlHOzrdMFLZHnsp5SamGZ0WPFJC1Vx1RuAnB5RdThXSIL8o2Fgebw5VIlETIWBvsuSQqrlbUxl0DbKa4xwcIiP23T8cVxdUgU4xKNvx6nab1kO47gdMcGoSGyXyvr23yKaVpjtw6XNe0uwE6zNt4nqZ1IMHxo', 'sample_oIxWhZ5PNoCnBUDNNG1t4uGQ80Jm3dOMyFRe0xsG8bqvWYFDuMqCy715ukwGqx4YD0tNg95vNkY49I1JPAbh5BBrcbTCYpkH1R37hDwaEo0Lzl91rc0tCeXUzOy258wzk7DX3Z11LNDgWU4awzLAAqwgg6l6QUVNdWbDUN3MQYXgivI8FcfivR8MVM40OIkt9fO8BNRyM2wTSSdov5M69ahQHUactc9lQyhXQfKFssG6OK2qKe2LIxK7FT1nHxPTNh7d41fB2bHcrjQ51tWpKJcLUFVVansOZC4fsvYKAamSAEMg3CsdHRNxw9dNCn5504tI75YCiAZT9DJEv7eTX7R07OJUaKE95P4VCs4XzftyMlVR4sPXkCsh7k7MYYBRd5d9iJdQLLOKXV3FUX5qjMRwF0oltoDkNGhVzUwlRuOptO8ROwzJLwCo5Zc7ce9l3bVoWQ3LsFymuRfVPQNPDkec3GZtAddEZBmIvzojWCpi0vhTzdYojxEdQwMHomRvrrYI7XWkrLrOOYwgMnPfHTeyO9oBFhEksiqIvbJHAEP2xCD2J0NvGcap1lZc2ueOUe6pJbZ95HmiFyRwwxMOxfLY4VCD5vgXNZTzeP0q8G0caUPPmLnaPcrw0vcnvR1gJnPdl8YyggslnNMOFmhPU2TK8EO5Xn6QVpvb6zPaM3Bw6sK3u10cw3i3jPuAYGSdMFNIdrU6L0zMUiI1LO4T7us2MUaXM', X'4DD6A6D687C6A9C08CDA93E9B48429DAA8ECBF93E891B67DDEBCDEBCE79C8A20', X'CF8CCBA2C880ED9DA9CF8644ECA5BD53E6B0AAED898E10C398D0AD', 'value1', 'a,c,b,d', b'01101010', '2025-04-25 18:28:30', 90.91, 53.96); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (9219, 8711, 166.61, 'sample_b7C1trecK6yntdY4x3tkM8epFQtYVnoEfz17wiJ0h80', '2025-04-12', 'sample_lM7ywI1JmA9kqk0PwSZZlxesXZdCBedJvwYKBw9dR56w7WO7DzbB1ZVsW2uBiEHEd2wR0zfA4sx55xrLO89GGMf4F2mz0UofYA4LoqJgyFeasOQ0xqixQuPntbtFFaU0qHyeuRqR7GpKm67SSQeJQd5eZ7q71APzN3n0zFxL9bC0jVQUAA2zi4LuWSd0Py4RHM12FEZBN1KuHU5ZozMhLHirnlRKFd0CHuHyUguieTnEjt89dxMMgaDrETZaKHVR1ScgTZefc8hb2Y5a2zsDfzRCQbzUBuZhyxWPDkLMg5eJaLJRAGHMN71OJrpgGZCWwFkmvr3GquST0vH8CnT59cLY9O9v9udhzAtGCiQXbwB5Lj7KzeYHgjKr8X09e6EGFI4JxrFhFkCd8iyB8xSq8NysRpDP91m9AphkU', 'sample_pNAzvJ4VjAPSdNguloV4eVG6u3SzZdFFAOuhhV8Ossq2cFdieqfnhqXkFI4LI0JGQzZWBzSMVDPHQn0Oe3Nv7stxdJlPAXt4VIQTYH9MOQAhXAyMAoxBstAK6oYPsTItXFJytGz7Oa1izmP5LLD6Y2iqWh4faPfdfuygrPwm5cfs0z0bRCMeY6uz7TyAS0YbrZIi7JkCnI785BsewYQPZo7xjzdS47d1oKj4EPSzrSKsyoWNaBR6C1MRljtVdfaDibv5fO9sj9N4QHy0lP29cySiHWUKbcoGMCWqTOmi2c65M232CKXKPGJ1miY9cIhuTTZD5hGQqKQ6uuNKIYLIoZJ1mXCoZyJ85k02lYVhV3E0tlr01DgEDkpaICmjNTzVw35Zc9sU3JJCVlWKLa83FtS8kX3lvVtmWq4G8OWgzaOQKt5dw0H04Ibqj030OZQDqmj15XiBFAS2nXQunJRD8Kx7EkfsAG7FfyIz4P5wqDFJpSKziR8OmR8TZLmv2EVQUltHdy45PCO2AXC4x1sIfP9dmQ1aiECO4ed7urHtLvAZpow3BBcK8VgBugkQxVFqIrXg3RaziUH5wl5DoIAzZmMowtn0Vu2ZpGH5Zdf0RvhFUlAck0tL497tGQydIpqGp9PjEKf6QUCAB3ls7R2XPJaIWyS9U', X'3E00CE8341C791EE918038EE949521C58A15D0B301D3BBE09EADEBBDA75BE890B0D58D53', X'37', 'value1', 'c,b,a', b'11010111', '2025-01-23 17:58:04', 97.71, 79.57); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (2340, 3423, 789.64, 'sample_JtpdkPugJClf6wBGA48lgU0DFFQny1d', '2025-01-19', 'sample_7R6EMmsSUYkMz6YCdnJKFiZabj1AjoceqELoBIvttyuANntWJL2Iguil0ggBEhhicCIyajZZCbnYcoia8z8m2xhobdtGwkvfOFQCJYstbgEOwNRMKP3JikRrYTGn6M16dllazrq68Ih1EE6ZgTAYVDzjsMXfYMHELWNupyYn5JJzpScnf9xkHTtu4IoNR4WeVzHt1nzkrI8VhXULipuUH1s9gmSc8Pean8HlBr9tXw2vG5E0N04ZbCricxniIf4xVAEc7Q8n7hVRH58ZsdYOhX', 'sample_xM8sdczNil1Jx36fI84ut9oSzWu5SqPDfYZi4oGkTM8e8szvLvPuJJV7ufUcfdPPSCnEVvClTOLQ4ggZi8YxN1ng6wu8deYRQg0vff9LLvND8uFplp5QAnaMFC6EZqlG92QyIBhLAPkq7AGh2QhQLCJwkeeqDjm03qJP7KPQ8C2ih7t5qJlHej24Bf3cBjBUpvJBNH1DtKhxoShGleC1Zt4yYWgEbnSwcHJTYy039h9MmMX0N18zFK8lgYMF4dQQArfoRoaNZeCzjGwWjbRmljfJYcynB7lrY9dQOLUgXQYICgCpQwSEJOO5VON75FroQixq0lJqw30iNKPCfGixCzj9NWZ2iafZo21ODDcN9GFZWpmpmRHIw7K7ivk4gPoEg2Q4Zdfv6FIvQcHVBPDtGwHifLxE3wj39CMEieAxj26kkyPwW2hsfys6UpnwLrjgMtdHetTMoCiRMjtT1r9f61nrBFnTgdoI7JOVTv2dnoOzQkBeYOrpQB186iI7MhBiGCgsoDz0IX2xaiuxQvC2BzUk2ZxOhZLwcbVm3xtdGzyjHvNKevZWruXIoRpg7DOF53zANQRRQ4qFlPj9NySq6ejLvAnppkuq1YVk9zSOnpSAmNf7SRNXjA6O7BwwwKuzHfEafG7JnZOgoqDDCE8Qy7cgMc3vmnndIVuiqZOn5eRWi69Sx1rMo', X'E4B6A42FC3B5E9B69AD0A3EB9DA6EF81A0', X'1CCFA9', 'value3', 'c,b', b'10001011', '2025-03-23 19:05:28', 76.33, 87.70); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (4869, 3575, 142.83, 'sample_kvsDX71mAzReVmNhu7QiIsYUoE1SqxJ', '2025-10-06', 'sample_b2tJmbEH9Xv8uteXTPlST1X494SNpmvVq1720v7FGVRUf41HkgSGlHbdNDi7S4PUIH61lxw0fiBgWUlzJnNFFDDgA6rX48IWKuLWicZi3wOhD3YEvSyGCFy7AwHioanfBtXTqGK4lD0r9nTlUseyOO7YrWuynM6l757SbVZDUxv8Xb0oOHTMdwCulS7qmmYiJ6dwDSt8QGPmDvGMQXIrAThu06uVm5wa2nAg7bZe7OoPQ2VUbXtJKgYrCykTHK6eLVFYIs3tuenEamv4JvpqK9CVev7dtbHcvJ04YIv0VxGHElQwSDulhjO3xaR9mfyAlGK2PvjQKEWn7gFmNGwVVZzRNVV565pGEz4ozE6FKhKAxyBn49WCeouwUYI4U5DypiohZn16snUWj1nEMSjddGGGxgEuNFDzgAHV5ETeV1QTI7lxW1iCDJnsdkFtVlrBoaGAn8NRmP4sf3wbRIIGaPme4UPyjmFidD5mTclXdlp9RWJx6vAF96w6Vv1lKBEgcduQ78FXrzXq65hoRcYL8gzdvI86gUK5wRAGvsAzHzqlUNtEG4NWow3YCgwms0Tji0H7PxQKv6mfMrcAKIa6JXkpg0Z1VMBE8XNVm0Dvu85YEVbkTh1C05CYCitNZGSMD4d9lLhdCCdHAKPfEpJIjiYdRxB5Yu272TQDTdm7TEECixCoM4HqKgsay6q0ki94LgLat1M4iCoEA5znZuhPeBkWKINW01AMfgU7pPqhZWZKKapcNYJ6EqpuHP0MmDKcsx7bDd4dak7NpWSjG9pZ1AZAqi0eUgNaYPRxVD1kuRV16GD9Q6djkqwnhtJJOMH0iyUSzy', 'sample_yNZHZaFHLQgwQWXReALBSnzD7MedQ4MyNNoq2IkJcCBII1LsMJOxWnghWPoV7J6OioviMpRvYPhL5nVVL4lMipjQ8KMx1Nvb8lnAecdyZI4wjhOrsfTycULPar8lnvNq8LtqlQLIQ11yXh3m4iQmRQ02IE2j58K41wh5fyGhNz9TrpFSJhgNx2F4ur3QdqtXHwaWRUgUdIJoWoxmOO2VbaitXDUbHOuJQ5tIYOI5pGckmQ0Vvm5HcO63qGRVcI9dRsffTbVewbe8V9ILyVMVsGPLZtM6oSvbcJHmMHjQ5yeykw1xD4CXVPQ0akzZ5efk2xSWljsMPMMipqvWhxZ7bJAKQmEjJlqQxT2fpipbyZW9cQP8dPZJnENYgzbS95yIb6bfyM8W0rGKrfPQuouljwPS59KgjnKQnfoZhNtO1E1xPe545PknJFz54tjlBWrXqZddEJzhIDImuOxoCUA3ufUgW0yGWatfRF42ezcOZ86XAA5RBVGHyvcC81Co1T5HkOXKFt8ezOiJm9NJL2oglSgYmmWeGusXjGlfW2TZsZ3wIiihLAzhHakzBeNRzHkMDxhTZKpMh6ffzCbbx01w7Q39AJq56cARqTSVnezmruYNpbolbJW80TmA3HLre35IpFzwWXAnskRLK3pK0n2cS8Me1DOEdex8oOjt5xexovpSDTXjfP0n16NKfnN6mktohLiEaSQD4BX2TUPK1Hq27ilJVvrgWGmMTBCMfJoIs8slcahobaEaHenTQf8z7fFIOKSxf7Y5KGKGxRMYZ0eFzWqH93Vmxy0HQqZdrn3HrDp1FzeL6B7Fs414VEVG6MmXTE406DM4LprcOaIBfWZjrZfix3MtWhrTH01GQfjDEXnrmDNoS3d6CjLcfrXDFtUGVkq0JZgnGwt1xMimL5kLHwkdJstZfinf7u97PoFqQfLWpJB0YymynZqiMfzUW8Ob7JWu4KbbsnVz6G4qUsYgYSY4wxPKFfXH7ZfNamHiH4z3AQpGQzEX5ndr1ZwNNDKQzmGKbajKJ5UFeGqNwkytRDIMQdf1f6GxRUYtKYGXvrB1a0U3atr2OuWQAw2LqTbEBVlLAaEg2h8uuqsCB5LfG8NCk3vnHjQhY7IuNx7NAEFByTHvowl8WYBhKfkxzaW3i7S9sepXb18okFtcmBC8nUMJjSU1f7fIsQMBgGJaa3w9Zrl8gVk9MtiJ8u8BjelfqaXb3kf6obkJOfTdXtscFpimU8vuzf7CZPq8dTbAkFzLGbIyNigXiKSK1fAzABEn9qowlSmWstEoOFrK8YfK3k17ZKdrnwBOaayXyS5xTOPZtUniNo2xA6Q9kRcLeQt5pPxqxKDsqYTj55Q6tJ4qAkcGx5fGnOKlekCaOCKBmmz2kXpdgw2Oj1nAKZDD2H5sf3Ft72qE0BtJgmmrONar7PQSVJoDXiTG1IhN3n5OdW9XzV3V19Wr5dGg6wiOiVCyfIBqBw0QOsiA72ytK061bEPeMZgVb0bIJ8baepvqsB9PSas5AkTii5hVyVPSyu3gbzxWeomK8v0mAru84wOw6gWCvtFwrtb2npkR4acPVBFSgSXOmkUjS16uuCRHlePnuXlU5Ui0ZBADCbF2UnVB1Hln6oeuIe7udCnV1NUb9dmiOpYQjpnBEntitZii9cdh5orHjYzX86R2SeailHTHKlsgsnItuzhPfsjGhYYp3NsNQStB', X'3D1AE4B784D7AC78', X'D5B3D18ED3B57BDEA87764DCAFCB84C5B8E3B88A46E09A8574CB9AE8B8BEEA87B1E4A8A4E9BF99CBA3D68DE896AA4C190F', 'value2', 'a', b'01000001', '2025-06-18 19:15:19', 8.76, 22.64); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (1830, 3584, 983.64, 'sample_dPiBN3CgbQXn', '2025-01-31', 'sample_vmOgQX3eh6woZTt3aNV0fq55qjVrLpBVAAhaYvNBYAeR1mA30XaRZQYQ1kgy7z1QJvy1MLc64QYNI3hrJIOiiAL8W28iE3Uoomv09eV058D9YoVS7FvIga3h7F7PPbNfpuau6TMJ4G3N3nsXvhTUnFMUsPsUHWucmLkAkIQvzFL1oB5lmIB3rDzeMTjb5eNsaZ7mQM5JKaOfF4Cu4KRGWC1J6ZLrHS92j1dVUp26mUdbpvtguGJN4FVCQC4fJIOuVO7Ow8nHq5twCWPfk1YsEbNQS3bXgyIoxIHhq53ZrYtBK9vJdgxhCHEDk9MLzEQeh7Ncitx8dZE8VoyW9MszIqDbwCg9xwen3ew1thD5TTYJocixCkAVygjivHtZu6yJnOGmxHpHRiukcd7RnLjdLR9RSsygMn6VRjYLQ5OxQayKGziX8Ob11prqFGuSnAKV7iSC8P5n5mHiQJKY2SKpFzKNdh7WMACfMv3pw71xtMp3lsZWPcg2Si0QNJJ768Ce98MY3futDqUQCUXL3WzItP8j31n9ajyuV2Sp', 'sample_fBGXCMkcuMzf36z7sXefqXGSwAUvNfnLCWdDXJyjVWrTr332CS5QHzxFzgcozBcYg2IFYZ3Rx5b1Ux4IVNWqJsG0IqDrTgNaoPYb8NdscYWTDmad7QMYjbpptk8rEcM5hLT2a5VpFpie8ZaCtnMMpwr1KzLmfHuCF7mXKGWbSRFcM9ypn6dfFSgSBBiiFDdtWzMrvREzGvhEF6T68RYH8hMzubRsbjsiSsRHAhVoYGLjC8WttHSiCm2Oc5cnATjNlcuUCPRTzDdMJEG3WCG3GLi32iO8dk27EvmqtMHZYkxop5wqz6zixVJksgoJtPJhzDt39jmwHIHK4dRC1EFFHI993mo6j6kxqJWkMe0hcy2Xscn51f5IJutYIBtXSTpUlDqO5gCfzDn2RASPkIDvrvgjMJ8zgi14HsW1lqPtAUxjKiHvIxc7TtWP9GTJxykRPaH0jzuTm3Jb8cXdljFym31gz1GpIsyzxkHEwytOZE0FoARvB0d5yGLhLk8odFWqS6U77LX13cCJyJ0vFhotTUkJib7lpZqJZD6isVywt63hm48jVdcJIs0RpU2HpLXzMVQl0m3oL4PFaSfeV4aCx4JJCK7t9UNNTQy9Bq4dusSgJHcT52ED1xkP9fbvsC93fOmi1eopUBs3mKAYINbE2jVPLDQoNcbVb1C0u6UaxUZJeYBmOmhERZcUlvb6B4SoXGIpnC3qD5L7jJQAGyV5PzCLOJsZL273wzDjXaMXXCjMLQQrUEtQBgULvnBQ2gkgoicoPxdtvrRC4a9pRMxWnwddO6nRYoxctKoTk6AN4EweE9wZgLFwXHNI8nUVbHi4RQg57VBTa6Avep7CgXTevBWoi8LDmJVFIVBPlYx6ElPW5ui5oc6wun4fZSJYWOhVn95w9W9depE76CB1w4ZQasMzq3kvE2gHvanB3DqiwYPtqjIGsxIPxfdE3B1tnOi4SmF0PI4i5lH4DEZhqoeTbNSWGPS8DrPp41ULYzltRMDBO0B0CaYMXCozxqUdKd38wUbKV8NF8qKKySpwRPkRrjygPkb2nQ0YFxwVS4HD1PyFE61k7XSYihVJecNf2iqDka2OX59DUXloitue9FWIuy7NuXa7FvT3ZFjrwDtWmS5SW1rPkRrl7k4j4k3jcdeXDuNTBz0VqY8wSgSPVx3pCCid90xvOhPzCzl8gXZkDJrYxuV0ViGaFDnphNgC5PTfRLopufAJrrXnouK8Q1JcgTwgGpcD2uQGjbf6CA8jUCkigOSDNF8dr4nEJfDclSn5borOR5jy1kFMgbzlbyXUI2b1TaIdkOLSMfL9dBIDJm19KfItM2qwVwIiwGyOnUn9i38DMJjkBXgee95evEKPyCG1eucwgIhTWWXEX7X62PtXoibUAH8LJFt7PRrAh08b3057w68coqJvA5Bkxp9RkC0XIPxAp2TZRJVyOQu5w4PVsliBC9NYmvTfUTq2K26rj9oHhUPcR19Ib1wf3Y4w2UKl49InpPEQsI7mj1P7de8brlPoTTn2xrNhJwgpnilpL5ttMxgXpPDmAXm4Jr53lhf3ZJ', X'2626', X'56E794A953CFAB30E39CA81DC98552E58B9D74C494E5979836EEA38EEE8C9305E895BCCFB465D49FC9BCC8B0', 'value2', 'b,d,a,c', b'00111000', '2024-12-04 05:24:10', 24.29, 84.91); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (1159, 2015, 785.28, 'sample_hmgYY3osvIoyPtf7x8JCxaEg4Wrld', '2025-08-04', 'sample_maZ8HwjVvqPV9JUAqHLU2k14jWaUj9CZ33MuEjYe1JYwcAuN949ycgRAJzXz9pwy2UClE48Rfqw05HOnyI5t6dgsjXYqGyIL5gXN6d3OngfqUjLas1Nk4J7eUtFfBdP9bab8OOvi4qXaGweeWK2jSt4SWsPCfeBcynBHCemiZL4qlvv6AjRAq3MJuBejxevV4Pai0bYwmWGrjyPAwyqAjIwFRN7Wd90eIhmRvczKl60nzHmXDzS3OtyiQanMKG26QhMp82RYKxf0L1liqaC2sVBwh8Va1u0Kskpq2QXqNQWWNU25tqTA6ZliMPMSkDCDFkirpRzfFuSLolPwsFzQpJEoAbSt7LhSipjclYRyBv5AD4Qa', 'sample_yPrgJHgSEFM4dVCTdspg8j5CjtgTCPIOsesjXM32XJLmNEGXMQ6WfH1do4q83xMByYeZibXejW3zSoqwFzUZpY6wlDa7sW6A4gYlGKRq2d4doorSybFiVs0cQtvi0gghHLCCKAC0ZTRo92AFzXJiZcxMjkYjKSImASBQaw5sPoTNplp4AZDRhiGGRkej9urhBm67RLwYuvpcmWNmnwkpcu2hseG9EPLhMw7ggWcZwoS3ekKHaRd2tuqXR2n2GAEAV3DBdxnyKUi8VVyV6JF3uxmJSkO7hsr0FpWBu7A5Hy6ZaEg0x5K5IjUhaeqamsvMr4yNNorW1T1xCO4QBzh7D6nzM1BP8csASxmJuMPi17WfeSMhtOUHgRNdpLkatedBDp74jc5BRN5eleHVtaPSztRHv8VMTnvNfMbjONa8iKAwZiCcfwMxwQoNsUdNbvfbO7oVM2JbECgolMegZvOR9IHrqKKwXM5D4a2P9mJy0mN3ul6A9cM33gVAynHN4h1g81KZv0b55mGhkKk1IfSHDbc5D5mp4QQsckks4w0BNITiiSuO6PMVmlZ9I5hwrIxDUyPVaxinkxsBhP5EGNxKrwiWChDSTB5BecGUjk4jinFwGWYAx2fkCfBhKhgcyWvlDTutfZCI5HS1awiatwkc73zdR88wE2ssXeV4IrCQqd2jE3waj6LTbPam2XBTLKrOBMa72T0bDwL5gJkIu2j5mB0P4HlvGwKjmcBtBolPcevr3Cf9fE3nDphHExAmlaNfyAnTd7DQtApcGG9eabZfA8bqUipCYf1P0pf5u9DOuH6hfw8pVs2JSkkDrcwe61RbGsONoZflQtqXacqdil0kgpDCne8JBfX3LZt6RTGPMPqtIyR58WNYHTsozw95XPDvd3yt3I3Yi0Cvv3xZyzmtSO5PzdGHMgxlNUUJvsL4POGXGCmtLSthSWSXOujwKTSyESm41E3VPYMcGW25SxOFeXzui4ubFNGFxFgW33vVBpyTbeiWIQ17FSiMK3wzuQSmlsykE0qafY9C0vf12u7W0qWxuFjDxM7Ah39BK9Isz9eX55e16OWO1liV2Yadh2ps9fKAuyncWGtIo0FJBiPO9sNGuslJrpH1RJ8Ni9kmrmDfdzpE9H99Q3dat7DjECajFCd3R4o5tpUhLp5qXjvWCwfKUpZAYJz1X6aLU1830CmtTn2xazDC1dq9go0NN5UvoLRFSMGQM8nrDh94v17rypC8YebFvHYdL1zAWkiJj71FdnDtPJMw4cfHNEW6NXrHtUCMYgputt8yxqXwg1yDyNbuQyvv', X'D88EE391A9D2B3E2ABBAE88C96CA8B2CC3B0CEB55AE89BAD54C59344DAB4D085E683ADE88CB904D8B3', X'E4B59EE9BD9BE787A4EAAEB2E983B3E882B8D5BE205FC583C38EE2BDB5C199', 'value2', 'a,b', b'10101000', '2024-12-27 17:14:38', 71.52, 85.92); INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (2120, 4556, 261.49, 'sample_72', '2025-05-08', 'sample_RTCJ7cXFqP0ulTRDUhqPaKaF2U0BUELQrpqjS19OjvN68TBJczxvT3jzyV43orgINYIpKrOpvUJZfKcBVFMGj5m7RRSe6kZM16DHBePxBgQrbOIvW1g6ObbbCRc4D41D1POH6qZqO0YFYFn7oqpdOqhQhYDQhfQl3WsVe8cY29Y95MveUIZo033Em3', 'sample_juw7gwm0vysGzQpBNecGHDEpYpZw2tgwPWIAdLW12JZDrqCggcmeiD1PP3ZsSFAz2uKQj5lFIxSq1R9Qio8TvQja3Up88Y0DsiMBOdt5AzCSKi69EVM7D8Acjn1WChSSHv2UocFzWiWq9km4s5jSr4q68l2vkKEksJfCDAmKX8P5ny0EoAaEWLQaSMtSiqe8sFeXzbgkcBnX7Wj0cypo1udQ9O6dPD9z5ORPk3GS9e432CFWm0ifkaQ08uML9pGV3TG0UyZ3TixxLcjGIJ8iO3eNMGq3KvADaLHLdZygF0sq0Pvas95UEtsmPpcxGUYGRFiOnJIn1rS3m6cdMdVXsyXVCnWcxVTOORIFJDbuvObvy9NH2qv4tDsKBwrZuEXEHEA8Z59CTjkz6dghnnIT3Asj0F6DIIUvMXOBBZ4XgbBYlTRaL9FZEUjjTE4oGEM0DYtEt0563odYxyL9hsnjP0w9BXpYUGOfXzqyD4b4y0RYFkAId7JXz8FgKmbaOaVMxnlPQvJX9GUemeIR71NZC5Cv6PdaFXVbMVwrGihcgzdFquQ91VzRwCsIuYWI7H0jfcfK5IKhaxl9OuoowEqb7cKNKwha3Kcdp6uCNQ3Pc5kmTEMynkZqE4dvvtrKVCXjcAfLcY3yI8sAkYsDrVwsXAhZaICKFEHsgYZAQMZBSNfOCn9k128vDeFoZYK9ClUGAEpcZHGEgKCNMJ7A81Wl0yrzN7yqPqq4yOGOruqlZPTEtbBjIbWOyzOy8VBYRxrOKdvuHrpSJ4Q3w0kBhTTgbI14SauWLQLbKhM5NcvcxBTjsW3UDlKrhzBO42AMtzoTu9imXudn5QyTLGRRotcx5vuhoSj2JP7PxhN4tpBaBytwYy4AYmsnMuXJA9cZsFZIlHvp7f9B1L4pNjyusv1ogFzFyYJuJUwqVcGTD2a6vEOecSB0zpLx8FX5O0tP9f87D4zzQS2kmDygrKGCoWG2GvjnJiQMz0hHQknn1WczXD6GoScT0st6X1UGr9UuwoXcQHkKTTfz5b6ToksdIkUqTMtAy2EmSkcm23AlpViGOv1bD87wxenBA2fRETUISIOlYjJy7YIh4x1I46V2o6HLCYrmjg5pzvROd4GWFNqXGsLBVcQZ44KFKgPp4QmMmGVNJiS5JyrUnYKlijFb3tWR9NgjMy78Bdlmpb00EOVl806VgfgNoIdzjra5zuzTNSDWGVz7CNUteBfRJkokT3CL6jMOmm', X'E1828E34067BDC94C691DBB2DEAACC80C5B6EF81BD3AD3B8E3AF9A04E8BFA0CF88E9AAB73E505FCA95', X'D086EDB79AD186EF9791CBA146DEBAC7A1C2B4E284B33241D3B2EF8A93D582DAB7EEBCA6CFB7ECBE98D186D3B27350', 'value1', 'c', b'11111000', '2025-06-03 05:07:18', 93.60, 39.50); CREATE INDEX idx_t1_c2_c4 ON t1 (c2(63), c4); WITH cte_162 AS (SELECT ABS(qvp52.c15) AS col_1, qvp52.c15 AS col_2, qvp52.c12 AS col_3 FROM t2 AS qvp52) SELECT DISTINCT hmn40.col_2 AS col_1, hmn40.col_3 AS col_2 FROM cte_162 AS hmn40 WHERE (hmn40.col_2 <> 43) UNION ALL SELECT amc36.c4 AS col_1, amc36.c3 AS col_2 FROM t1 AS amc36; WITH cte_162 AS (SELECT ABS(qvp52.c15) AS col_1, qvp52.c15 AS col_2, qvp52.c12 AS col_3 FROM t2 AS qvp52) SELECT hmn40.col_2 AS col_1, hmn40.col_3 AS col_2 FROM cte_162 AS hmn40 WHERE (hmn40.col_2 <> 43) UNION ALL SELECT amc36.c4 AS col_1, amc36.c3 AS col_2 FROM t1 AS amc36;