SqlDbx Forum

SqlDbx

You are not logged in.

#1 2016-02-28 13:35:26

timeco
Member

Wrong sorting of result grid NUMBER data

Hi, when double clicking on NUMBER grid result column, it produces wrong ascending and descending sort. You can probably replicate it by running this query and try sorting it (use comma instead of dot if your NLS settings differ from mine):

SELECT 0.87 AS dummy_number FROM DUAL UNION ALL
SELECT 1.37 AS dummy_number FROM DUAL UNION ALL
SELECT 10 AS dummy_number FROM DUAL UNION ALL
SELECT 2.54 AS dummy_number FROM DUAL UNION ALL
SELECT 3 AS dummy_number FROM DUAL

example of wrong descending sort:
2uzf2ic.jpg

I'm, using SqlDbx 4.13 Professional.

Thanks in advance guys,
Goran

Last edited by timeco (2016-02-28 13:37:19)

Offline

#2 2016-02-28 17:26:28

sqldbxhelp
Administrator

Re: Wrong sorting of result grid NUMBER data

Thank you for reporting this issue.
This will be fixed in the next release.

Offline

#3 2016-04-01 10:27:32

timeco
Member

Re: Wrong sorting of result grid NUMBER data

Hi again,

related to sorting, I also noticed these issues with TIMESTAMP grid columns.

Can't upload screenshot to show you, but for descending sort order I'm getting:
31.03.16 13:15:34,465544  (march 31st)
01.04.16 11:02:39,264388  (april 1st)

and for ascending
01.04.16 11:02:39,264388
31.03.16 13:15:34,465544

The checkbox "Do not use Date format for timestamps" is checked, if it helps.


Thanks alot,
Goran

Offline

#4 2016-04-01 15:10:09

sqldbxhelp
Administrator

Re: Wrong sorting of result grid NUMBER data

When you uncheck "Do not use Date format for timestamps" they retrieved as text from server and as
a result of that will be sorted as text and not as date

Offline

#5 2016-04-02 07:32:31

timeco
Member

Re: Wrong sorting of result grid NUMBER data

I got it, thanks for clearing that up. The checkbox description seems a bit mysterious for us who don't know the logic behind it. To eliminate similar dumb (and probably repeating) querstions in the future, you might consider changing it to "Treat timestamps as text" or "Use text format for timestamps" to make it a bit clearer and unambiguous.

Thanks again

Offline

Board footer

Powered by FluxBB