Room doesn't understand "NULLS FIRST" in the ORDER BY clause :(

diff --git a/app/src/main/java/net/ktnx/mobileledger/dao/PatternHeaderDAO.java b/app/src/main/java/net/ktnx/mobileledger/dao/PatternHeaderDAO.java
index 43f688aab2a1b7bd8d994b06f0e9800f744ce0a4..a8ef1533720c9ed1da0df2cb6dda5f1570b6dc04 100644 (file)
--- a/app/src/main/java/net/ktnx/mobileledger/dao/PatternHeaderDAO.java
+++ b/app/src/main/java/net/ktnx/mobileledger/dao/PatternHeaderDAO.java
@@ -42,7 +42,7 @@ public interface PatternHeaderDAO {
     @Delete
     void delete(PatternHeader item);
 
-    @Query("SELECT * FROM patterns ORDER BY UPPER(name) NULLS FIRST")
+    @Query("SELECT * FROM patterns ORDER BY UPPER(name)")
     LiveData<List<PatternHeader>> getPatterns();
 
     @Query("SELECT * FROM patterns WHERE id = :id")