BUG-000141972 for No Product Found

Número de ID do Erro	BUG-000141972
Enviado	August 5, 2021
Última Modificação	June 25, 2025
Aplica-se à	No Product Found
Versão encontrada	N/A
Sistema Operacional	Windows OS
Versão do Sistema Operacional	2019 64 Bit
Status	Will Not Be Addressed

Informações Adicionais

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.

Solução Provisória

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