postgis WMS-T generates invalid SQL

[akrherz]

Something is borked with MS 5.4.0 as my WMS-T no longer works. The SQL generated ends up having something like this included in the SQL:

select 
 "datetime",
  encode(AsBinary(force_collection(force_2d("the_geom")),'NDR'),'base64') as geom,
 "oid" 
from nexrad_n0r_tindex 
where the_geom && GeomFromText('POLYGON((-87.8766277805514 13.7287070384035,-87.8766277805514 41.226006386486,-45.1532119277844 41.226006386486,-45.1532119277844 13.7287070384035,-87.8766277805514 13.7287070384035))',find_srid('','nexrad_n0r_tindex','the_geom')) 
and date_trunc('second', datetime) = '2005-08-29T13:00:00Z') 
and date_trunc('second', datetime) = '2005-08-29T13:00:00Z'

notice the extra ")" toward the end of the statement.

pramsey on IRC asked me for something to build a test case with, will effort that. thanks

[akrherz]

Test case files

[akrherz]

Still efforting figuring out the offending URL call. I was grossly incorrect stating that this was broken all of the time with MS 5.4.0 , it appears to only blow up for certain Arc* clients.

[akrherz]

dup #2995