[mapguide-trac] #1036: Oracle to Sdf join does not work

[MapGuide Open Source]

#1036: Oracle to Sdf join does not work
---------------------+------------------------------------------------------
 Reporter:  bscott   |         Owner:       
     Type:  defect   |        Status:  new  
 Priority:  medium   |     Milestone:  2.1  
Component:  Server   |       Version:  2.0.2
 Severity:  trivial  |    Resolution:       
 Keywords:           |   External_id:       
---------------------+------------------------------------------------------
Comment (by bscott):

 I have attached a small zip file that contains everything to reproduce.
 In the zip, there is an ORACLE folder that has SQL script to create and
 load the table in oracle. You will have to modify the LoadData.bat file to
 set the proper ORABIN et LOGIN parameters. There is also an SDF folder
 that contains the sdf.
 To reproduce
   Create the SDF connection to the COMMUNE.sdf
   Create the Oracle Connection
   On the Oracle connection add a join to the SDF
     Left Column : INSEE
     Right Column : INSEE_COMMUNE
     Type of join: Keep only left-side records
     Relationship : One-to-One

 In the zip there is also a SHP version of the Oracle table. If you try the
 same join using the SHP table instead of the Oracle one, it works.

 Bruno

-- 
Ticket URL: <http://trac.osgeo.org/mapguide/ticket/1036#comment:3>
MapGuide Open Source <http://mapguide.osgeo.org/>
MapGuide Open Source Internals