From dev-return-31886-archive-asf-public=cust-asf.ponee.io@ignite.apache.org Mon Mar 12 21:10:43 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 37A5A18064D for ; Mon, 12 Mar 2018 21:10:43 +0100 (CET) Received: (qmail 64162 invoked by uid 500); 12 Mar 2018 20:10:42 -0000 Mailing-List: contact dev-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 dev@ignite.apache.org Received: (qmail 64149 invoked by uid 99); 12 Mar 2018 20:10:42 -0000 Received: from mail-relay.apache.org (HELO mailrelay1-lw-us.apache.org) (207.244.88.152) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 Mar 2018 20:10:42 +0000 Received: from mail-qt0-f181.google.com (mail-qt0-f181.google.com [209.85.216.181]) by mailrelay1-lw-us.apache.org (ASF Mail Server at mailrelay1-lw-us.apache.org) with ESMTPSA id 2580DAFF for ; Mon, 12 Mar 2018 20:10:40 +0000 (UTC) Received: by mail-qt0-f181.google.com with SMTP id v90so20251796qte.12 for ; Mon, 12 Mar 2018 13:10:40 -0700 (PDT) X-Gm-Message-State: AElRT7EMnEt6OYGu4BwdXOWd1bAamgmHynQWTIToxcNotfVPZ9Lp7PwL Yx4nmpqnTM+uqVuCY3Bbcb4U1K1eKnkcIv+J+WDz1g== X-Google-Smtp-Source: AG47ELs0BprjPEOwHvs6OBOiyMkQZlTBgvjixg9CMey8+swPoeFjQBh/MBJmDPSk+X+8DMGGZPSNHHAU2nQNGgIeQ0E= X-Received: by 10.237.35.76 with SMTP id i12mr13783068qtc.134.1520885440278; Mon, 12 Mar 2018 13:10:40 -0700 (PDT) MIME-Version: 1.0 Received: by 10.12.185.143 with HTTP; Mon, 12 Mar 2018 13:10:09 -0700 (PDT) In-Reply-To: References: From: Denis Magda Date: Mon, 12 Mar 2018 13:10:09 -0700 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: SQL docs: Update query with order by clause To: Vladimir Ozerov Cc: "dev@ignite.apache.org" , Alexander Paschenko Content-Type: multipart/alternative; boundary="001a113c80266990d205673cbc30" --001a113c80266990d205673cbc30 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Removed ORDER BY from the UPDATE syntax. Thanks for the clarification. -- Denis On Mon, Mar 12, 2018 at 4:57 AM, Vladimir Ozerov wrote: > ORDER BY is ignored at the moment. It will work are some point in future. > > On Thu, Mar 8, 2018 at 10:17 PM, Denis Magda wrote: > >> Hi Sergey, >> >> I=E2=80=99ll let our SQL experts to step in and clarify. >> >> Vladimir, Alex Paschenko, please chime in. >> >> Denis >> >> >> On Sunday, March 4, 2018, Guru Stron wrote: >> >>> Hi, Igniters >>> >>> I was looking into UPDATE query and currently in docs >>> there is mentioned an >>> optional ORDER BY clause, but as far as i understand it is ignored when >>> query is executed, also it is stated in H2 docs >>> (ORDER BY is >>> supported >>> for MySQL compatibility, but it is ignored.). If it is ignored, can we >>> update docs to avoid potential confusion. >>> >>> Best regards, >>> Sergey >>> >> > --001a113c80266990d205673cbc30--