Opened 17 years ago

Closed 17 years ago

Last modified 17 years ago

#323 closed defect (fixed)

SQLite: Corrupt data on QueryMapFeatures call

Reported by: jbirch Owned by: traianstanev
Priority: major Milestone:
Component: SQLite Provider Version: 3.3.1
Severity: 3 Keywords:
Cc: External ID:

Description

This seems similar to the (fixed) theming problem. Certain records in the SQLite table do not respond well to selection or MapTips. The features either do not pop up the maptips, or the map does not redraw. In general, it looks like certain attributes are getting corrupted.

For instance...

Request:

OPERATION=QUERYMAPFEATURES&VERSION=1.0.0&PERSIST=0&MAPNAME=MapDefinition1&SESSION=910e9ace-ffff-ffff-8000-005056b512c0_en_7F0000010AFC0AFB0AFA&SEQ=0.0902576848931596&LAYERNAMES=LayerDefinition0&GEOMETRY=POLYGON((431293.1934429856 5446741.410383045, 431297.2029785139 5446741.410383045, 431297.2029785139 5446737.400847516, 431293.1934429856 5446737.400847516, 431293.1934429856 5446741.410383045))&SELECTIONVARIANT=INTERSECTS&MAXFEATURES=1&LAYERATTRIBUTEFILTER=5

Response:

<?xml version="1.0" encoding="UTF-8"?>
<FeatureInformation>
<FeatureSet xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="FeatureSet-1.0.0.xsd"> <Layer id="041b0baa-0000-1000-8000-005056b512c0">  <Class id="Default:Legal_Parcel">   <ID>RRkAAA==</ID>  </Class> </Layer></FeatureSet><Tooltip>STREET:  WALLACE S</Tooltip>
<Hyperlink />
<Property name="PRIMARYINDEX" value="6469" />
<Property name="PARCEL_TYPE" value="Parceᰀ " />
<Property name="PLAN" value="" />
<Property name="GISLINK" value="211766" />
<Property name="LEGAL_PID" value="025-208-55騀ልŐࠈꟈᜐ倈ᱚ凨ᱚ员ᱚ囈ᱚ夸ᱚ傰Ღelds" />
<Property name="STR_NAME" value="WALLACE S" />
<Property name="STR_NO" value="15" />
<Property name="POST_CODE" value="" />
</FeatureInformation>

or Request:

OPERATION=QUERYMAPFEATURES&VERSION=1.0.0&PERSIST=0&MAPNAME=MapDefinition1&SESSION=910e9ace-ffff-ffff-8000-005056b512c0_en_7F0000010AFC0AFB0AFA&SEQ=0.07203367059323579&LAYERNAMES=LayerDefinition0&GEOMETRY=POLYGON((431396.4389828395 5446734.3936958695, 431400.44851836783 5446734.3936958695, 431400.44851836783 5446730.384160342, 431396.4389828395 5446730.384160342, 431396.4389828395 5446734.3936958695))&SELECTIONVARIANT=INTERSECTS&MAXFEATURES=1&LAYERATTRIBUTEFILTER=5

Response:

<?xml version="1.0" encoding="UTF-8"?>
<FeatureInformation>
<FeatureSet xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="FeatureSet-1.0.0.xsd"> <Layer id="041b0baa-0000-1000-8000-005056b512c0">  <Class id="Default:Legal_Parcel">   <ID>UBkAAA==</ID>  </Class> </Layer></FeatureSet><Tooltip>STREET:  TERMINAL AVऀƲࠈ⁓⁓</Tooltip>
<Hyperlink />
<Property name="PRIMARYINDEX" value="6480" />
<Property name="PARCEL_TYPE" value="ParceḀ " />
<Property name="PLAN" value="" />
<Property name="GISLINK" value="114076" />
<Property name="LEGAL_PID" value="005-833-34⠀৩ְż਌" />
<Property name="STR_NAME" value="TERMINAL AVᰀǧЈ翄੐" />
<Property name="STR_NO" value="17" />
<Property name="POST_CODE" value="V9R 5C" />
</FeatureInformation>


Change History (2)

comment:1 by traianstanev, 17 years ago

Resolution: fixed
Status: newclosed

It should be fixed now. I had forgotten to allocate an extra character for the null terminator.

comment:2 by jbirch, 17 years ago

Yep, looks good. Thanks!

Note: See TracTickets for help on using tickets.