fix: pgsql IN operator must work with ANY operator (#906)

goldenbull · chenjn · web-flow · commit e81142e612d5 · 2025-04-14T21:40:24.000+08:00
Co-authored-by: chenjn &lt;chenjn@vm&gt;
diff --git a/Ui/Service/DataSource/DAO/Dapper/DapperDataBase.cs b/Ui/Service/DataSource/DAO/Dapper/DapperDataBase.cs
@@ -384,7 +384,11 @@ public override Result DeleteServer(IEnumerable<string> ids)
                 if (!result.IsSuccess) return result;
                 try
                 {
-                    var ret = _dbConnection?.Execute(NormalizedSql($@"DELETE FROM `{Server.TABLE_NAME}` WHERE `{nameof(Server.Id)}` IN @{nameof(Server.Id)};"), new { Id = ids }) > 0;
+                    // special case: dapper does not support IN operator for postgresql
+                    var sql = DatabaseType == DatabaseType.PostgreSQL
+                        ? $@"DELETE FROM `{Server.TABLE_NAME}` WHERE `{nameof(Server.Id)}` = ANY(@{nameof(Server.Id)});"
+                        : $@"DELETE FROM `{Server.TABLE_NAME}` WHERE `{nameof(Server.Id)}` IN @{nameof(Server.Id)};";
+                    var ret = _dbConnection?.Execute(NormalizedSql(sql), new { Id = ids }) > 0;
                     if (ret)
                         SetDataUpdateTimestamp();
                     return Result.Success();
