[rygel] media-export: count_children () left out container



commit 76110df42b3481901b8b387180487bda0f4ee978
Author: Jens Georg <mail jensge org>
Date:   Tue Aug 24 16:57:37 2010 +0300

    media-export: count_children () left out container

 .../rygel-media-export-sql-factory.vala            |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)
---
diff --git a/src/plugins/media-export/rygel-media-export-sql-factory.vala b/src/plugins/media-export/rygel-media-export-sql-factory.vala
index b5b8789..8af3f9e 100644
--- a/src/plugins/media-export/rygel-media-export-sql-factory.vala
+++ b/src/plugins/media-export/rygel-media-export-sql-factory.vala
@@ -136,7 +136,7 @@ internal class Rygel.MediaExport.SQLFactory : Object {
     private const string GET_OBJECT_COUNT_BY_FILTER_STRING =
     "SELECT COUNT(o.type_fk) FROM Object o " +
         "JOIN Closure c ON o.upnp_id = c.descendant AND c.ancestor = ? " +
-        "JOIN meta_data m " +
+        "LEFT OUTER JOIN meta_data m " +
             "ON o.upnp_id = m.object_fk %s";
 
     private const string CHILDREN_COUNT_STRING =



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]