Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.2.0
-
2018-11
Description
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)