[mapguide][MG289][New] Joins do not work when join property types are different

[Ronnie Louie]

You can view the artifact detail at the following URL:

    https://mapguide.osgeo.org/servlets/Scarab/id/MG289

Type
 Defect

Artifact ID
 MG289 (Joins do not work when join property types are different)

Reported by
 Ronnie Louie
 ronnielouie (ronnie.louie at autodesk.com)

New artifact details:
---------------------------------------------------------

- Steps to Reproduce set to new value
  In Studio:
1) Load the attached SDF
2) Create an ODBC feature source using the attached MDB
3) Open the SDF Feature Source
4) Drag the ODBC feature source onto the extensions part of the SDF feature source editor
5) Click on the My Join part of the created extension
6) The join properties should be Key and ID
7) Create a layer using the SDF feature source and select My Extension as the feature class
8) Try to theme the layer

Note error dialog comes up.

Also, note that no feature are rendered in the preview.
- Summary set to new value
  Joins do not work when join property types are different
- Priority set to new value
  P2
- Artifact created
- Description set to new value
  Feature joins are not working when the join property data types are not compatible.  Comparable data types are numeric with numeric types and string with string types.  Cannot mix a comparison of numeric with string and vice versa.  Ordinarily for most RDBMS, this type of implicit type conversion is not directly supported, but for historical reasons, particularily compatibility with SDF 2.x data, the properties are always strings, which presents a problem when they are compared to a data source where the corresponding property is a numeric type.
- Artifact Status set to new value
  New
- Subcomponent set to new value
  Feature Service
- Version set to new value
  1.0.0
- Defect Severity set to new value
  High
- Target milestone set to new value
  1.0.1
- Component set to new value
  Server

---------------------------------------------------------
This message was automatically generated by Project Tracker.