[mapguide-trac] #1238: Problem handling NULL values with SDF in 2.1 final

[MapGuide Open Source]

#1238: Problem handling NULL values with SDF in 2.1 final
-------------------------+--------------------------------------------------
   Reporter:  ksgeograf  |       Owner:       
       Type:  defect     |      Status:  new  
   Priority:  low        |   Milestone:       
  Component:  Web API    |     Version:  2.1.0
   Severity:  minor      |    Keywords:       
External_id:             |  
-------------------------+--------------------------------------------------
 If a datasource has NULL values, it is impossible to read data from the
 Http interface.

 See SDF file attached to ticket #1228.

 Using the test page:
 http://localhost/mapguide/mapagent/selectfeaturesform.html

 Attempting to read features gives:
 "Value for LUMINAIRETYPE property is null"

 Attempting various ways to overcome this with a filter always returns an
 empty result set:
 LUMINAIRETYPE <> NULL
 LUMINAIRETYPE != NULL
 NOT LUMINAIRETYPE = NULL

 It seems as if any filter returns an empty result set:
 LUMINAIRETYPE LIKE '*'
 LUMINAIRETYPE = NULL
 LUMINAIRETYPE > 5

 The last one should give an error as LUMINAIRETYPE is a string column.

 Perhaps the data is somehow broken, but it is possible to view the data by
 creating a FeatureSource and using the "Preview" function in
 Maestro/Studio.

-- 
Ticket URL: <https://trac.osgeo.org/mapguide/ticket/1238>
MapGuide Open Source <http://mapguide.osgeo.org/>
MapGuide Open Source Internals