SqlDbx Forum

garbuya

Member

Bug in results sort order

Lets run this
SELECT 0 FROM DUAL
UNION ALL SELECT 0.0 FROM DUAL
UNION ALL SELECT 0.01 FROM DUAL
UNION ALL SELECT 0.01 FROM DUAL
UNION ALL SELECT 0.001 FROM DUAL
UNION ALL SELECT 0.001 FROM DUAL

The result is sorted in proper ascending order 0 - 0.1 - 0.01

Now double click on the column header and sort the result in ascending order. You will get 0.001 - 0.01 - 0
Data not sorted! Why zeros are the last? It should be first!

Double click one more time to sort in descending order. You will get 0 -  0.01 - 0.001
Again, data not sorted! Why zeros on the first place? it should be last

It looks like there is a problem with sorting fractions

sqldbxhelp

Administrator

Re: Bug in results sort order

It is a bug sorting decimal column with 0 value in it.
Will be fixed in a next release