注册

char(32)创建视图后变成char(128)

王一凡 2026/05/19 106 5

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM Database Server 64 V8
DB Version: 0x7000d
03134284404-20250930-295335-20164
Msg Version: 49
Gsu level(5) cnt: 0
【操作系统】:
【CPU】:Linux
【问题描述】*:DROP VIEW VIEW_DEPLOY_HOST_MEDIA;
CREATE OR REPLACE VIEW VIEW_DEPLOY_HOST_MEDIA AS
SELECT HM.PK_HOST_MEDIA AS HOST_MEDIA_ID,
P1.PK_PROBE AS PROBE_ID, P2.PK_PROBE AS ANALYSE_ID
FROM G_DEPLOY_HOST_MEDIA HM
JOIN G_DEPLOY_HOST H ON HM.PK_DEPLOY_HOST = H.PK_DEPLOY_HOST
LEFT JOIN G_PROBE P1 ON(H.ASSET_IP = P1.PROBE_IP AND HM.INSTALL_PATH = P1.INSTALL_PATH AND P1.PROBE_TYPE='smart-collect-probe')
LEFT JOIN G_PROBE P2 ON(H.ASSET_IP = P1.PROBE_IP AND HM.INSTALL_PATH = P1.INSTALL_PATH AND P1.PROBE_TYPE='smart-collect-analyse')
WHERE HM.INSTALL_STATUS = 1 AND (HM.UNINSTALL_STATUS IS NULL OR HM.UNINSTALL_STATUS = 0);

视图执行后,PK_HOST_MEDIA字段是char(32)变成了char(128),
哪里的配置不对吗?
e596b0eaf6e0462cb498bebb0942e486.png

回答 0
暂无回答
扫一扫
联系客服