[Geoserver-devel] [JIRA] (GEOS-7637) Including a cql_filter with arithmetic expression before IN function (i.e. PERSONS/10 IN (247757.4)) results in a parsing error.

GeoServer GeoServer Developer
1

Katey Bilz created an issue

GeoServer / BugGEOS-7637

Including a cql_filter with arithmetic expression before IN function (i.e. PERSONS/10 IN (247757.4)) results in a parsing error.

Issue Type:

BugBug

Affects Versions:

2.8.3, 2.9.0

Assignee:

Unassigned

Components:

WMS

Created:

15/Jul/16 8:24 PM

Environment:

Windows 7-64

Priority:

MediumMedium

Reporter:

Katey Bilz

Including a cql_filter with arithmetic expression before IN function (i.e. PERSONS/10 IN (247757.4)) results in a parsing error. The resulting map should just show Kansas as PERSONS IN (244574) matches that.

Request:
http://localhost:8080/geoserver/wms?service=WMS&version=1.1.0&request=GetMap&layers=topp:states&styles=&bbox=-124.73142200000001,24.955967,-66.969849,49.371735&width=768&height=330&srs=EPSG:4326&format=application/openlayers&cql_filter=(PERSONS/10)%20IN%20(247757.4

Error:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

Could not parse CQL filter list.
Encountered “/ 10 ) IN” at line 1, column 9.
Was expecting one of:
“(” …
“:” …
…
“.” …
“" …
“/” “(” …
“/” “[” …
“/” …
“/” …
“/” <DATE_TIME> …
“/” “-” …
“/” <INTEGER_LITERAL> "” …
“/” <INTEGER_LITERAL> “/” …
“/” <INTEGER_LITERAL> “+” …
“/” <INTEGER_LITERAL> “-” …
“/” <INTEGER_LITERAL> “)” “*” …
“/” <INTEGER_LITERAL> “)” “/” …
“/” <INTEGER_LITERAL> “)” “+” …
“/” <INTEGER_LITERAL> “)” “-” …
“/” <INTEGER_LITERAL> “)” “not” …
“/” <INTEGER_LITERAL> “)” “like” …
“/” <INTEGER_LITERAL> “)” “ilike” …
“/” <INTEGER_LITERAL> “)” “exists” …
“/” <INTEGER_LITERAL> “)” “does-not-exist” …
“/” <INTEGER_LITERAL> “)” “is” …
“/” <INTEGER_LITERAL> “)” “between” …
“/” <INTEGER_LITERAL> “)” “=” …
“/” <INTEGER_LITERAL> “)” “>” …
“/” <INTEGER_LITERAL> “)” “<” …
“/” <INTEGER_LITERAL> “)” “>=” …
“/” <INTEGER_LITERAL> “)” “<=” …
“/” <INTEGER_LITERAL> “)” “<>” …
“not” …
“in” …
“tequals” …
“before” …
“after” …
“during” …
“/” <INTEGER_LITERAL> “not” …
“/” <INTEGER_LITERAL> “like” …
“/” <INTEGER_LITERAL> “ilike” …
“/” <INTEGER_LITERAL> “exists” …
“/” <INTEGER_LITERAL> “does-not-exist” …
“/” <INTEGER_LITERAL> “is” …
“/” <INTEGER_LITERAL> “between” …
“/” <INTEGER_LITERAL> “=” …
“/” <INTEGER_LITERAL> “>” …
“/” <INTEGER_LITERAL> “<” …
“/” <INTEGER_LITERAL> “>=” …
“/” <INTEGER_LITERAL> “<=” …
“/” <INTEGER_LITERAL> “<>” …
Parsing : (PERSONS/10) IN (247757.4).

Add Comment

Add Comment

This message was sent by Atlassian JIRA (v1000.148.3#100005-sha1:53b5f3f)

Atlassian logo