[Digikam-devel] [Bug 273852] Showing only one tag results in photos where this tag is not set

[Marcel Wiesweg]

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





--- Comment #3 from Marcel Wiesweg <marcel wiesweg gmx de>  2011-05-23 20:50:59 ---
I am testing with 2.0 and SQlite, so chances are I cannot reproduce this.

The relevant SQL is
SELECT DISTINCT Images.id, Images.name, Images.album,
                                    Albums.albumRoot,
                                    ImageInformation.rating, Images.category,
                                    ImageInformation.format,
ImageInformation.creationDate,
                                    Images.modificationDate, Images.fileSize,
                                    ImageInformation.width,
ImageInformation.height
                            FROM Images
                                    INNER JOIN ImageInformation ON
Images.id=ImageInformation.imageid
                                    INNER JOIN Albums ON Albums.id=Images.album
                            WHERE Images.status=1 AND Images.id IN
                                    (SELECT imageid FROM ImageTags
                                    WHERE tagid=:tagID );

so the relevant subquery is 
SELECT imageid FROM ImageTags WHERE tagid=:tagID
which is simple enough.

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.