We're updating the issue view to help you get more done. 

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

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.

Workaround

None

Acceptance Test

ChangeWithAndOperatorTest

Status

Assignee

Penina Rosenzweig

Reporter

Dixson Huie

Labels

Priority

Medium

SalesForce Case ID

None

Fix versions

Commitment Version/s

None

Due date

None

Product

None

Edition

Open Source

Platform

All