Parentheses/Bracketing not maintained when transforming filters into SQL

Description

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.

Environment

Oracle 11g (11.2.0.4)

Status

Assignee

Andrea Aime

Reporter

Katey Bilz

Triage

Fix versions

Affects versions

Components

Priority

Medium
Configure