[Mapserver-users] bug postgis query alias
Jason Thaxter
thaxter at gomoos.org
Thu Jun 3 14:59:52 EDT 2004
It looks to be unpatched in 4.2.0.
Patch (untested, but so small!):
--- mapserver-4.2.0/maplexer.l.orig Thu Jun 3 14:52:12 2004
+++ mapserver-4.2.0/maplexer.l Thu Jun 3 14:52:39 2004
@@ -391,7 +391,7 @@
<INITIAL>[a-z/\.][a-z0-9/\._\-\=]* { return(MS_STRING); }
<OBJECT_STRING>[a-z/\.][a-z0-9/\.\-\=]* { return(MS_STRING); }
-<VALUE_STRING>[a-z/\.][a-z0-9/\. \-\=]* { return(MS_STRING); }
+<VALUE_STRING>[a-z/\.][a-z0-9/\. \-\=:'<>]* { return(MS_STRING); }
<INITIAL>\n { msyylineno++; }
On Tue, Jun 01, 2004 at 01:37:49PM +0100, Mark Cave-Ayland wrote:
> Hi Vladimir,
>
> I think I know what this might be. We had a similar problem caused by
> the fact that the Mapserver lexer has a very limited set of characters
> it will let through - the symptom being that Mapserver would truncate my
> DATA clause at the offending characters (in our case it was a colon)
> whenever I used a casting such as '::bigint' in the DATA string.
>
> The patch we are currently running against 3.6.5 is the following:
>
>
> --- mapserver-3.6.5.vanilla/maplexer.l Wed Sep 18 16:14:17 2002
> +++ mapserver-3.6.5/maplexer.l Fri May 9 16:30:45 2003
> @@ -348,7 +348,7 @@
>
> <INITIAL>[a-z/\.][a-z0-9/\._\-\=]* { return(MS_STRING); }
> <OBJECT_STRING>[a-z/\.][a-z0-9/\.\-\=]* {
> return(MS_STRING); }
> -<VALUE_STRING>[a-z/\.][a-z0-9/\. \-\=]* { return(MS_STRING); }
> +<VALUE_STRING>[a-z/\.][a-z0-9/\. \-\=:'<>]* { return(MS_STRING); }
>
> <INITIAL>\n { msyylineno++; }
>
>
> This allow us to use the :'<> characers in a Mapserver DATA clause. If
> you also include a \+ in the second regex to allow a + in the data
> string then hopefully your query will work. I don't know whether this
> has already been resolved in version 4.
>
> I didn't submit this as a patch as I wasn't sure what effect it would
> have on the other fields used by Mapserver since VALUE_STRING is not
> just used for the DATA clause - one of the other developers should be
> able to comment on this.
>
>
> Hope this helps,
>
> Mark.
>
> ---
>
> Mark Cave-Ayland
> Webbased Ltd.
> Tamar Science Park
> Derriford
> Plymouth
> PL6 8BX
> England
>
> Tel: +44 (0)1752 764445
> Fax: +44 (0)1752 764446
>
>
> This email and any attachments are confidential to the intended
> recipient and may also be privileged. If you are not the intended
> recipient please delete it from your system and notify the sender. You
> should not copy it or use it for any purpose nor disclose or distribute
> its contents to any other person.
>
> > -----Original Message-----
> > From: mapserver-users-admin at lists.gis.umn.edu
> > [mailto:mapserver-users-admin at lists.gis.umn.edu] On Behalf Of
> > Vladimir Guzm?n
> > Sent: 01 June 2004 13:04
> > To: mapserver-users at lists.gis.umn.edu
> > Subject: Re: [Mapserver-users] bug postgis query alias
> >
> >
> > Yes, the query runs fine in the pgsql monitor:
> > gps=> select gid,'>' as sentido,tiempo,360-rumbo+90 as
> > rumbo,velocidad,gps_geom,oid from gps_vehi where
> > tiempo>='2004-05-31 05:00:00' and tiempo<='2004-06-02 04:59:59';
> > gid | sentido | tiempo | rumbo | velocidad |
> > gps_geom | oid
> > -------+---------+---------------------+-------+-----------+--
> -------------------------------+---------
> > 46275 | > | 2004-05-31 15:16:09 | 450 | 0 |
> > SRID=1;POINT(-74.06318 4.67302) | 7731018
> > 46276 | > | 2004-05-31 15:16:15 | 450 | 0 |
> > SRID=1;POINT(-74.06318 4.67302) | 7731019
> > 46277 | > | 2004-05-31 15:16:21 | 450 | 0 |
> > SRID=1;POINT(-74.06319 4.67301) | 7731020
> > ...
> > ...
> >
> > The error is just:
> >
> > *Warning*: MapServer Error in msDrawMap(): Failed to draw
> > layer named
> > 'puntosgps'.
> > in */usr/local/apache/htdocs/gps/index.phtml* on line *33*
> >
> >
> > Vladimir Ilich Guzm?n R.
> > ------------------------
> > http://maintask.com
> >
> >
> >
> > strk wrote:
> >
> > >On Mon, May 31, 2004 at 03:29:45PM -0500, Vladimir Guzm?n wrote:
> > >
> > >
> > >>Hello.
> > >>I'm implementing a gps tracking system.
> > >>I want to show the car's orientation like this:
> > >>http://maintask.com/test.png The layer's data is something
> > like this:
> > >>-----------------------------
> > >>gps_geom from (select gid,sentido,tiempo,360-rumbo+90 as
> > >>rumbo,velocidad,gps_geom,oid from gps_vehi where
> > tiempo>='2004-05-29
> > >>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using
> > unique gid
> > >>using srid=1
> > >>-----------------------------
> > >>The field 'sentido' contains '>'.
> > >>
> > >>The problem is that if I use something like this:
> > >>-----------------------------
> > >>gps_geom from (select gid,'>' as sentido,tiempo,360-rumbo+90 as
> > >>rumbo,velocidad,gps_geom,oid from gps_vehi where
> > tiempo>='2004-05-29
> > >>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using
> > unique gid
> > >>using srid=1
> > >>-----------------------------
> > >>The query doesn't work.
> > >>
> > >>So I had to create a column in potgres called 'sentido' and all the
> > >>rows
> > >>containing '>'.
> > >>
> > >>Is this a bug?
> > >>
> > >>
> > >
> > >What's the error message ?
> > >Can you run the query from the pgsql monitor ?
> > >--strk;
> > >
> > >
> > >
> > >>The rest of the layer:
> > >>
> > >>LAYER
> > >> NAME "puntosgps"
> > >> CONNECTIONTYPE postgis
> > >> CONNECTION "user=gps password=gps dbname=gps host=localhost" DATA
> > >>"gps_geom from (select gid,sentido,tiempo,360-rumbo+90 as
> > >>rumbo,velocidad,gps_geom,oid from gps_vehi where
> > tiempo>='2004-05-29
> > >>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using
> > unique gid
> > >>using srid=1" TYPE POINT
> > >>PROJECTION
> > >> "proj=latlong"
> > >> "datum=WGS84"
> > >>END
> > >> LABELANGLEITEM 'rumbo'
> > >> LABELITEM 'sentido'
> > >> CLASS
> > >> NAME 'Parado'
> > >> EXPRESSION ([velocidad] = 0)
> > >> SIZE 14
> > >> SYMBOL 'circle'
> > >> COLOR 0 0 215
> > >> OUTLINECOLOR 204 204 204
> > >> END
> > >> CLASS
> > >> NAME '0-10'
> > >> EXPRESSION ([velocidad] > 0 AND[velocidad] <= 10)
> > >> SIZE 14
> > >> SYMBOL 'circle'
> > >> COLOR 255 255 204
> > >> OUTLINECOLOR 204 204 204
> > >> LABEL
> > >> TYPE TRUETYPE
> > >> FORCE TRUE
> > >> FONT arial
> > >> ANTIALIAS TRUE
> > >> COLOR 0 0 0
> > >> OUTLINECOLOR 255 255 255
> > >> SIZE 8
> > >> END
> > >> END
> > >>...
> > >>...
> > >>
> > >>Thanks a lot.
> > >>
> > >>--
> > >>Vladimir Ilich Guzm?n R.
> > >>------------------------
> > >>http://maintask.com
> > >>
> > >>
> > >>_______________________________________________
> > >>Mapserver-users mailing list Mapserver-users at lists.gis.umn.edu
> > >>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> > >>
> > >>
> > >_______________________________________________
> > >Mapserver-users mailing list
> > >Mapserver-users at lists.gis.umn.edu
> > >http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> > >
> > >
> > >
> > >
> >
> >
> > _______________________________________________
> > Mapserver-users mailing list
> > Mapserver-users at lists.gis.umn.edu
> > http://lists.gis.umn.edu/mailman/listinfo/maps> erver-users
> >
>
>
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
--
----------------------------------------------
Jason Thaxter
GoMOOS, P.O. Box 4919, Portland, ME 04112-4919
Office Location: 1 Canal Plaza, 7th Floor
Office: 207.773.0423
Fax: 207.773.8672
Email: thaxter at gomoos.org
------------www.gomoos.org--------------------
More information about the mapserver-users
mailing list