Bug 385297

Summary: Search results are case sensitive on MySQL remote database
Product: [Applications] digikam Reporter: gijssmit
Component: Searches-EngineAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: normal CC: metzpinguin
Priority: NOR    
Version First Reported In: 5.6.0   
Target Milestone: ---   
Platform: Other   
OS: Linux   
Latest Commit: https://commits.kde.org/digikam/9a17c743ea9a41c1ef050b08517343813ef6a9f4 Version Fixed/Implemented In: 5.8.0
Sentry Crash Report:

Description gijssmit 2017-10-02 14:11:17 UTC 
Not sure if I should report this under Search or Databases-MySQL but here goes:
We have a remote MySQL database on Ubuntu for digikam and a few windows clients connecting to that database instance.
When we create a "Test" tag  and tag a few photos and then use the Search Dialogue to search for the tagged photos using the keyword "test" we dont find the "Test"-tagged photos; The results are case sensitive. This is not consistent with the behaviour of a locally installed SQL-Lite database.
If we search for "test" in that database we do get the "Test" tags also.

I would love to hear if we can fix this ourself in the database or if this is something in the software client.
Comment 1 Maik Qualmann 2017-11-26 06:13:54 UTC 
Git commit 9a17c743ea9a41c1ef050b08517343813ef6a9f4 by Maik Qualmann.
Committed on 25/11/2017 at 22:02.
Pushed by mqualmann into branch 'master'.

update DB to v9 and fix migration from SQLite to MySQL
Related: bug 378838, bug 369083, bug 350574
FIXED-IN: 5.8.0

M  +5    -1    NEWS
M  +129  -97   data/database/dbconfig.xml.cmake.in
M  +1    -1    data/database/mysql-global.conf
M  +1    -20   libs/database/coredb/coredbcopymanager.cpp
M  +5    -2    libs/database/coredb/coredbschemaupdater.cpp

https://commits.kde.org/digikam/9a17c743ea9a41c1ef050b08517343813ef6a9f4