<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<STYLE type=text/css>DIV {
MARGIN: 0px
}
</STYLE>
<META content="MSHTML 6.00.6000.16544" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=935132121-29112007><FONT face=Arial
color=#0000ff size=2>The bounding box operations would explain why you are
getting a polygon selected even when you click outside of its boundary.
Read the note at the top of this page if you would like to confirm that this is
indeed MySQL's behaviour: <A
href="http://tinyurl.com/2mk9aa">http://tinyurl.com/2mk9aa</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=935132121-29112007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=935132121-29112007><FONT face=Arial
color=#0000ff size=2>I'm not a heavy MySQL user, but I'm pretty sure that
insertion order affects the order that rows are returned in (unless you're
explicitly ordering them, and I am pretty sure that MapGuide does
not). If this is the case, then in combination with #313 this might
explain why you are getting different polygons within the multipolygon
selected? Maybe I don't understand the issue properly.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=935132121-29112007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=935132121-29112007><FONT face=Arial
color=#0000ff size=2>If this works with multipolygon SDF files with no issues
though, it is either a problem with MySQL itself, or a problem with the MySQL
FDO provider. I would strongly encourage you to file a ticket on the FDO
Trac instance (instructions here: <A
href="http://trac.osgeo.org/fdo/wiki/SubmitTicket">http://trac.osgeo.org/fdo/wiki/SubmitTicket</A> ).
For best results, please include a description (preferably with small
screenshots illustrating the problem) and include a mysqldump of the
geometry that is causing the problem to allow the developers to easily reproduce
it.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=935132121-29112007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=935132121-29112007><FONT face=Arial
color=#0000ff size=2>Jason</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=935132121-29112007></SPAN><FONT face=Arial
color=#0000ff size=2></FONT> </DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> ary sucaya<BR><B>Subject:</B> Re:
[mapguide-users] Insert Order In MySql Affect to
theMapGuideSelection?<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><SPAN
class=388000620-29112007><FONT face=Arial color=#810081 size=2><A
href="http://trac.osgeo.org/mapguide/ticket/313" target=_blank
rel=nofollow><SPAN class=yshortcuts
id=lw_1196367831_0>http://trac.osgeo.org/mapguide/ticket/313</SPAN></A> is
not what i'm seeing now. That's another problem of multipolygon. What i don't
understand is why the sequence of records insertion affect MGOS select
behaviour? If MySql perform geometric operation only on their bounding box, then
'my selection problem' will always happens even i change the sequence of records
insertion </FONT></SPAN></DIV></DIV></BODY></HTML>