Opened 11 years ago

Closed 11 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

Change History (1)

comment:1 Changed 11 years ago by ronnielouie

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.