Opened 17 years ago
Closed 17 years ago
#375 closed defect (fixed)
Join results are misaligned after no matching record found in secondary data
Reported by: | ronnielouie | Owned by: | ronnielouie |
---|---|---|---|
Priority: | medium | Milestone: | 2.0 |
Component: | Feature Service | Version: | 2.0.0 |
Severity: | major | Keywords: | |
Cc: | External ID: | 1011545 |
Description
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 |
Note:
See TracTickets
for help on using tickets.
Fixed by changeset http://trac.osgeo.org/mapguide/changeset/r2636.