Bug 385297 - Search results are case sensitive on MySQL remote database
Summary: Search results are case sensitive on MySQL remote database
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Searches-Engine (other bugs)
Version First Reported In: 5.6.0
Platform: Other Linux
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-10-02 14:11 UTC by gijssmit
Modified: 2017-11-26 06:13 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed/Implemented In: 5.8.0
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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