注册

视图中有列遇到关键字“USER”时,查询结果不正确,【急】

张聪 2021/11/30 1379 8 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:V8 (Build 2020.08.21)
【操作系统】:Window Server 2008
【CPU】:Intel Xeon E3-1240 V2
【问题描述】*:
表INCIDENTINFORMED中有一个字段"USER",查询表时结果正常:
image.png

基于该表创建一个视图:

CREATE VIEW XXX."F_INCIDENTINFORMED1" ( "ITEM_TYPE_ID" , "SOURCE_ID" , "SOURCE_ID_ITI" , "RELATED_ID" , "RELATED_ID_ITI" , "IS_RELEASED" , "MODIFIED_BY_ID" , "MODIFIED_BY_ID_ITI", "STATE" , "STATE_ITI" , "MINOR_REV" , "USER" , "USER_ITI" , "IS_CURRENT" , "DELETED" , "TENANT" , "MAJOR_REV" , "VERSIONGROUP" , "OPERATION" , "OPERATION_ITI" , "SUPPORTLEVEL" , "SUPPORTLEVEL_ITI" , "CREATED_ON" , "SORT_ORDER" , "KEYED_NAME" , "ENABLED" , "ID" , "MODIFIED_ON" , "CREATED_BY_ID" , "CREATED_BY_ID_ITI" ) AS SELECT "ITEM_TYPE_ID" , "SOURCE_ID" , "SOURCE_ID_ITI" , "RELATED_ID" , "RELATED_ID_ITI" , "IS_RELEASED" , "MODIFIED_BY_ID" , "MODIFIED_BY_ID_ITI", "STATE" , "STATE_ITI" , "MINOR_REV" , "USER" , "USER_ITI" , "IS_CURRENT" , "DELETED" , "TENANT" , "MAJOR_REV" , "VERSIONGROUP" , "OPERATION" , "OPERATION_ITI" , "SUPPORTLEVEL" , "SUPPORTLEVEL_ITI" , "CREATED_ON" , "SORT_ORDER" , "KEYED_NAME" , "ENABLED" , "ID" , "MODIFIED_ON" , "CREATED_BY_ID" , "CREATED_BY_ID_ITI" FROM XXX."INCIDENTINFORMED";

直接查询视图结果不正常:
image.png

我的数据库中大量使用了列"USER",改数据库模式十分麻烦。

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