Bug 423033

Summary:	Search for File Size Greater Than 95MB doesn't work and increments must be 0.5MB
Product:	[Applications] digikam	Reporter:	Geoff King <gsking1>
Component:	Searches-Advanced	Assignee:	Digikam Developers <digikam-bugs-null>
Status:	RESOLVED FIXED
Severity:	normal
Priority:	NOR
Version First Reported In:	7.0.0
Target Milestone:	---
Platform:	macOS (DMG)
OS:	macOS
Latest Commit:	https://invent.kde.org/graphics/digikam/commit/fb9763e95d294e837aab189434b2936b78f9e2c3	Version Fixed/Implemented In:	7.0.0
Sentry Crash Report:

Description Geoff King 2020-06-16 01:50:13 UTC

SUMMARY
In using Advanced Search, no results are returned if the second box for File Size is greater than 95.0MB.  For example 95.5MB doesn't return any images. 

Also possibly related.  It appears that values must be in exact increments of 0.5MB to be accepted.  If I manually type in a value then that may also not return any images, where some should be returned. 

STEPS TO REPRODUCE
1. Select File Size from (e.g. 41.5MB) to (e.g. 95.5MB)  
2. Click Try
3. No results are observed.
However, If I set the second box to 95.0MB, then I get 187 results (mostly psd, tif and mov)
OBSERVED RESULT
No files were observed however, I know there several.

Second Example:
1. Select File Size from (e.g. 0.1MB) to (e.g. 0.3MB)  by manually typing in values in the boxes.  

OBSERVED RESULTS
No files were returned but there should be many thousands.  

SOFTWARE/OS VERSIONS
Windows: 
macOS: Mojave 10.14.6
Linux/KDE Plasma: 
(available in About System)
KDE Plasma Version: 
KDE Frameworks Version: 
Qt Version: 


ADDITIONAL INFORMATION

Build date: Jun 14 2020

Comment 1 Maik Qualmann 2020-06-16 17:10:17 UTC

Git commit fb9763e95d294e837aab189434b2936b78f9e2c3 by Maik Qualmann.
Committed on 16/06/2020 at 17:07.
Pushed by mqualmann into branch 'master'.

fix convert to integer from double value with exponent
FIXED-IN: 7.0.0

M  +2    -1    NEWS
M  +9    -1    core/libs/database/coredb/coredbsearchxml.cpp

https://invent.kde.org/graphics/digikam/commit/fb9763e95d294e837aab189434b2936b78f9e2c3

Comment 2 Maik Qualmann 2020-06-16 18:17:42 UTC

Git commit 424cd38bb2b44ce28f6295ce935ffb5d8a7fbd23 by Maik Qualmann.
Committed on 16/06/2020 at 18:14.
Pushed by mqualmann into branch 'master'.

show file size range in MiB

M  +2    -2    core/utilities/searchwindow/searchfields.cpp

https://invent.kde.org/graphics/digikam/commit/424cd38bb2b44ce28f6295ce935ffb5d8a7fbd23

Comment 3 Maik Qualmann 2020-06-16 20:13:04 UTC

Git commit b3498871c198902b4c4d0f019579246a65ce3163 by Maik Qualmann.
Committed on 16/06/2020 at 20:10.
Pushed by mqualmann into branch 'master'.

fix factor

M  +1    -1    core/utilities/searchwindow/searchfields.cpp

https://invent.kde.org/graphics/digikam/commit/b3498871c198902b4c4d0f019579246a65ce3163

Comment 4 Maik Qualmann 2020-06-16 21:19:31 UTC

Git commit 30e81fd0f7aa41567eb1ee06cddd763e07cecfb9 by Maik Qualmann.
Committed on 16/06/2020 at 21:16.
Pushed by mqualmann into branch 'master'.

max range is to big for integer, add support for long long integer

M  +9    -1    core/libs/database/coredb/coredbsearchxml.cpp
M  +32   -1    core/libs/database/item/query/fieldquerybuilder.cpp
M  +1    -0    core/libs/database/item/query/fieldquerybuilder.h
M  +1    -1    core/libs/database/item/query/itemquerybuilder.cpp

https://invent.kde.org/graphics/digikam/commit/30e81fd0f7aa41567eb1ee06cddd763e07cecfb9