[MapServer-users] Mapserver 8 rc1

[Steve Lime]

Hmmm... Wasn't an intentional omission. If you have logging turned on and
can see the resulting SQL, does the !BOX! get replaced but just incorrectly
or is the !BOX! still in the SQL.

On Wed, Aug 24, 2022 at 5:16 PM Scott <public at postholer.com> wrote:

> I've installed 8rc1 and I've run into an issue. I didn't see anything in
> the change log, so I'll put it here.
>
> The !BOX! variable that has been historically available doesn't seem to
> be supported with CONNECTIONTYPE POSTGIS any longer. For instance:
>
>     DATA "geom from (
>        select
>           geom
>        from sometable
>        where st_intersects(geom, !BOX!)
>     ) as sq using unique geom using srid=4269"
>
> ...will throw an error:
>
> <?xml version='1.0' encoding="UTF-8" standalone="no" ?>
> <!DOCTYPE ServiceExceptionReport SYSTEM
> "http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd">
> <ServiceExceptionReport version="1.1.1">
> <ServiceException>
> msDrawMap(): Image handling error. Failed to draw layer named
> 'wptsAll'.
> msPostGISLayerWhichShapes(): Query error. Failed to build query SQL.
> msPostGISBuildSQL(): General error message. Failed to build SQL
> 'where'.
> </ServiceException>
> </ServiceExceptionReport>
>
> If I remove the !BOX! it will work.
>
> Thanks!
> Scott
>
> --
> www.postholer.com
> _______________________________________________
> MapServer-users mailing list
> MapServer-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20220825/87bf6801/attachment.htm>