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 <dma...@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 <gurustronpub...@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 >> >