Toad World® Forums

Sorting bug


#1

Hello,

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.

thank you,
M.R.


#2

The grid in the script output is always a string representation of the values returned. If you want values returned as their actual data types, you need to run your select query using F9 instead.

Greg