New files imported within the same second are out of order when known to client via PTR sync.
Hydrus version
v502
Qt major version
Qt 6
Operating system
Windows 10
Install method
Extract
Install and OS comments
Happens regardless of OS and qt version, tested across multiple computers. Database is synced to the PTR.
Bug description and reproduction
When importing a locally stored series of images from scratch and the client is already aware that these images exist, usually through a PTR sync, the images appear to import in order at first glance but are revealed to be lightly scrambled when sorted by import order. Only images that were finished importing in the same second are affected as confirmed by using the "prefer ISO time" display option. Images that are totally new to the client and not in the PTR are unaffected and import as normal.
Log output
No response
Thank you for this report. We had hoped that adding the file_id to the import time sort would solve the 'same second' import time, but we forgot about the PTR, which will pre-populate your file_ids (in arbitrary order) with files you may later import.
I am going to have to think about this, but I suspect the answer is just to bite the bullet and move to floats for import time. Unfortunately, I don't see a way, now, to easily reconstruct the correct import order here, so any solution may only apply to new files. I don't know, maybe we can do something clever with a one-time retroactive job where we look at known url url_ids or tag_ids or something. I'll think about it.