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

REST API does not support LIKE matching with ad hoc queries

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • rest (dev)
    • None

    Description

      The REST API supports both named and unnamed (a.k.a. ad hoc) queries. Named queries support additional behaviors such as binding query parameters (e.g., $1) via the body of the POST and LIKE matching (e.g., WHERE foo LIKE 'bar%'). Ad hoc queries have no mechanism for supplying bind parameters but should still be able to use LIKE matching as it requires no additional data from the caller.

      We have observed errors (with somewhat obscure error messages) when using an HTTP GET with an URL like this:
      http://35.165.170.9:8080/gemfire-api/v1/queries/adhoc?q=SELECT%20*%20FROM%20/orderrequests%20WHERE%20PizzaType%20LIKE%20"%25oni"

      Attachments

        Activity

          People

            Unassigned Unassigned
            pivotalsarge Michael W. Dodge
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: