Broken sort by date after last upgrade

[ostasevych]

Steps to reproduce

1. Have some view where the date field is present, eg Date of modification
2. Set the rule in view to sort by date and check that it is working
3. Upgrade to 0.7.0
4. Open any view where sorting by date rule is present
5. Observe that the sorting is broken
6. Check sorting by ABC - observe that it is partially working apart of cyrillic letters Є, І, which goes at the end mistakenly

Expected behavior

The sorting by date should work as expected

Actual behavior

The sorting by date is not working at all, independently of ASC or DESC

Tables app version

0.7.0

Browser

Brave

Client operating system

Win10 x64

Operating system

Ubuntu

Web server

Apache

PHP engine version

PHP 8.2

Database

MariaDB

Additional info

I may assume that this may be related to the changes in the date format, however the Date of Modification is shown correctly.

[enjeck]

Hi @ostasevych. I'm unable to reproduce this. Can you please share a screencast of what's happening?

[ostasevych]

Hi @ostasevych. I'm unable to reproduce this. Can you please share a screencast of what's happening?

Sadly, I cannot share screencasts, please, find the screenshots where I show how ordering (sorting) is not working by the key Last changed:

Would that be possible to make the dates shown in native normal format, eg dd.mm.yyyy?

[ostasevych]

The update to v.0.7.1 hasn't solved the issue :( I am still having trouble with sorting by date in views.

[ostasevych]

UPD: I suspect that the command occ tables:legacy:transfer:rows --all broken the data format thus the date data are no more sortable. Can anybody check that?