column name unexpectedly changes ,after changing COUNT to COUNT(DISTINCT))

mysql> WITH cte_990 AS (SELECT (SELECT s342.c13 AS subq_col FROM t3 AS s342 GROUP BY s342.c13 ORDER BY s342.c13 LIMIT 1) AS col_1, DATE_FORMAT(ssn67.c4, 'YYYY-MM-DD') AS col_2, ssn67.c13 AS col_3, SUBSTRING(ssn67.c10, 4, 8) AS col_4 FROM t3 AS ssn67) SELECT DISTINCT COUNT(cte.col_3) AS col_1, cte.col_1 AS col_1_2, cte.col_4 AS col_4, cte.col_1 AS col_1_1 FROM cte_990 AS cte WHERE ((SUBSTRING(cte.col_4, 18, 2) <> 'sample_66') OR (cte.col_2 = 'sample_24') OR (ROUND(cte.col_1, 4) < 28)) GROUP BY cte.col_4, cte.col_1, cte.col_1, cte.col_1 ORDER BY cte.col_1 DESC;

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

| col_1 | col_1_2                                                                                    | col_4    | col_1_1                                                                                    |

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

.......

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

3 rows in set, 1 warning (0.00 sec)

mysql> WITH cte_990 AS (SELECT (SELECT s342.c13 AS subq_col FROM t3 AS s342 GROUP BY s342.c13 ORDER BY s342.c13 LIMIT 1) AS col_1, DATE_FORMAT(ssn67.c4, 'YYYY-MM-DD') AS col_2, ssn67.c13 AS col_3, SUBSTRING(ssn67.c10, 4, 8) AS col_4 FROM t3 AS ssn67) SELECT DISTINCT COUNT(DISTINCT cte.col_3) AS col_1, cte.col_1 AS col_1_2, cte.col_4 AS col_4, cte.col_1 AS col_1_1 FROM cte_990 AS cte WHERE ((SUBSTRING(cte.col_4, 18, 2) <> 'sample_66') OR (cte.col_2 = 'sample_24') OR (ROUND(cte.col_1, 4) < 28)) GROUP BY cte.col_4, cte.col_1, cte.col_1, cte.col_1 ORDER BY cte.col_1 DESC;

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

| col_1 | col_1_1                                                                                    | col_4    | col_1_1                                                                                    |

.....

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

3 rows in set, 1 warning (0.00 sec)

DROP DATABASE IF EXISTS test;

CREATE DATABASE IF NOT EXISTS test;

USE test;

