I am running a simple SQL query in the editor that includes a COUNT function, something like:
select account1, count(account1) ACCT_COUNT from customers group by account1
I noticed a problem is in the script output window: clicking on the ACCT_COUNT grid header in order to sort this column returns unexpected results. Toad treats the column contents as strings rather than numbers and therefore the sorting is incorrect.
If the column is generated by a COUNT function, then it is obvious there are only numbers and Toad should sort it accordingly.