[mapguide-trac] #375: Join results are misaligned after no matching record found in secondary data

[MapGuide Open Source]

#375: Join results are misaligned after no matching record found in secondary
data
-------------------------------+--------------------------------------------
   Reporter:  ronnielouie      |       Owner:  ronnielouie
       Type:  defect           |      Status:  new        
   Priority:  medium           |   Milestone:  2.0        
  Component:  Feature Service  |     Version:  2.0.0      
   Severity:  major            |    Keywords:             
External_id:  1011545          |  
-------------------------------+--------------------------------------------
 Join a primary feature source to secondary data, where there is not
 necessarily a matching secondary record.  Inspect the join results via
 walking the feature reader that is returned from the SelectFeatures()
 call.  Notice that the joined data no longer matches the primary record
 after a corresponding secondary one cannot be found.

 This is best illustrated below:

 Primary join key:
 ||AB||
 ||BC||
 ||MB||
 ||NS||
 ||NF||
 ||ON||
 ||QC||
 ||YT||

 Secondary join key:
 ||AB||
 ||BC||
 ||MB||
 ||NS||
 ||NL||
 ||ON||
 ||QC||
 ||YT||

 The result of the join is

 ||Primary_key||  Secondary_key||
 ||AB||            AB||
 ||BC||            BC||
 ||MB||            MB||
 ||NS||            NS||
 ||NF||            ON||
 ||ON||            QC||
 ||QC||            YT||
 ||YT||            (null)||

 The correct result should be
 ||Primary_key|| Secondary_key||
 ||AB||            AB||
 ||BC||            BC||
 ||MB||            MB||
 ||NS||            NS||
 ||NF||            (null)||
 ||ON||            ON||
 ||QC||            QC||
 ||YT||            YT||

-- 
Ticket URL: <http://trac.osgeo.org/mapguide/ticket/375>
MapGuide Open Source <http://mapguide.osgeo.org/>
MapGuide Open Source Internals