[digikam] [Bug 375569] New: Wrong tags in tooltips

[Kusi]

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

            Bug ID: 375569
           Summary: Wrong tags in tooltips
           Product: digikam
           Version: 5.4.0
          Platform: openSUSE RPMs
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Database-Mysql
          Assignee: digikam-devel at kde.org
          Reporter: kusi at forum.titlis.org
  Target Milestone: ---

Created attachment 103649
  --> https://bugs.kde.org/attachment.cgi?id=103649&action=edit
tooltip

when I hover over an image with many tags (including stacked tags), strange &
incomplete tag names are indicated on the tooltip. Please see attached
screenshot

On the screenshot, I see
- Leute/Flavia
- Leute/Kusi
- Flavia
- Kusi
- Maman
- Leute/Timea

The corresponding sql query

select Tags.name, Tags.id as TagId, pid as TagParentId from Images
join ImageTags on Images.id = ImageTags.imageid
join Tags on ImageTags.tagid = Tags.id
where 
Images.name = "20161224T184451-D610-DSC_9616.JPG" AND
Images.album is not NULL;

returns
name    name    TagId   TagParentId
20161224T184451-D610-DSC_9616.JPG       Kusi    12      32
20161224T184451-D610-DSC_9616.JPG       Celine Brun     101     401
20161224T184451-D610-DSC_9616.JPG       Maman   103     102
20161224T184451-D610-DSC_9616.JPG       Alessia 159     401
20161224T184451-D610-DSC_9616.JPG       Color Label None        435     428
20161224T184451-D610-DSC_9616.JPG       Pick Label None 445     428
20161224T184451-D610-DSC_9616.JPG       Flavia  1'064   32
20161224T184451-D610-DSC_9616.JPG       Timea   1'210   32

and select * from Tags where id in (32,401,102, 100) returns

id      pid     name    icon    iconkde lft     rgt
32      0       Leute   [NULL]  [NULL]  1'030   1'631
100     32      Nathalie Famille        [NULL]  [NULL]  1'469   1'576
102     100     Papa    [NULL]  [NULL]  1'570   1'571
401     100     Stephane        [NULL]  [NULL]  1'528   1'531

It looks like the tooltip query doesn't handle multilevel (stacked) tags
correctly. The behavior in digikam is not consistent, this bug does not happen
with all stacked tags. For the example above, my db looks correct, though.

PS: for this query, are the lgt rgt columns needed?

-- 
You are receiving this mail because:
You are the assignee for the bug.