Bit value changed after adding DISTINCT inquery

mysql> SELECT t2.c11 AS col_1, t2.c14 AS col_1_2, t2.c12 AS c12 FROM t2 AS t2 USE INDEX (idx_t2_c4) WHERE (t2.c11 <> 'sample_60') ORDER BY t2.c12 ASC;

+---------+---------+------------+

| col_1   | col_1_2 | c12        |

+---------+---------+------------+

| a       |    8.76 | 0x41       |

| a,b,c,d |   90.91 | 0x6A       |

| b,c     |   76.33 | 0x8B       |

| a,b,c   |   97.71 | 0xD7       |

+---------+---------+------------+

4 rows in set (0.00 sec)

mysql> SELECT DISTINCT t2.c11 AS col_1, t2.c14 AS col_1_2, t2.c12 AS c12 FROM t2 AS t2 USE INDEX (idx_t2_c4) WHERE (t2.c11 <> 'sample_60') ORDER BY t2.c12 ASC;

+---------+---------+------+

| col_1   | col_1_2 | c12  |

+---------+---------+------+

| a       |    8.76 |   65 |

| a,b,c,d |   90.91 |  106 |

| b,c     |   76.33 |  139 |

| a,b,c   |   97.71 |  215 |

+---------+---------+------+

4 rows in set (0.00 sec)

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, 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);

CREATE  INDEX idx_t2_c4 ON t2 (c4);

SELECT t2.c11 AS col_1, t2.c14 AS col_1_2, t2.c12 AS c12 FROM t2 AS t2 USE INDEX (idx_t2_c4) WHERE (t2.c11 <> 'sample_60') ORDER BY t2.c12 ASC;

SELECT DISTINCT t2.c11 AS col_1, t2.c14 AS col_1_2, t2.c12 AS c12 FROM t2 AS t2 USE INDEX (idx_t2_c4) WHERE (t2.c11 <> 'sample_60') ORDER BY t2.c12 ASC;