Not Sorting

[kfrancis]

v1.2.9

Simple data set

Not sorting

[jokedst]

Well, it is sorting. As strings. The windows grid has no clue this column is actually numbers.
There is a workaround, if you enable "DetectDbColumnTypes" in the plugin settings, and sort using SQL ("SELECT * FROM THIS ORDER BY 2") then it works.

But that kinda goes against the whole "should just work" that is sort of the guideline of this plugin. Perhaps it's possible to tell the windows grid this is numbers? And DetectDbColumnTypes should perhaps be on by default.

[jokedst]

Nice animated gif by the way!

[kfrancis]

Nice animated gif by the way!

https://www.screentogif.com/ - my fav for that.

Right, duh - sorry that makes total sense. That work around works as well, can confirm. I think it just looked like a bug because it appears that it should work but doesn't. Would be nice to have the order by appended when you click the column? Also, while the query works - clicking on the column doesn't ever work.