BUG-000141972 for No Product Found

Bug-ID-Nummer	BUG-000141972
Eingereicht	August 5, 2021
Zuletzt geändert	June 25, 2025
Gilt für	No Product Found
Gefunden in Version	N/A
Betriebssystem	Windows OS
Betriebssystemversion	2019 64 Bit
Status	Will Not Be Addressed

Zusätzliche Informationen

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.

Workaround

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