aboutsummaryrefslogtreecommitdiff
path: root/MediaBrowser.Server.Implementations
diff options
context:
space:
mode:
authorLuke Pulverenti <luke.pulverenti@gmail.com>2015-11-16 17:03:11 -0500
committerLuke Pulverenti <luke.pulverenti@gmail.com>2015-11-16 17:03:11 -0500
commit51d00cf3fd123534995153e4fbc7a3c7a0a8a5c3 (patch)
tree47c258c576fea9ef3404f901de93fd01888fc50f /MediaBrowser.Server.Implementations
parent79b2415fdf9684ba8e80863d664cd7e9cc57fff4 (diff)
update queries
Diffstat (limited to 'MediaBrowser.Server.Implementations')
-rw-r--r--MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs4
1 files changed, 2 insertions, 2 deletions
diff --git a/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs b/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs
index d414ce7c1..89507a021 100644
--- a/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs
+++ b/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs
@@ -1954,14 +1954,14 @@ namespace MediaBrowser.Server.Implementations.Persistence
if (query.TopParentIds.Length == 1)
{
- whereClauses.Add("(TopParentId is null or TopParentId=@TopParentId)");
+ whereClauses.Add("(TopParentId=@TopParentId)");
cmd.Parameters.Add(cmd, "@TopParentId", DbType.String).Value = query.TopParentIds[0];
}
if (query.TopParentIds.Length > 1)
{
var val = string.Join(",", query.TopParentIds.Select(i => "'" + i + "'").ToArray());
- whereClauses.Add("(TopParentId is null or TopParentId in (" + val + "))");
+ whereClauses.Add("(TopParentId in (" + val + "))");
}
if (query.AncestorIds.Length == 1)