SQL docs: Update query with order by clause

[Sergey Stronchinskiy]

Hi, Igniters

I was looking into UPDATE query and currently in docs
<https://apacheignite-sql.readme.io/docs/update> 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
<http://www.h2database.com/html/grammar.html#update> (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

[Denis Magda]

Hi Sergey,

I’ll let our SQL experts to step in and clarify.

Vladimir, Alex Paschenko, please chime in.

Denis

On Sunday, March 4, 2018, Guru Stron <[hidden email]> wrote:

> Hi, Igniters
>
> I was looking into UPDATE query and currently in docs
> <https://apacheignite-sql.readme.io/docs/update> 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
> <http://www.h2database.com/html/grammar.html#update> (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
>

[Vladimir Ozerov]

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 <[hidden email]> wrote:

> Hi Sergey,
>
> I’ll let our SQL experts to step in and clarify.
>
> Vladimir, Alex Paschenko, please chime in.
>
> Denis
>
>
> On Sunday, March 4, 2018, Guru Stron <[hidden email]> wrote:
>
>> Hi, Igniters
>>
>> I was looking into UPDATE query and currently in docs
>> <https://apacheignite-sql.readme.io/docs/update> 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
>> <http://www.h2database.com/html/grammar.html#update> (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
>>
>

[dmagda]

Removed ORDER BY from the UPDATE syntax. Thanks for the clarification.

--
Denis

On Mon, Mar 12, 2018 at 4:57 AM, Vladimir Ozerov <[hidden email]>
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 <[hidden email]> wrote:
>
>> Hi Sergey,
>>
>> I’ll let our SQL experts to step in and clarify.
>>
>> Vladimir, Alex Paschenko, please chime in.
>>
>> Denis
>>
>>
>> On Sunday, March 4, 2018, Guru Stron <[hidden email]> wrote:
>>
>>> Hi, Igniters
>>>
>>> I was looking into UPDATE query and currently in docs
>>> <https://apacheignite-sql.readme.io/docs/update> 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
>>> <http://www.h2database.com/html/grammar.html#update> (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
>>>
>>
>

[dsetrakyan]

Can we at least print out a warning that the ORDER BY is being ignored? To
avoid log flooding, we should only print it out the first time we encounter
this situation.

D.

On Mon, Mar 12, 2018 at 1:10 PM, Denis Magda <[hidden email]> wrote:

> Removed ORDER BY from the UPDATE syntax. Thanks for the clarification.
>
> --
> Denis
>
> On Mon, Mar 12, 2018 at 4:57 AM, Vladimir Ozerov <[hidden email]>
> 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 <[hidden email]>
> wrote:
> >
> >> Hi Sergey,
> >>
> >> I’ll let our SQL experts to step in and clarify.
> >>
> >> Vladimir, Alex Paschenko, please chime in.
> >>
> >> Denis
> >>
> >>
> >> On Sunday, March 4, 2018, Guru Stron <[hidden email]> wrote:
> >>
> >>> Hi, Igniters
> >>>
> >>> I was looking into UPDATE query and currently in docs
> >>> <https://apacheignite-sql.readme.io/docs/update> 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
> >>> <http://www.h2database.com/html/grammar.html#update> (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
> >>>
> >>
> >
>