January 14, 2012

Bug In The Oracle Pl/SQL Developer 7.1.5

There is a bug in Oracle PL/SQL Developer 7.1.5: timestamp field is sorted only by the day, not taking in account months, years and time.

In the picture you can see, that the sorting is ASC and the first value is 01.11.2010 09:37:54, the last value is 26.04.2010 13:02:21, which is definitely older, so should be before the first one.

But the sorting is wrong only if use GUI - this sorting icon to the right of each field. If give sorting rules in the SQL query ORDER BY SYS_START_TIME ASC, then it is correct.

No comments:

Post a Comment