Wait! There is more!!! :-)
So... I decided to capture profiler information from SQL while loading brand
new map with layer off SQL Server. That is query it is running:
SELECT *
FROM dbo.Asset
with (INDEX([IX_Asset_Geo]) )
WHERE [Geo].Filter(geometry::STGeomFromText('POLYGON (
(-12335593.4182846 6455627.81656446
, -12326869.4463694 6455627.81656446
, -12326869.4463694 6460927.76609954
, -12335593.4182846 6460927.76609954
, -12335593.4182846 6455627.81656446))', 0))=1
/* AND
[Geo].MakeValid().STEnvelope().STIntersects(geometry::STGeomFromText('POLYGON
(
(-12335593.4182846 6455627.81656446
, -12326869.4463694 6455627.81656446
, -12326869.4463694 6460927.76609954
, -12335593.4182846 6460927.76609954
, -12335593.4182846 6455627.81656446))', 0))=1
*/
If I will comment AND part of the WHERE clause - I will see all features I
am looking for. If I will uncomment it (The way it is executed) - 0 results.
Any idea what that I can poke to get results I am expecting?
--
View this message in context:
http://osgeo-org.1803224.n2.nabble.com/MGOS-v2-2-Beta-and-SQL-2008-Again-tp5197257p5211054.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
