[Geoserver-devel] [JIRA] (GEOS-8926) Parentheses/Bracketing not maintained when querying Oracle Data Store

Katey Bilz created an issue

GeoServer / BugGEOS-8926

Parentheses/Bracketing not maintained when querying Oracle Data Store

Issue Type:

BugBug

Affects Versions:

2.10.2

Assignee:

Unassigned

Components:

Oracle, WMS

Created:

07/Sep/18 6:05 PM

Environment:

Oracle 11g (11.2.0.4)

Priority:

MediumMedium

Reporter:

Katey Bilz

Attempted a cql_filter with arithmetic with order of operations defined by parentheses as follows:

cql_filter=(PROP1 - 10) * 10 = 50

When converted into SQL to query the Oracle Data Store, this is converted to:
PROP1 - 10 * 10

Oracle does order of operations multiplication/division then addition/subtraction, which is in essence:
PROP1 - (10 * 10)

The parentheses/bracketing provided in the cql_filter must be maintained for the SQL filter.

Add Comment

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS


This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100091-sha1:8b1552e)

Atlassian logo