兼容性判定
公开资料依据 · 建议 PoC 复核支持度unknown
严重度major
置信度low
依据规则my.syntax.group_by_with_rollup
迁移建议
将后缀式 GROUP BY a, b WITH ROLLUP 改为目标的 GROUP BY ROLLUP(a, b)，复杂 HAVING 可拆为 CTE/UNION ALL
判定说明
该目标库能力矩阵尚未建立此特征条目，支持情况待评估，建议 PoC 复核
库侧 / 应用侧路径
库侧改造
可行：按原汇总层级重写为 ROLLUP 或显式 GROUPING SETS
应用侧改造
可行：消费方若依赖小计行位置或 NULL 标记，需同步调整识别逻辑
推荐路线：db_side。验证建议：对照明细、小计、总计行数和值，并覆盖真实 NULL、GROUPING、HAVING 和显式 ORDER BY
规则样例
SELECT zone, state, COUNT(*) FROM master_data GROUP BY zone, state WITH ROLLUP
SELECT year, country, SUM(profit) FROM sales GROUP BY year, country WITH ROLLUP HAVING SUM(profit) > 0
参考来源
- https://open.10086.cn/panweidb/home
- https://opengauss.org/en/user-practice/carrier/jiangsuyidong/
- https://stackoverflow.com/questions/38428139/postgresqlhow-to-use-grouping-sets-cube-and-rollup-for-summary-totals
- https://dba.stackexchange.com/questions/62496/problem-translating-mysql-to-postgresql
- https://dev.mysql.com/doc/refman/8.4/en/group-by-modifiers.html
- https://www.postgresql.org/docs/16/sql-select.html