CREATE TABLE t3 (

    c1 INT NOT NULL AUTO_INCREMENT,

    c2 INT NOT NULL,

    c3 INT NOT NULL,

    c4 YEAR NOT NULL,

    c5 TIME 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 t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (2908, 4843, 4625, 2006, '2023-01-01 03:14:46', 18, 69, 19, 96, 'sample_UMzafi4UnnDeggPdaFpTVa11nrgxxcql8HgCtqP1WQioS85kGto5M2xasxXdz2fi9V9VAT9h7q0k9G3DvKZe16XSCca23xUyFDeAo49xrRjn7xT9KflXanM8gS9Te1u6jiZtqrVB8gQIEAH6p5KTI0gTC4aFvsRRqcBJhsF6LYcjIoOI5bEzDtXyCOWORUXU5yOhXvhYgw6isZhGSEDbgzUJhF6RsFvNFk02tTehMxyzczbwuwlEoVYc78I6SqONtpqWWnFQoMNo3tSa6k5zU2XfpHT12PKMRNNQec4unDeeNbDTTfr3jz6wkatHctx4reBYIhXsiW9tpKEG6rTAWES0lwLCxBrcc2QAE59DHx0FuwymLDx8DZD4qiiN070ocbroKIH7kFZgSLGvcIU0D2JMrIeoust3ySSRPOFF4weHwc', ST_GeomFromText('POINT(-71.819848 138.641007)'), 'sample_qHGFmRwtuO3Rs4NCJ1BYuYsAiNsaABriJ', X'52E992A643DDBEE4A98EDD8505E38AAEC39B196C42061860', 'z', NULL);

INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (3134, 7575, 6866, 2011, '2023-01-01 19:29:07', 55, 53, 15, 14, 'sample_defcIAlBcKFORV4MbcpiGIoKZ0rh5j39CZEPtPjEgglJvzWj5pUAjTxgReHTFI5vpfEIUajqS74CMfNW0ad4c3v7KT5BTP0GqGTrGDsLI8oiuIMaLTFmctwuLvZUjq4pfVPfklsec70JhQ8sJwT6cbWW5frA7QKBPiNKmwpCrtBeBbYemCyHayexOHniGt8FatHTeGebN7x3FdyOydExY49jqWovBj18iU98MGuEs5iyzuLu3Ub0AS5Uwv8B7nLf9DtFdbLYEkJ5NvJblaoFo0RIomQkneBEirX1dOW1S0rkaTGDuESb0AXjNW0M24zsbIDFVD0Yl00ZOhithoeYhfwjx5zGfG1C4bcny0hJEIG0r6kymaA5kgEaHlOSsBihDAGmweuYIBekPOzB6Wsemmtws3QsVT9BFy1W6P8bRDRyvIV15wGOsrTrnIKYfFPiOXTk207LUdQihJ19kP3S0v70yPeUwxkEelIU3HJhrhAtDlB4GFT2jg7JNGb5IUW8EEzVrgfz9j2hk0eVu8EuFjJqFT34Es9z7o8fOYiLzgfy1FnBxBoWRUcm3ASW1SO26pAp2EeBcYwCSrPnKQfA0JyFfVlcC6D9B6Enqvfjeg5sGVkfe5VebrV1cYQCe2YyGHGvNZ9sXjenMCsLsYhgUzsbvaGCxiYxylnFwiM1NmZzaiP79KpnqUeA2bG18DEjrUhDA1AjUToybkIDFjuEPOagu5hRHgIrQzXMMwh', ST_GeomFromText('POINT(64.456705 62.877436)'), 'sample_21UKpdGSgqEhfreCDencKDt9jYioJqo37HaPkknUCpJAUmgsAPyvQEEtFU1XBdRbgpqC5YGRZWUVwgSCSfRwAuB5NnzaE830yz8ZgvxRG5wQyuGGZmE', X'02E595A15AC1A764D793D290E78BAFDF88DCBDCABDDF9821DDBF7AE2B198E097ACC1BCE99A80C3866EEDB4A6', 'z,y,x', NULL);

INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (991, 4843, 6486, 2013, '2023-01-01 01:56:15', 90, 36, 45, 19, 'sample_AnjQ5xLR9ofy2829vROHofOYLdGdhXL8oUMkxsECkKje85uwesYQzL21M74vrC2XGb2HDsb9AnsIWPyzCC6Ngv4WqVt5eRxMH8khR5SJnh9dogQfFgMjfm7SvT0z1mxZEP0uoujN5ZdxyZpUHpO2h7GP0pvvEua9Nk5e5LjTQNRhCAztFooTtaYn3hGelxJAs9VvncDfFxmb3nwXDkEsahIwsB126qB6jSSKDcHBaA6uJxjmmPvjVTQXyIZIAxMy6wlv3efMQeUBB39FcktrWZGFbbq9ezriXpx0rtaLcu8es6fmSKmozJbg3M6OIvqfIxU2uT5D06x9s7DoTbPciB0GM8rB9rgrD0jbVO5tOBv4vUpr5wvrbmwbAwa2z2oqpPvl96CvLQePnteNc2mIWsRMXI7jPoeYV5xVjCVZsxFOjvMr72BvdrdiHl444TAZsWqa4BldJy8ChdQiecuoHai7fCHoY4yMPdp1KpY2WE9hxWZSDoMi6uPjhdLMVAKc1La0mHniHgq0kVcqPJY0xmKSCcsVD29MQGh3gLTHowcvqP5PDmB2cy7BAcScmW734GxSlRLmv7IH2O2W4aqRzdH8cBhzAKoRNberxBhKyVcdYDLTDs0gqqB7COXx8OZnoIZDa78xVzKakapRiewPnlljxJ2UbTDDNUScVTjTGOOmhgUnEW6jzX280VL8j1huMgFtzHHKvnuQR5yvdnRVJTbgcHAvfUHeJydwNd0vdvTIEqOzywI1tBvMoRF8bSjuY9SXFSRVCMfsj2yLL1WRTSfoCGyuXFXkfzOlegcdTCRITVObhMdP2KwztDfD9rp5Ycanmt5YJWXjZrJv2gZKsauZBF9iWo7qx8FXZDNs52b9MQaVKyDjgVbe8L52B7NFP2DmuPLNEdKRYyc3EG3G8jwKNP87DZNAtNrKvglWk5rPU9KdYTVC9R9vG1aDisGMgCYyRIPrLFBU0YqsUQHDCjswxED1UUvD1PcA0pvQBziPn340qK2avaUL6y3jSPzVlIW24NWcG2qbhN48', ST_GeomFromText('POINT(-76.198266 175.563258)'), 'sample_JlxYQrSWDBd9vHRjREOQNKllXvE0MPmgdSbswwiXwZnwGv3OhFH26mnIDbhUC4fdfmxp8tlZjRxCAirw7TR6AKaXf3Jc6Dd7N08j4FFa2xjmUJHkZpGktEM42KRwUQeZXVXKTC93K15ZLmpkASv', X'E58B8CC5A1E4AEB2220DEEA1A313E8B881D0A9E0A9BBEFAB9C02E3B2B2D492C3B3E99D8260E28C9AD08AED9082D1ABE99DA2', 'y', NULL);

WITH cte_990 AS (SELECT (SELECT s342.c13 AS subq_col FROM t3 AS s342 GROUP BY s342.c13 ORDER BY s342.c13 LIMIT 1) AS col_1, DATE_FORMAT(ssn67.c4, 'YYYY-MM-DD') AS col_2, ssn67.c13 AS col_3, SUBSTRING(ssn67.c10, 4, 8) AS col_4 FROM t3 AS ssn67) SELECT DISTINCT COUNT(cte.col_3) AS col_1, cte.col_1 AS col_1_2, cte.col_4 AS col_4, cte.col_1 AS col_1_1 FROM cte_990 AS cte WHERE ((SUBSTRING(cte.col_4, 18, 2) <> 'sample_66') OR (cte.col_2 = 'sample_24') OR (ROUND(cte.col_1, 4) < 28)) GROUP BY cte.col_4, cte.col_1, cte.col_1, cte.col_1 ORDER BY cte.col_1 DESC;

WITH cte_990 AS (SELECT (SELECT s342.c13 AS subq_col FROM t3 AS s342 GROUP BY s342.c13 ORDER BY s342.c13 LIMIT 1) AS col_1, DATE_FORMAT(ssn67.c4, 'YYYY-MM-DD') AS col_2, ssn67.c13 AS col_3, SUBSTRING(ssn67.c10, 4, 8) AS col_4 FROM t3 AS ssn67) SELECT DISTINCT COUNT(DISTINCT cte.col_3) AS col_1, cte.col_1 AS col_1_2, cte.col_4 AS col_4, cte.col_1 AS col_1_1 FROM cte_990 AS cte WHERE ((SUBSTRING(cte.col_4, 18, 2) <> 'sample_66') OR (cte.col_2 = 'sample_24') OR (ROUND(cte.col_1, 4) < 28)) GROUP BY cte.col_4, cte.col_1, cte.col_1, cte.col_1 ORDER BY cte.col_1 DESC;