Opened 15 years ago
Closed 15 years ago
#3036 closed defect (duplicate)
postgis WMS-T generates invalid SQL
Reported by: | akrherz | Owned by: | |
---|---|---|---|
Priority: | normal | Milestone: | |
Component: | PostGIS Interface | Version: | 5.4 |
Severity: | normal | Keywords: | wms-t, postgis |
Cc: |
Description
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
Attachments (1)
Change History (3)
by , 15 years ago
comment:1 by , 15 years ago
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.
Note:
See TracTickets
for help on using tickets.
Test case files