[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      |    Resolution:       
 Keywords:             |   External_id:       
-----------------------+----------------------------------------------------
Comment (by ksgeograf):

 Hmm... Annoying... Trac has removed my linefeeds... Here it is with forced
 linefeeds:

 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: [[BR]]
 LUMINAIRETYPE <> NULL[[BR]]
 LUMINAIRETYPE != NULL[[BR]]
 NOT LUMINAIRETYPE = NULL[[BR]]

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


 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#comment:1>
MapGuide Open Source <http://mapguide.osgeo.org/>
MapGuide Open Source Internals