[Bug]: Cannot sort column DESC by click when it is named COUNT(*) #20509

Describe the bug

Changing sort direction by click to DESC for a column named COUNT(*) does not work .

How to Reproduce

1. Execute this sql

SELECT *
FROM (
    SELECT type, COUNT(*)
    FROM (SELECT 1 AS type UNION ALL SELECT 2 UNION ALL SELECT 2) AS d
    GROUP BY type
) AS c

2. Then click the COUNT(*) column header to sort it ASC
3. Click again to sort it DESC
4. Sort order didn't change.

Expected behavior

First click should sort ASC, second click should sort DESC.

Database version

MariaDB 11.4

phpMyAdmin version

QA_5_2

Additional context

It works if the column gets an alias:

SELECT *
FROM (
    SELECT type, COUNT(*) AS cnt
    FROM (SELECT 1 AS type UNION ALL SELECT 2 UNION ALL SELECT 2) AS d
    GROUP BY type
) AS c

or if the COUNT(*) function is used directly:

SELECT type, COUNT(*)
FROM (SELECT 1 AS type UNION ALL SELECT 2 UNION ALL SELECT 2) AS d
GROUP BY type