[mapserver-users] PostGIS query errors

[Kralidis, Tom (EC)]

Hi all: using 7.0.2 against a PostgreSQL 9.3/PostGIS 2.2 instance we're getting query errors.

I've posted a Gist at [1] to help in reporting.  Note that this functionality used to work in 6.4.x.

>From the migration guides it doesn't look like much has changed w.r.t. PostGIS syntax in
the mapfile.  Any idea what could be going on here?  It looks like the query that is constructed
by mappostgis.c is something like:

select "stn_nam","avg_wnd_dir_10m_mt58_60","avg_wnd_spd_10m_mt58_60_symbol","air_temp","stn_pres","mslp","dwpt_temp","rel_hum","observation_qa_summary","observation_qa_problem_summary",encode(ST_AsBinary(ST_Force2D("the_geom"),'NDR'),'hex') as geom,"data_payload_id" from (select * from data_mart_ca_live order by instance_datetime desc) as subquery where the_geom && ST_GeomFromText('POLYGON((-127.881959628204 63.7547758989546,-127.881959628204 70.5833900726923,-103.751686743445 70.5833900726923,-103.751686743445 63.7547758989546,-127.881959628204 63.7547758989546))',4326) and ()

Note the trailing "()".  When I remove the "()" and try direct in psql, the query works.

Any idea what could be going on here?

Thanks

..Tom

[1] https://gist.github.com/tomkralidis/26cb7214e282c144ba61598116d458e7