Ticket #3312 (reopened defect)

Opened 2 years ago

Last modified 2 years ago

Property name in camelcase contains in an OGC filter caused a Postgis error

Reported by: nsavard Owned by: mapserverbugs
Priority: normal Milestone: 6.0 release
Component: WFS Server Version: svn-trunk (development)
Severity: normal Keywords: wfs1.1 getfeature camelcase
Cc: assefa

Description

The property name appearing in a filter of a getfeature request has to be quoted.

The request and the error: 

select "description","name","intProperty","uriProperty","measurand","dateTimeProperty","dateProperty","decimalProperty","id",encode(AsBinary(force_collection(force_2d("the_geom")),'NDR'),'hex') as geom,"id" from primitivegeofeature where the_geom && GeomFromText('POLYGON((500000 500000,500000 500075,500575 500075,500575 500000,500000 500000))',4326) and ( (intProperty> 100) );  
ERROR:  column "intproperty" does not exist

Change History

Changed 2 years ago by assefa

  • status changed from new to closed
  • resolution set to duplicate

closing this as duplicate of #3311

Changed 2 years ago by nsavard

  • status changed from closed to reopened
  • resolution duplicate deleted

The problem still appear when executing the following tests:

Group: GetFeature?-Post: wfs-1.1.0-Basic-GetFeature?-tc20.1 wfs-1.1.0-Basic-GetFeature?-tc41.1

Note: See TracTickets for help on using tickets.