[mapguide][MG289][Modified] 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)

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

The following modifications were made to this artifact:
---------------------------------------------------------------------

Added following comment to artifact::

Fixed situation where primary data value is string type and represents a number with decimals.  Previously this was always treated as string which leads to unsuccessful join because the primary and secondary values would not be equal.

The fix involves identifying if the primary data value is a number, and if the secondary data type is also a number, then the FdoComparisonOperator_EqualsTo is used.

Example:

Previous behavior:
   Primary Value: "'115.0000'" (string)
   Secondary Value: 115 (integer)
   Result: No join occurrs because "'115.000'" not comparable to 115

New behavior
   Primary Value: "'115.0000" (string) becomes 115.0000 (double)
   Secondary Value: 115 (integer)
   Result: Join successful because 115.0000 is comparable to 115




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