Bug 438960

Searching for pictures created in a time range returns all images.

STEPS TO REPRODUCE
1. Create an Advanced Search with Picture Properties > Date > Return items created between 09:00 and 10:00
2. Click OK

OBSERVED RESULT
All images from digiKam are a shown.

Logging output with export QT_LOGGING_RULES="digikam*=true";
 Digikam::ItemLister::listSearch: Search query:
 "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,        ImagePositions.latitudeNumber, ImagePositions.longitudeNumber  FROM Images        LEFT JOIN ImageInformation ON Images.id=ImageInformation.imageid        LEFT JOIN ImageMetadata    ON Images.id=ImageMetadata.imageid        LEFT JOIN VideoMetadata    ON Images.id=VideoMetadata.imageid        LEFT JOIN ImagePositions   ON Images.id=ImagePositions.imageid        INNER JOIN Albums          ON Albums.id=Images.album WHERE Images.status=1 AND (  ( 1 )  );" 
 ()
 


EXPECTED RESULT

Only images created between 9 and 10 o'clock are shown.



SOFTWARE/OS VERSIONS
Linux/KDE Plasma: Ubuntu Linux 18.04.05

KDE Frameworks 5.78.0
Qt 5.14.2 (built against 5.14.2)


ADDITIONAL INFORMATION
Useful for example in combination with 
Month/Day Return items from a month or a day of the month.