DELETE ORDER BY / LIMIT 在 PostgreSQL 16 + orafce 支持吗？

判定为 none。DELETE 无 ORDER BY/LIMIT 子句，需组合改写并处理分批清理边界；建议 PoC 复核

MYSQL DELETE ORDER BY / LIMIT 迁移 PostgreSQL 16 + orafce 怎么改

CTE 先按稳定唯一键 ORDER BY/LIMIT 取主键集合，再 DELETE ... USING

公开资料依据 · 建议 PoC 复核

支持度none

严重度major

置信度medium

依据规则my.dml.delete_order_limit

CTE 先按稳定唯一键 ORDER BY/LIMIT 取主键集合，再 DELETE ... USING

DELETE 无 ORDER BY/LIMIT 子句，需组合改写并处理分批清理边界；建议 PoC 复核

库侧改造

可行：CTE/子查询选定主键集合，再 DELETE ... USING

应用侧改造

可行：清理任务按稳定主键页分批删除

推荐路线：db_side。验证建议：排序并列、并发写入、循环批次无漏重、外键与触发器副作用

DELETE FROM audit_log WHERE created_at < NOW() ORDER BY created_at, id LIMIT 1000

DELETE FROM queue ORDER BY priority, id LIMIT 10

DELETE FROM queue ORDER BY priority, id