[
https://issues.apache.org/jira/browse/IGNITE-4531?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vladimir Ozerov updated IGNITE-4531:
------------------------------------
Priority: Major (was: Critical)
> Update DML operation not working for @QuerySqlField with name
> -------------------------------------------------------------
>
> Key: IGNITE-4531
> URL: https://issues.apache.org/jira/browse/IGNITE-4531
> Project: Ignite
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.8
> Reporter: David Albrecht
> Assignee: Vladimir Ozerov
> Fix For: 1.9
>
> Attachments: IgniteOperationCacheTest.java
>
>
> After putting a java class Operation with
> {code}
> @QuerySqlField(name = "operationNumber", index = true)
> private String mOperationNumber;
> @QuerySqlField(index = true)
> private String mUuid;
> {code}
> 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
> {code}
> String updateQueryString = "UPDATE Operation set operationNumber = ? WHERE
> mUuid = ?";
> SqlFieldsQuery updateQuery = new SqlFieldsQuery(updateQueryString
> ).setArgs("SCHEDULED","FF42930B6D3242B5A0B9D631E017027E");
> cache.query(updateQuery);
> {code}
> 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!
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
