BUG-000141972 for No Product Found

漏洞 ID 编号	BUG-000141972
已提交	August 5, 2021
上次修改时间	June 25, 2025
适用范围	No Product Found
找到的版本	N/A
操作系统	Windows OS
操作系统版本	2019 64 Bit
状态	Will Not Be Addressed

附加信息

We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.

解决办法

Reversing the arguments of the function 'st_intersects' allows the user to get all buildings. However, no spatial index is used and the execution takes much longer, 45 seconds as opposed to 1 second.

Select count (*)

From krb.w_bauw_stm punkte

Where

sde.st_intersects(sde.st_geomfromwkb((

Select

sde.st_asbinary(sde.st_aggr_union(bezirke.geom))

From

krb.fd_glk_verw_fe_stm_w5 bezirke

Where

bezirke.pkey IN(40000235724048, 40000235724042)), 25832), punkte.geom) = 1;

Result: COUNT (*) 1147