Diane Hardman created GEODE-4742:
------------------------------------
Summary: OQL operator '/' without surrounding spaces generates
syntax error
Key: GEODE-4742
URL: https://issues.apache.org/jira/browse/GEODE-4742
Project: Geode
Issue Type: Bug
Components: querying
Reporter: Diane Hardman
The following query will generate a syntax error:
gfsh>query --query="select * from /example-region x where x.salary/2080 > 30"
Result : false
Message : Query is invalid due for error : <Syntax error in query: unexpected
token: salary>
If I add surrounding spaces, the query is successful:
gfsh>query --query="select * from /example-region x where x.salary / 2080 > 30"
Result : true
Limit : 100
Rows : 11
email | emplNumber | firstName | hoursPerWeek | lastName |
salary
-------------------------- | ---------- | --------- | ------------ | -------- |
------
frankie.fo...@example.com | 10010 | Frankie | 30 | Forth |
100000
kris.c...@example.com | 10003 | Kris | 40 | Call |
75000
bertie.b...@example.com | 10001 | Bertie | 40 | Bell |
80000
morgan.min...@example.com | 10021 | Morgan | 40 | Minnow |
80000
ricky.relia...@example.com | 10036 | Ricky | 40 | Reliable |
90000
ryan.r...@example.com | 10078 | Ryan | 40 | Redo |
75000
skyler.s...@example.com | 10091 | Skyler | 40 | Skip |
90000
dale.dri...@example.com | 10006 | Dale | 40 | Driver |
90000
pat.p...@example.com | 10028 | Pat | 40 | Puts |
75000
jessie....@example.com | 10066 | Jessie | 20 | Jam |
80000
taylor.t...@example.com | 10045 | Taylor | 40 | Tack |
100000
I tested the other operators ('+', '-', '*', '%') which all seem to work
correctly with or without surrounding spaces.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
