SqlDbx
You are not logged in.
Pages: 1
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:
I'm, using SqlDbx 4.13 Professional.
Thanks in advance guys,
Goran
Last edited by timeco (2016-02-28 13:37:19)
Offline
Thank you for reporting this issue.
This will be fixed in the next release.
Offline
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
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
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
Pages: 1