[fdo-trac] #323: SQLite: Corrupt data on QueryMapFeatures call

[FDO]

#323: SQLite: Corrupt data on QueryMapFeatures call
-------------------------------+--------------------------------------------
   Reporter:  jbirch           |       Owner:  traianstanev
       Type:  defect           |      Status:  new         
   Priority:  major            |   Milestone:              
  Component:  SQLite Provider  |     Version:  3.3.1       
   Severity:  3                |    Keywords:              
External_id:                   |  
-------------------------------+--------------------------------------------
 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>


 }}}

-- 
Ticket URL: <https://trac.osgeo.org/fdo/ticket/323>
FDO <http://fdo.osgeo.org/>
Feature Data Objects