Features with similar join property values are not drawn in theme layer

[migueaguilera]

I have experienced this problem with a SDF feature source with a Join to a SQL Server View. Theme layers based on that feature class fail to draw with the proper style the features with have similar values in the join property.

For example, the feature with the join property value "CD000_HO027_" is drawn well, but the feature with the join property value "CD000_HO027A" always is drawn with the default style.

If I replace the value "CD000_HO027_" with "CD000_HO027B" in the SDF feature property and also in the corresponding SQL Server row, then "CD000_HO027A" and "CD000_HO027B" features are both drawn with the correct style.

Perhaps the reason is that both features have similar values and/or the underscore character?

[jng]

Look at the data in the feature source preview, this will tell you if the joined property values are lining up correctly (they should, but MapGuide uses a buggy join algorithm which is known to produce incorrect results).

Are you on the beta program for AIMS 2013? The beta may include r6333, which pretty much ensures the most optimal join algorithm is used for most feature joins (SDF joined to any data source before r6333 did not use the optimal algorithm)

[jng]

Please test against the 2.4 preview release (or upcoming beta) and close if your issue has been resolved. Otherwise please update this ticket with either additional information or test data.