Uploaded image for project: 'InsightEdge Platform'
  1. GS-13604

Change API ignores the 'AND' in SQL queries on SpaceDocument objects when one of the conditions is the SpaceId property

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Fixed
    • Affects versions: None
    • Fix versions: 14.2
    • Labels:
    • Platform:
      All
    • Acceptance Test:
      ChangeWithAndOperatorTest
    • Sprint:
    • Edition:
      Open Source

      Description

      The change API seems to not evaluate AND portion of sql clause when used with SpaceDocument.

      For example:
              SQLQuery<SpaceDocument> query = new SQLQuery<SpaceDocument>(TYPE_DESCRIPTOR_NAME, "id = ? and prop1 = ?");

              query.setParameter(1, id); // valid id
              query.setParameter(2, "bogus"); // does not match any space documents

      Above returns nothing when run with gigaSpace.readMultiple()
      However, when run with gigaSpace.change(), and only the id matches, it modifies an object.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: