From d45e77f2dcb59fd0b6e83d459615f902c5a6c715 Mon Sep 17 00:00:00 2001 From: Yong Yeon Kim Date: Sat, 24 Aug 2013 15:35:44 +0900 Subject: [PATCH] fix N_SE-49721 add new option for case sensitive LIKE operation when making db connection Change-Id: Ia1b93833d8715c1643443f038de31c360355b02e --- lib/media-util-db.c | 12 ++++++++++++ packaging/media-server.spec | 2 +- 2 files changed, 13 insertions(+), 1 deletion(-) diff --git a/lib/media-util-db.c b/lib/media-util-db.c index ca3494a..21f155c 100755 --- a/lib/media-util-db.c +++ b/lib/media-util-db.c @@ -69,6 +69,7 @@ static int __media_db_busy_handler(void *pData, int count) static int __media_db_connect_db_with_handle(sqlite3 **db_handle) { int ret = MS_MEDIA_ERR_NONE; + char *zErrMsg = NULL; /*Connect DB*/ ret = db_util_open(MEDIA_DB_NAME, db_handle, DB_UTIL_REGISTER_HOOK_METHOD); @@ -100,6 +101,17 @@ static int __media_db_connect_db_with_handle(sqlite3 **db_handle) return MS_MEDIA_ERR_DB_CONNECT_FAIL; } + ret = sqlite3_exec(*db_handle, "PRAGMA case_sensitive_like = true", NULL, NULL, &zErrMsg); + if (SQLITE_OK != ret) { + MSAPI_DBG_ERR("Fail to change case sensitive mode: %s\n", sqlite3_errmsg(*db_handle)); + + sqlite3_free(zErrMsg); + db_util_close(*db_handle); + *db_handle = NULL; + + return MS_MEDIA_ERR_DB_CONNECT_FAIL; + } + return MS_MEDIA_ERR_NONE; } diff --git a/packaging/media-server.spec b/packaging/media-server.spec index c21f9db..1c83402 100755 --- a/packaging/media-server.spec +++ b/packaging/media-server.spec @@ -1,6 +1,6 @@ Name: media-server Summary: File manager service server. -Version: 0.2.54 +Version: 0.2.55 Release: 1 Group: utils License: Apache License, Version 2.0 -- 2.7.4