<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><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>
<P><SPAN class=388000620-29112007><FONT color=#810081></FONT></SPAN> </P>
<P><SPAN class=388000620-29112007><FONT color=#810081>Ary Sucaya</FONT></SPAN></P>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><BR><BR></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">----- Original Message ----<BR>From: Jason Birch <Jason.Birch@nanaimo.ca><BR>To: MapGuide Users Mail List <mapguide-users@lists.osgeo.org><BR>Sent: Thursday, November 29, 2007 9:18:39 PM<BR>Subject: RE: [mapguide-users] Insert Order In MySql Affect to the MapGuideSelection?<BR><BR>
<STYLE type=text/css>DIV {
MARGIN:0px;}
</STYLE>
<DIV dir=ltr align=left><SPAN class=388000620-29112007><FONT face=Arial color=#0000ff size=2>There is an error in MapGuide with multipolygon selection</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=388000620-29112007><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=388000620-29112007><FONT face=Arial color=#0000ff size=2><A href="http://trac.osgeo.org/mapguide/ticket/313" target=_blank rel=nofollow>http://trac.osgeo.org/mapguide/ticket/313</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=388000620-29112007><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=388000620-29112007><FONT face=Arial color=#0000ff size=2>but I don't believe that this is what you are seeing, or at least not the only reason...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=388000620-29112007><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=388000620-29112007><FONT face=Arial color=#0000ff size=2>I think that the primary problem that you are seeing is because MySQL does not perform geometric operations on geometries, just their bounding boxes. My understanding is that someone is working on this for a future MySQL release, but it's a ways out yet?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=388000620-29112007><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=388000620-29112007><FONT face=Arial color=#0000ff size=2>Jason</FONT></SPAN></DIV><BR>
<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> [mapguide-users] Insert Order In MySql Affect to the MapGuideSelection?<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">I'm not sure either this is a problem of MySql or MGOS 1.2. I created some multipolygon in MySql 5.0.45 and I found a problem regarding to interactive selection:</DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">Some of my multipolygon selected when i clicked my mouse outside it's boundary. Furthermore, MGOS give me a wrong selection result, for example, if i do click on a small multipolygon A then the big multipolygon B would be selected. It's look like the biggest part of small mpolygon A occupied by the big mpolygon B. I made a little bit experiment on this issue. I change the order of records insertion meaning that i insert the smallest multipolygon first and bigger multipolygon subsequently and the problem is gone. This problem doesn't happen if i store the data in sdf format instead of MySql. What's wrong with MySql (or probably MGOS 1.2)?</DIV></DIV></DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><BR></DIV></div><br>
<hr size=1>Get easy, one-click access to your favorites.
<a href="http://us.rd.yahoo.com/evt=51443/*http://www.yahoo.com/r/hs"> Make Yahoo! your homepage.</a>
</body></html>