laptop and a wrench

漏洞

The mobile geodatabase view definition contains 'CREATE VIEW [name of table] AS', whereas file geodatabase views and enterprise geodatabase views do not.

ArcGIS Pro
漏洞 ID 编号 BUG-000158324
已提交May 15, 2023
上次修改时间July 18, 2023
适用范围ArcGIS Pro
找到的版本3.1.1
操作系统Windows OS
操作系统版本10.0 64 Bit
状态In Review

解决办法

Database views in all types of databases use CREATE VIEW MY_VW AS to create a database view. That's standard SQL. For example, if a view were to be created in any kind of enterprise geodatabase, the Create Database View geoprocessing tool sends this SQL script to the DB: CREATE VIEW MY_VW AS... However, this is not intentionally displayed in file or enterprise geodatabase views.

Use Case: 

Since CREATE VIEW MY_VW AS is used inconsistently in the view properties of different geodatabase types, it makes it cumbersome to do things like use Python for a variety of different geodatabase types to automatically document view SQL definitions. Since Mobile geodatabases are an exception, check if the geodatabase type is a mobile geodatabase, then strip CREATE VIEW MY_VW AS from the view definition. The same applies to making Entity Relationship diagrams using automated diagramming software.

重现步骤

漏洞 ID: BUG-000158324

软件:

  • ArcGIS Pro

当漏洞状态发生变化时获得通知

下载 Esri 支持应用程序

发现关于本主题的更多内容

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项