Uploaded image for project: 'Geode'
  1. Geode
  2. GEODE-4742

OQL operator '/' without surrounding spaces generates syntax error

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • docs, querying
    • None

    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.

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            dhardman Diane Hardman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: