Uploaded image for project: 'Olingo'
  1. Olingo
  2. OLINGO-1098

Incorrect handling of SQL wildcards '_' and '%' on filtering

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • V2 2.0.8
    • V2 2.0.9
    • odata2-jpa
    • None

    Description

      When an OData filter contains the SQL wildcards '%' and '_', these are incorrectly translated into database queries which contain these characters unescaped, leading to incorrect search results.

      Suggestion is to create positional parameterized queries.

      Attachments

        1. JPASQLQueryFix.diff
          10 kB
          Ramya

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. OLINGO-1311 Can not get entity with string key containing "_"

          • Major - Major loss of function.
          • Closed

          Activity

            People

              chrisam Christian Amend
              ramya.vasanth Ramya
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: