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