From 3c69677aac5a4e03f2ee331ed919481f2b78f3e4 Mon Sep 17 00:00:00 2001 From: Minje Ahn Date: Wed, 15 Jul 2015 22:26:11 +0900 Subject: [PATCH] Fix rebuild playlist_view Change-Id: Ie74b7b3695dc4f16820ee81da582b53b27d31fb3 Signed-off-by: Minje Ahn --- src/common/media-svc-db-utils.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/src/common/media-svc-db-utils.c b/src/common/media-svc-db-utils.c index 6859b6d..57bba19 100755 --- a/src/common/media-svc-db-utils.c +++ b/src/common/media-svc-db-utils.c @@ -178,7 +178,7 @@ static int __media_svc_rebuild_view_query(sqlite3 *db_handle, uid_t uid) col_ptr = g_slist_nth_data(column_list[MEDIA_SVC_DB_LIST_PLAYLIST_MAP], i); if (col_ptr->isView) { if (strncmp(col_ptr->name, MEDIA_SVC_DB_COLUMN_MAP_ID, strlen(MEDIA_SVC_DB_COLUMN_MAP_ID)) == 0) - snprintf(temp, sizeof(temp), ", playlist_map.%s AS pm_id", col_ptr->name); + snprintf(temp, sizeof(temp), ", media_count IS NOT NULL AS media_count, playlist_map.%s AS pm_id", col_ptr->name); else snprintf(temp, sizeof(temp), ", playlist_map.%s", col_ptr->name); strncat(table_query, temp, strlen(temp)); @@ -227,7 +227,7 @@ static int __media_svc_rebuild_view_query(sqlite3 *db_handle, uid_t uid) col_ptr = g_slist_nth_data(column_list[MEDIA_SVC_DB_LIST_TAG_MAP], i); if (col_ptr->isView) { if (strncmp(col_ptr->name, MEDIA_SVC_DB_COLUMN_MAP_ID, strlen(MEDIA_SVC_DB_COLUMN_MAP_ID)) == 0) - snprintf(temp, sizeof(temp), ", tag_map.%s AS tm_id", col_ptr->name); + snprintf(temp, sizeof(temp), ", media_count IS NOT NULL AS media_count, tag_map.%s AS tm_id", col_ptr->name); else snprintf(temp, sizeof(temp), ", tag_map.%s", col_ptr->name); strncat(table_query, temp, strlen(temp)); -- 2.7.4