Changes made for MCOL-1052[1] reverts the default orientation of a set internally sorted by CS.
select d_yearmonthnum * 100 + 1 d_start , count
from dateinfo where d_weekdayfl = 1 and d_year = 1998 group by 1 order by 2 desc limit 1;
####before the change
MariaDB [ssb]> select d_yearmonthnum * 100 + 1 d_start , count from dateinfo where d_weekdayfl = 1 and d_year = 1998 group by 1 order by 2 desc limit 1;
------------------+
| d_start | count |
------------------+
| 19980301 | 23 |
------------------+
1 row in set (0.07 sec)
after the change
MariaDB [ssb]> select d_yearmonthnum * 100 + 1 d_start , count from dateinfo where d_weekdayfl = 1 and d_year = 1998 group by 1 order by 2 desc limit 1;
------------------+
| d_start | count |
------------------+
| 19980201 | 20 |
------------------+
1 row in set (0.01 sec)