Description
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.Forth@example.com | 10010 | Frankie | 30 | Forth | 100000
Kris.Call@example.com | 10003 | Kris | 40 | Call | 75000
Bertie.Bell@example.com | 10001 | Bertie | 40 | Bell | 80000
Morgan.Minnow@example.com | 10021 | Morgan | 40 | Minnow | 80000
Ricky.Reliable@example.com | 10036 | Ricky | 40 | Reliable | 90000
Ryan.Redo@example.com | 10078 | Ryan | 40 | Redo | 75000
Skyler.Skip@example.com | 10091 | Skyler | 40 | Skip | 90000
Dale.Driver@example.com | 10006 | Dale | 40 | Driver | 90000
Pat.Puts@example.com | 10028 | Pat | 40 | Puts | 75000
Jessie.Jam@example.com | 10066 | Jessie | 20 | Jam | 80000
Taylor.Tack@example.com | 10045 | Taylor | 40 | Tack | 100000
I tested the other operators ('+', '-', '*', '%') which all seem to work correctly with or without surrounding spaces.