Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 1219B200C04 for ; Mon, 9 Jan 2017 15:04:00 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 10EAB160B3B; Mon, 9 Jan 2017 14:04:00 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 590AE160B3E for ; Mon, 9 Jan 2017 15:03:59 +0100 (CET) Received: (qmail 6533 invoked by uid 500); 9 Jan 2017 14:03:58 -0000 Mailing-List: contact issues-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ignite.apache.org Delivered-To: mailing list issues@ignite.apache.org Received: (qmail 6524 invoked by uid 99); 9 Jan 2017 14:03:58 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 09 Jan 2017 14:03:58 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id 63AC12C0453 for ; Mon, 9 Jan 2017 14:03:58 +0000 (UTC) Date: Mon, 9 Jan 2017 14:03:58 +0000 (UTC) From: "David Albrecht (JIRA)" To: issues@ignite.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (IGNITE-4531) Update DML operation not working for @QuerySqlField with name MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Mon, 09 Jan 2017 14:04:00 -0000 [ https://issues.apache.org/jira/browse/IGNITE-4531?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Albrecht updated IGNITE-4531: ----------------------------------- Description: 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} SqlFieldsQuery updateQuery = new SqlFieldsQuery("UPDATE Operation set operationNumber = ? WHERE mUuid = ?").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! was: 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. When I use {code} UPDATE Operation set operationNumber = ? WHERE mUuid = ? {code} with the arguments [SCHEDULED, FF42930B6D3242B5A0B9D631E017027E] I can see the following values: 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! > 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 > Priority: Critical > > 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} > SqlFieldsQuery updateQuery = new SqlFieldsQuery("UPDATE Operation set operationNumber = ? WHERE mUuid = ?").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.4#6332)