Bug 308063 - Sort images by file names is not always correct
Summary: Sort images by file names is not always correct
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Albums-ItemsSort (show other bugs)
Version: 2.6.0
Platform: Debian testing Linux
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL: http://www.wildpixler.de/digikam/digi...
Keywords:
Depends on:
Blocks:
 
Reported: 2012-10-08 10:13 UTC by Sabine
Modified: 2022-02-20 08:46 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In: 5.1.0
Sentry Crash Report:


Attachments
20120922125154-SCH.jpg (931.11 KB, image/jpeg)
2012-10-09 06:21 UTC, Sabine
Details
201209170957210SCH.jpg (174.69 KB, image/jpeg)
2012-10-09 06:21 UTC, Sabine
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Sabine 2012-10-08 10:13:25 UTC
The names of my photos begin with the creation date/time from the exif header. 
But the sort order by filename and by date/time give different results.

Reproducible: Always

Steps to Reproduce:
1. Ansicht - Bilder sortieren - Nach Datum (Sort by date/time): correct order
2. Ansicht - Bilder sortieren - Nach Name (Sort by name): incorrect order
Actual Results:  
different order

Expected Results:  
identical order

I am using MySQL as database.
Comment 1 caulier.gilles 2012-10-08 12:12:04 UTC
This is the case of last 2.9.0 ?

Try to make a test sqlite DB. It still valid in this case ?

Gilles Caulier
Comment 2 Sabine 2012-10-08 16:57:08 UTC
> This is the case of last 2.9.0 ?
Yes, the sorting by name is still incorrect.

> Try to make a test sqlite DB. It still valid in this case ?
Yes, even with a new sqlite DB the sorting by name is still incorrect.
Comment 3 Marcel Wiesweg 2012-10-08 19:28:08 UTC
Created attachment 74434 [details]
20120922125154-SCH.jpg

Please break it down to allow us to test and reproduce: Ideally, give us two pictures which are sorted A B with sort by date and B A with sort by name.
Comment 4 Sabine 2012-10-09 06:21:38 UTC
Am 08.10.2012 21:28, schrieb Marcel Wiesweg:
> https://bugs.kde.org/show_bug.cgi?id=308063
>
> --- Comment #3 from Marcel Wiesweg<marcel.wiesweg@gmx.de>  ---
> Please break it down to allow us to test and reproduce: Ideally, give us two
> pictures which are sorted A B with sort by date and B A with sort by name.
>

Enclosed two pictures which sort differently.
The interesting thing is, that they sort correctly, when I rename them.
Is there something special with a "-"?

Regards,
Comment 5 Sabine 2012-10-09 06:21:39 UTC
Created attachment 74435 [details]
201209170957210SCH.jpg
Comment 6 Marcel Wiesweg 2012-10-26 11:07:21 UTC
We sort as described here:
http://sourcefrog.net/projects/natsort/
as you see, the difference is the "-" vs. an extra trailing 0 in your files.
I tend to keep the current behavior.
Comment 7 caulier.gilles 2014-08-07 12:32:57 UTC
Mohamed,

This file is not fixed since your last work on album filter with 4.x releases ?

Gilles Caulier
Comment 8 caulier.gilles 2014-08-22 15:24:35 UTC
Mohamed,

Do you see my previous comment ?

Gilles Caulier
Comment 9 Mohamed 2014-08-22 15:39:17 UTC
(In reply to Gilles Caulier from comment #8)
> Mohamed,
> 
> Do you see my previous comment ?
> 
> Gilles Caulier

I just saw it now, would you please give me an obvious example ?
Comment 10 caulier.gilles 2014-08-22 21:08:57 UTC
Mohamed,

I think the explainations given in comment #1. Sample files are given to comment #3 and #5.

Gilles Caulier
Comment 11 caulier.gilles 2014-08-22 21:09:33 UTC
Sabine,

Can you provide more file samples to try to reproduce the problem.

Thanks in advance

Gilles Caulier
Comment 12 caulier.gilles 2015-05-10 19:05:52 UTC
Sabine, 

Do you seen my previous comment ?

Gilles Caulier
Comment 13 swatilodha27 2016-06-04 11:33:11 UTC
(In reply to Sabine from comment #0)

Could you please provide in detail what you're actually trying to do and how?
I would be a help.

Thank you.
Comment 14 caulier.gilles 2016-07-04 16:55:56 UTC
This problem still reproducible with digiKam 5.0.0 ?

Gilles Caulier
Comment 15 caulier.gilles 2016-07-04 16:58:27 UTC
I cannot reproduce this problem using digiKam 5.0.0.

I close this file now. Don't hesitate to re-open if necessary

Gilles Caulier