]> nmode's Git Repositories - signal-cli/commitdiff
Improve sql query
authorAsamK <asamk@gmx.de>
Sat, 10 Feb 2024 11:24:13 +0000 (12:24 +0100)
committerAsamK <asamk@gmx.de>
Sat, 10 Feb 2024 11:24:13 +0000 (12:24 +0100)
lib/src/main/java/org/asamk/signal/manager/storage/recipients/RecipientStore.java

index 9a0b5d00e6ec5df27a7d1034c7562081860ac072..5bd972ab9a925a03c734700e92aa2460a43fbee3 100644 (file)
@@ -891,13 +891,12 @@ public class RecipientStore implements RecipientIdCreator, RecipientResolver, Re
         final var sql = (
                 """
                 UPDATE %s
-                SET unregistered_timestamp = ?
+                SET unregistered_timestamp = NULL
                 WHERE _id = ?
                 """
         ).formatted(TABLE_RECIPIENT);
         try (final var statement = connection.prepareStatement(sql)) {
-            statement.setNull(1, Types.INTEGER);
-            statement.setLong(2, recipientId.id());
+            statement.setLong(1, recipientId.id());
             statement.executeUpdate();
         }
     }