diff options
| author | Brad Beattie <bradbeattie@gmail.com> | 2023-04-16 10:09:54 -0700 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-04-16 11:09:54 -0600 |
| commit | ba5e51700e753f20d568418b8f0f7b48f4ca271c (patch) | |
| tree | d77cd225e9661f7f8c351841958b6e2ea4d3e926 /Emby.Server.Implementations/Data/SqliteItemRepository.cs | |
| parent | 922e04dbf347611ac813a6ca823c0c4fde622c54 (diff) | |
Fix null parental rating comparison (#9618)
Diffstat (limited to 'Emby.Server.Implementations/Data/SqliteItemRepository.cs')
| -rw-r--r-- | Emby.Server.Implementations/Data/SqliteItemRepository.cs | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/Emby.Server.Implementations/Data/SqliteItemRepository.cs b/Emby.Server.Implementations/Data/SqliteItemRepository.cs index 71788a3e4..e59f2a198 100644 --- a/Emby.Server.Implementations/Data/SqliteItemRepository.cs +++ b/Emby.Server.Implementations/Data/SqliteItemRepository.cs @@ -2379,7 +2379,7 @@ namespace Emby.Server.Implementations.Data else { builder.Append( - @"(SELECT CASE WHEN InheritedParentalRatingValue=0 + @"(SELECT CASE WHEN COALESCE(InheritedParentalRatingValue, 0)=0 THEN 0 ELSE 10.0 / (1.0 + ABS(InheritedParentalRatingValue - @InheritedParentalRatingValue)) END)"); |