Glitch(es) with column ordering in adminCP

[LiquidFractal]

Hope I'm posting this in the right place!  Not a critical issue, but something I've noticed on a couple of occasions:

I've been viewing active/running tasks in my community suite (adminCP>System>Advanced Configuration>View Tasks), of which there are 3 pages.  I click Frequency because I want to see the tasks which run the most frequently at the top, in descending order.  However, the list soon loses its sort order, as reflected in the screenshot below:

By the last page, everything seems a bit off the rails in terms of sort frequency:

I've seen similar issues when sorting columns in other adminCP views (it was a while back, so I can't remember what the old issue was).  Just pointing this out in case someone wants to review the sorting processes for column data (I haven't yet tried sorting by date to see if analogous issues arise).

Thanks!

Edited August 6, 2021 by liquidfractal

[LiquidFractal]

I can verify that this also happens when one tries to order invoices in the Commerce module using the Customer field.

[Daniel F]

That's a tricky one.
The frequency is stored as a string ( e.g. P0Y0M0DT1H0M0S ) so it's not going to work by the default MySQL sort.

I have filled a bug report for this.