Opened 9 years ago

Closed 9 years ago

#1036 closed defect (fixed)

Oracle to Sdf join does not work

Reported by: bscott Owned by: brucedechant
Priority: medium Milestone: 2.1
Component: Server Version: 2.0.2
Severity: trivial Keywords:
Cc: brucedechant External ID:

Description

Joining an sdf to an oracle feature class does not work. There is a nabble thread that discuss the issue http://n2.nabble.com/Joining-Oracle---SDF-defect-%3A-Possible-fix-to-validate-td3273905.html#a3273905

I need a GWS expert to validate that small patch

Bruno Scott

Attachments (3)

GwsJoin.patch (488 bytes) - added by bscott 9 years ago.
ORA2SDF.zip (91.3 KB) - added by bscott 9 years ago.
screenshot.gif (34.7 KB) - added by bscott 9 years ago.

Download all attachments as: .zip

Change History (8)

Changed 9 years ago by bscott

Attachment: GwsJoin.patch added

comment:1 Changed 9 years ago by brucedechant

Cc: brucedechant added

comment:2 Changed 9 years ago by brucedechant

I tested Oracle (Primary) joined to SDF (secondary) using a single join key that was a string property and it worked. This was a Left-Outer 1-Many join.

Can you clarify if you are using a composite key for the join? What is the data type of the join property? Also, what type of join are you doing - Inner/Outer?, 1-1, 1-Many?

A specific test case that shows this failing would be helpful as the test cases I have are passing.

comment:3 Changed 9 years ago 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

Changed 9 years ago by bscott

Attachment: ORA2SDF.zip added

Changed 9 years ago by bscott

Attachment: screenshot.gif added

comment:4 Changed 9 years ago by brucedechant

Owner: set to brucedechant
Status: newassigned

Thanks Bruno - I can replicate your issue now.

I have further optimized your patch by removing some unneeded code.

Could you please rerun your performance test to see if it improves your initial timings once I submit the update?

comment:5 Changed 9 years ago by brucedechant

Resolution: fixed
Status: assignedclosed

sandbox/adsk/2.1 r4078
branches/2.1 r4079
trunk r4080

Note: See TracTickets for help on using tickets.