aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDocile-Alligator <25734209+Docile-Alligator@users.noreply.github.com>2023-10-21 04:16:54 +0000
committerDocile-Alligator <25734209+Docile-Alligator@users.noreply.github.com>2023-10-21 04:16:54 +0000
commitbfec1912bd30a4ec2d684dc2a54bae351dd601e2 (patch)
tree4d987893ae477f1b287ac83d5571dd0737406164
parentfe51e3b9dd504db1b8d9ac7b2ce6df2217359ecb (diff)
downloadinfinity-for-reddit-bfec1912bd30a4ec2d684dc2a54bae351dd601e2.tar
infinity-for-reddit-bfec1912bd30a4ec2d684dc2a54bae351dd601e2.tar.gz
infinity-for-reddit-bfec1912bd30a4ec2d684dc2a54bae351dd601e2.tar.bz2
infinity-for-reddit-bfec1912bd30a4ec2d684dc2a54bae351dd601e2.tar.lz
infinity-for-reddit-bfec1912bd30a4ec2d684dc2a54bae351dd601e2.tar.xz
infinity-for-reddit-bfec1912bd30a4ec2d684dc2a54bae351dd601e2.tar.zst
infinity-for-reddit-bfec1912bd30a4ec2d684dc2a54bae351dd601e2.zip
Ignore case when comparing name_of_usage in PostFilterDao.
-rw-r--r--app/src/main/java/ml/docilealligator/infinityforreddit/postfilter/PostFilterDao.java2
1 files changed, 1 insertions, 1 deletions
diff --git a/app/src/main/java/ml/docilealligator/infinityforreddit/postfilter/PostFilterDao.java b/app/src/main/java/ml/docilealligator/infinityforreddit/postfilter/PostFilterDao.java
index 37a511b1..f482071a 100644
--- a/app/src/main/java/ml/docilealligator/infinityforreddit/postfilter/PostFilterDao.java
+++ b/app/src/main/java/ml/docilealligator/infinityforreddit/postfilter/PostFilterDao.java
@@ -37,7 +37,7 @@ public interface PostFilterDao {
List<PostFilter> getAllPostFilters();
@Query("SELECT * FROM post_filter WHERE post_filter.name IN " +
- "(SELECT post_filter_usage.name FROM post_filter_usage WHERE (usage = :usage AND name_of_usage = :nameOfUsage) " +
+ "(SELECT post_filter_usage.name FROM post_filter_usage WHERE (usage = :usage AND name_of_usage = :nameOfUsage COLLATE NOCASE) " +
"OR (usage =:usage AND name_of_usage = '--'))")
List<PostFilter> getValidPostFilters(int usage, String nameOfUsage);