Wrong query results on SDE layer

Howard Butler hobu at IASTATE.EDU
Fri Mar 4 12:36:58 EST 2005


>
>
>This was the first thing I tried. But after that I didn't get any query
>results :-(
>As far as I remember, even the SDE raster layers were broken.

Hmm... then it must be something related to the LayerInfo caching.  I
though we'd cleaned those issues up, but we must not have.  What I suspect
is going on is that the state_id of the layers are getting confused when
going through the caching mechanism, and it is attempting to query against
a state_id that doesn't exist for another layer.  It is possible first
state_id is being cached and then used for all subsequent queries.  This
would definitely produce wrong/inconsistent results, especially for layers
that do not have a state_id that is above the one being used for queries.

If possible, could you do some printf output and print the value of
sde->state_id as it goes through and queries things?  If this value stays
the same, I'm almost positive this is the problem.

Another thing that might be possible to try is to not set a version string
in the DATA member.  Although it is probably that your aren't doing
anything with versioned queries anyway.

Howard



More information about the mapserver-dev mailing list