[mapguide-users] BUG in SQL Server Spatial FDO provider when using filter in MG Layer

[Srecko Lipovsek]

Hi,

Filter at my test layer in MG is:
appname='app1' OR appname='app2'

This is wrong SQL Query:
SELECT  "A"."appname" 
	FROM "dbo"."tablename" AS "A" 
	WHERE A."appname"=N'app1' OR A."appname"=N'app2' AND
A.[geometry].STIsValid()=1 AND A.[geometry].STIntersects(@P1)=1

Filter text should be in brackets:
SELECT  "A"."appname" 
	FROM "dbo"."tablename" AS "A" 
	WHERE *(* A."appname"=N'app1' OR A."appname"=N'app2' *)* AND
A.[geometry].STIsValid()=1 AND A.[geometry].STIntersects(@P1)=1

Now I am getting wrong SQL Query also when Zooming and Panning:
SELECT  "A"."appname" 
	FROM "dbo"."tablename" AS "A" 
	WHERE A."appname"=N'app1' OR A."appname"=N'app2' AND
A.[geometry].STIsValid()=1 AND A.[geometry].STIntersects(convert(geometry,
@P1).STEnvelope())=1

Strange, yesterday on some other layer I get correct SQL Query at least on
Zoom and Pan!?





--
View this message in context: http://osgeo-org.1560.x6.nabble.com/BUG-in-SQL-Server-Spatial-FDO-provider-when-using-filter-in-MG-Layer-tp5049048p5082143.html
Sent from the MapGuide Users mailing list archive at Nabble.com.