You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@geode.apache.org by "Diane Hardman (JIRA)" <ji...@apache.org> on 2018/02/28 01:36:00 UTC
[jira] [Updated] (GEODE-4742) OQL operator '/' without surrounding
spaces generates syntax error
[ https://issues.apache.org/jira/browse/GEODE-4742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Diane Hardman updated GEODE-4742:
---------------------------------
Component/s: docs
> 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: docs, querying
> Reporter: Diane Hardman
> Priority: Major
>
> 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.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)