[Bug 308063] New: Sorting by file names is not always correct

[Sabine]

https://bugs.kde.org/show_bug.cgi?id=308063

            Bug ID: 308063
          Severity: normal
               URL: http://www.wildpixler.de/digikam/digikam_sort.jpg
           Version: 2.6.0
          Priority: NOR
          Assignee: [hidden email]
           Summary: Sorting by file names is not always correct
    Classification: Unclassified
                OS: Linux
          Reporter: [hidden email]
          Hardware: Debian testing
            Status: UNCONFIRMED
         Component: Preview
           Product: digikam

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.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=308063

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #1 from Gilles Caulier <[hidden email]> ---
This is the case of last 2.9.0 ?

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

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Sabine]

https://bugs.kde.org/show_bug.cgi?id=308063

--- Comment #2 from [hidden email] ---
> 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.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=308063

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|Preview                     |Database

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

https://bugs.kde.org/show_bug.cgi?id=308063

--- Comment #3 from Marcel Wiesweg <[hidden email]> ---
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.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Sabine]

https://bugs.kde.org/show_bug.cgi?id=308063

--- Comment #4 from [hidden email] ---
Am 08.10.2012 21:28, schrieb Marcel Wiesweg:
> https://bugs.kde.org/show_bug.cgi?id=308063
>
> --- Comment #3 from Marcel Wiesweg<[hidden email]>  ---
> 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,

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Sabine]

https://bugs.kde.org/show_bug.cgi?id=308063

--- Comment #5 from [hidden email] ---
Created attachment 74435
  --> https://bugs.kde.org/attachment.cgi?id=74435&action=edit
201209170957210SCH.jpg

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Marcel Wiesweg]

https://bugs.kde.org/show_bug.cgi?id=308063

--- Comment #6 from Marcel Wiesweg <[hidden email]> ---
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.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=308063

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |mohammed.ahmed.anwer@gmail.
                   |                            |com
          Component|Database                    |Filters

--- Comment #7 from Gilles Caulier <[hidden email]> ---
Mohamed,

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

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=308063

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Sorting by file names is    |Sort by file names is not
                   |not always correct          |always correct

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=308063

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Sort by file names is not   |Sort images by file names
                   |always correct              |is not always correct

--- Comment #8 from Gilles Caulier <[hidden email]> ---
Mohamed,

Do you see my previous comment ?

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Mohamed]

https://bugs.kde.org/show_bug.cgi?id=308063

--- Comment #9 from Mohamed <[hidden email]> ---
(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 ?

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=308063

--- Comment #10 from Gilles Caulier <[hidden email]> ---
Mohamed,

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

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=308063

--- Comment #11 from Gilles Caulier <[hidden email]> ---
Sabine,

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

Thanks in advance

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[Gilles Caulier-4]

https://bugs.kde.org/show_bug.cgi?id=308063

--- Comment #12 from Gilles Caulier <[hidden email]> ---
Sabine,

Do you seen my previous comment ?

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=308063

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #13 from [hidden email] ---
(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.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=308063

--- Comment #14 from [hidden email] ---
This problem still reproducible with digiKam 5.0.0 ?

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=308063

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |FIXED
             Status|UNCONFIRMED                 |RESOLVED
   Version Fixed In|                            |5.1.0

--- Comment #15 from [hidden email] ---
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

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel