From c726ed8c7e60946812ebe831ddbf6c549b8fa397 Mon Sep 17 00:00:00 2001 From: Tasuku Suzuki Date: Fri, 22 Dec 2017 11:43:45 +0900 Subject: binding: mediascanner: fix media_result for video media_result didn't work with video because of the SQL for video is not perfect. Change-Id: If0f8b9d104f4b3f293c6457c285035f55132f748 Bug-AGL: SPEC-1169 Signed-off-by: Tasuku Suzuki (cherry picked from commit 68314a658d919a06b270340f06c162f56147c7b1) --- binding/media-manager.h | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/binding/media-manager.h b/binding/media-manager.h index 7f204fe..200b43d 100644 --- a/binding/media-manager.h +++ b/binding/media-manager.h @@ -91,7 +91,8 @@ void DebugTraceSendMsg(int level, gchar* message); #define VIDEO_SQL_QUERY \ "SELECT files.path, videos.title, videos.artist, \"\", \"\", " \ - "videos.length FROM files LEFT JOIN videos " \ + "videos.length FROM files " \ + "INNER JOIN videos ON videos.id = files.id " \ "WHERE files.path LIKE '%s/%%' " \ "ORDER BY " \ "videos.title" -- cgit 1.2.3-korg