SQL docs: Update query with order by clause

[Guru Stron <gu...@gmail.com>]

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

Re: SQL docs: Update query with order by clause

[Dmitriy Setrakyan <ds...@apache.org>]

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 <dm...@apache.org> wrote:

> Removed ORDER BY from the UPDATE syntax. Thanks for the clarification.
>
> --
> Denis
>
> On Mon, Mar 12, 2018 at 4:57 AM, Vladimir Ozerov <vo...@gridgain.com>
> 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 <dm...@gridgain.com>
> 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 <gu...@gmail.com> 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
> >>>
> >>
> >
>

Re: SQL docs: Update query with order by clause

[Denis Magda <dm...@apache.org>]

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

--
Denis

On Mon, Mar 12, 2018 at 4:57 AM, Vladimir Ozerov <vo...@gridgain.com>
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 <dm...@gridgain.com> 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 <gu...@gmail.com> 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
>>>
>>
>

Re: SQL docs: Update query with order by clause

[Vladimir Ozerov <vo...@gridgain.com>]

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 <dm...@gridgain.com> 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 <gu...@gmail.com> 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
>>
>

Re: SQL docs: Update query with order by clause

[Denis Magda <dm...@gridgain.com>]

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 <gu...@gmail.com> 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
>