laptop and a wrench

漏洞

Utilizing the st_geometry SQL API functions of st_difference and st_intersection would return incorrect results, they have been altered to return correct results.

上次发布: August 25, 2014 No Product Found
漏洞 ID 编号 NIM044399
已提交April 16, 2009
上次修改时间June 5, 2024
适用范围No Product Found
找到的版本9.3
修正版本9.4
状态Fixed

解决办法

Fix precision when geometry is returned as TEXT. Example:sde=#select ST_ASTEXT(ST_DIFFERENCE(ST_GEOMETRY('polygon ((1 1, 1 3, 3 3, 3 1, 1 1), (1.5 1.5, 1.5 2.5, 2.5 2.5, 2.5 1.5, 1.5 1.5))', 0), ST_GEOMETRY('polygon ((1 1, 1 2, 2 2, 2 1, 1 1))', 0)));POLYGON (( 1 2, 1.50000000 2.00000000, 1.50000000 2.50000000, 2.50000000 2.50000000, 2.50000000 1.50000000, 2.00000000 1.50000000, 2 1, 3 1, 3 3, 1 3, 1 2))Above is the correct result. The result reported in the initial CR was incorrect. Expected (as reported in the CR): POLYGON (( 1 2, 1.5 2, 1.5 2.5, 2.5 2.5, 2.5 1.5, 2 1, 2 1, 3 1, 3 3, 1 3, 1 2))sde=#select ST_ASTEXT(ST_Intersection(ST_GEOMETRY('multipolygon (((1 1, 4 1, 4 4, 1 4, 1 1)),((5 1, 8 1, 8 4, 5 4, 5 1)))', 0), ST_GEOMETRY('multilinestring ((2 2, 3 3),(2 2.2, 3 3.2))', 0)));MULTILINESTRING (( 2 2, 3 3),( 2.00000000 2.20000000, 3.00000000 3.20000000))

重现步骤

漏洞 ID: NIM044399

软件:

  • No Product Found

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

下载 Esri 支持应用程序

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

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项