From 33b476d47589936ac74a71ba3201107f0f1806e5 Mon Sep 17 00:00:00 2001 From: Olaf Wintermann Date: Wed, 5 Nov 2025 19:55:08 +0100 Subject: [PATCH] fix new feed pos number generation --- .../src/main/kotlin/de/unixwork/rssreader/Database.kt | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/rss-application/src/main/kotlin/de/unixwork/rssreader/Database.kt b/rss-application/src/main/kotlin/de/unixwork/rssreader/Database.kt index 1cac918..c6eab94 100644 --- a/rss-application/src/main/kotlin/de/unixwork/rssreader/Database.kt +++ b/rss-application/src/main/kotlin/de/unixwork/rssreader/Database.kt @@ -200,7 +200,7 @@ object Database { var feedCol: FeedCollection dataSource.connection.use { connection -> connection.prepareStatement(""" - insert into feedcollections (group_id, pos, name, update_interval, max_item_age, item_state_mode) select ?, coalesce(max(pos), 0)+1, ?, ?, ?, ? from groups + insert into feedcollections (group_id, pos, name, update_interval, max_item_age, item_state_mode) select ?, coalesce(max(pos), 0)+1, ?, ?, ?, ? from feedcollections """.trimIndent(), Statement.RETURN_GENERATED_KEYS).use { stmt -> stmt.setInt(1, parent.id) stmt.setString(2, name) -- 2.47.3