[IGNITE-4531] Update DML operation not working for @QuerySqlField with name

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.8
• Fix Version/s: 1.9
• Component/s: sql
• Assignee: Vladimir Ozerov
• Reporter: David Albrecht
• Created: 09/Jan/17 08:33
• Updated: 26/Jul/19 10:54
• Resolved: 12/Jan/17 07:50

Description

After putting a java class Operation with

    @QuerySqlField(name = "operationNumber", index = true)
    private String mOperationNumber;

    @QuerySqlField(index = true)
    private String mUuid;

in the cache. Via debug console I can see the following fields:

_val:

Operation [... ,mUuid=FF42930B6D3242B5A0B9D631E017027E, mOperationNumber = 0010, ...]

and a column named: OPERATIONNUMBER with value 0010.

The query

String updateQueryString = "UPDATE Operation set operationNumber =  ? WHERE mUuid =  ?";
SqlFieldsQuery updateQuery = new SqlFieldsQuery(updateQueryString ).setArgs("SCHEDULED","FF42930B6D3242B5A0B9D631E017027E");
cache.query(updateQuery);

results in:

Operation [... ,mUuid=FF42930B6D3242B5A0B9D631E017027E, mOperationNumber = 0010, operationNumber=SCHEDULED, ...]

and a column named: OPERATIONNUMBER with value 0010.

The column 'OPERATIONNUMBER' and the field 'mOperationNumber' is not updated!

Issue Links

• is duplicated by: IGNITE-4704 DML: field with an alias is not updated
• links to: GitHub Pull Request #1419
• links to: GitHub Pull Request #1419