diff options
| author |   Tasuku Suzuki <tasuku.suzuki@qt.io> | 2017-12-22 11:43:45 +0900 |
|---|---|---|
| committer | Tasuku Suzuki <tasuku.suzuki@qt.io> | 2017-12-22 11:43:45 +0900 |
| commit | 68314a658d919a06b270340f06c162f56147c7b1 (patch) | |
| tree | 8062be1c3bc68f7f569da5ae509bba2a2a5d0cda | |
| parent | 91126397febe969a6ee94f9baff6337568ee7c65 (diff) | |
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 <tasuku.suzuki@qt.io>
| -rw-r--r-- | binding/media-manager.h | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/binding/media-manager.h b/binding/media-manager.h index 37621b0..2190a16 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" |