41 lines
1.1 KiB
SQL
41 lines
1.1 KiB
SQL
|
-- v3 达梦升级预检：只读，不修改任何数据。
|
||
|
|
-- 第一组应返回 3 行；第二、三、四组应全部为空。
|
||
|
|
|
||
|
|
-- v1 的三张 DIRECT 统计表必须已经存在。
|
||
|
|
SELECT table_name
|
||
|
|
FROM user_tables
|
||
|
|
WHERE table_name IN (
|
||
|
|
'DEVICE_DAILY_STATS',
|
||
|
|
'NORMALIZE_RULE_DAILY_STATS',
|
||
|
|
'DEVICE_COLLECT_STATS'
|
||
|
|
)
|
||
|
|
ORDER BY table_name;
|
||
|
|
|
||
|
|
-- v3 目标表必须尚未创建。若有返回，停止执行 02，先确认是否执行过 v3 或曾中途失败。
|
||
|
|
SELECT table_name
|
||
|
|
FROM user_tables
|
||
|
|
WHERE table_name IN (
|
||
|
|
'STATS_PROJECTION_OUTBOX',
|
||
|
|
'STATS_PROJECTION_APPLIED_EVENT'
|
||
|
|
)
|
||
|
|
ORDER BY table_name;
|
||
|
|
|
||
|
|
-- 约束名不得与现有对象冲突。
|
||
|
|
SELECT constraint_name, table_name
|
||
|
|
FROM user_constraints
|
||
|
|
WHERE constraint_name IN (
|
||
|
|
'PK_STATS_PROJECTION_OUTBOX',
|
||
|
|
'CK_STATS_PROJECTION_OUTBOX_STATUS',
|
||
|
|
'PK_STATS_PROJECTION_APPLIED'
|
||
|
|
)
|
||
|
|
ORDER BY constraint_name;
|
||
|
|
|
||
|
|
-- 索引名不得与现有对象冲突。
|
||
|
|
SELECT index_name, table_name
|
||
|
|
FROM user_indexes
|
||
|
|
WHERE index_name IN (
|
||
|
|
'IDX_STATS_PROJECTION_OUTBOX_DUE',
|
||
|
|
'IDX_STATS_PROJECTION_APPLIED_TIME'
|
||
|
|
)
|
||
|
|
ORDER BY index_name;
|