PLSDev 13 Beta 4 - wrong timestamp sorting in Grid

[S. Studeny]

Hello.

We found bug in grid column sort feature when TIMESTAMP column is used. See following picture :

https://drive.google.com/file/d/1D0FKgHDbQcwBhAsu4WuW824xXv6ds9rI/view?usp=sharing]

Regards.
Stanislav

 

[Marco Kalter]

Timestamps are sorted as string on the client side. Therefore you either need to modify the "order by" clause for server side sorting, or use an NLS_TIMESTAMP_FORMAT that starts with "YYYY-MM-DD" so that string sorting will lead to the correct result.

 

[Claus Pedersen]

But why does PLD sort timestamp columns as strings?
VARCHAR columns are sorted as strings, NUMBER columns are sorted as numbers, DATE columns are sorted as dates etc.
Therefore TIMESTAMP columns should of course be sorted as timestamps. PLD/Oracle supports 18 different data types and they should of course all be sorted correctly in SQL grid.

 

[S. Studeny]

But why does PLD sort timestamp columns as strings?
VARCHAR columns are sorted as strings, NUMBER columns are sorted as numbers, DATE columns are sorted as dates etc.
Therefore TIMESTAMP columns should of course be sorted as timestamps. PLD/Oracle supports 18 different data types and they should of course all be sorted correctly in SQL grid.

You hit the right reason why this was reported.