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