Sortable columns: #logins incorrect

[ghost]

Version 140520 adds several sortable columns to the Users panel. The results for # of Logins has a bit of a problem with significant digits. For example, the following is a highest first result for one level of users:
9, 9, 9, 86, 8, 8, 8, 7, 7, 7, 62, 62, 60, 6, 6, 55, 51, 51,5, 5, ...

Parts of 2 columns shown in attached image:

[clavaque]

I see this in my test installation too.

[jaswrks]

Confirmed, me as well. Thanks for reporting this!

[ghost]

BTW...
This is a VERY WELCOME feature. I've used Bruce's sortable EOT column for a long time and am pleased to see the function extended to additional columns. Additionally, anyone who has Bruce's previous code as a MUPLUGIN coincident with this upgrade will find that clicking on the EOT column will return empty results.

I know you'll get it sorted. :)

[jaswrks]

@BruceCaldwell The issue here is that all of the meta fields are stored by WP as a TEXT column type. What needs to happen here; is that we need to CAST(meta_value AS UNSIGNED) on columns that are known to be numeric — before we do the sort.

[jaswrks]

@BruceCaldwell The same for timestamps too of course. This issue is not currently impacting those, but only because they are all the same length. Any numeric value needs to get sorted as UNSIGNED. I missed this before too.

[jaswrks]

Great, thanks! Closing this now. This fix will go out in the next release.