为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:V8 (Build 2020.08.21)
【操作系统】:Window Server 2008
【CPU】:Intel Xeon E3-1240 V2
【问题描述】*:
表INCIDENTINFORMED中有一个字段"USER",查询表时结果正常:
基于该表创建一个视图:
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";
直接查询视图结果不正常:
我的数据库中大量使用了列"USER",改数据库模式十分麻烦。
你下载我们最新的版本,可以解决你这个问题
你这个视图创建的时候user可能没有加双引号