Bug 308063

Summary: Sort images by file names is not always correct
Product: [Applications] digikam Reporter: Sabine
Component: Albums-ItemsSortAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: normal CC: caulier.gilles, mohammed.ahmed.anwer, swatilodha27
Priority: NOR    
Version: 2.6.0   
Target Milestone: ---   
Platform: Debian testing   
OS: Linux   
URL: http://www.wildpixler.de/digikam/digikam_sort.jpg
Latest Commit: Version Fixed In: 5.1.0
Sentry Crash Report:
Attachments: 20120922125154-SCH.jpg
201209170957210SCH.jpg

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