[mapguide-trac] #1238: Problem handling NULL values with SDF in 2.1
final
MapGuide Open Source
trac_mapguide at osgeo.org
Sun Jan 10 08:33:46 EST 2010
#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
More information about the mapguide-trac
mailing list