[tarantool-patches] Re: [PATCH v1 1/1] sql: disallow returning many rows from subselect

  • From: Kirill Yukhin <kyukhin@xxxxxxxxxxxxx>
  • To: tarantool-patches@xxxxxxxxxxxxx
  • Date: Tue, 3 Jul 2018 11:06:30 +0300

Hello,
On 18 июн 14:55, Kirill Shcherbatov wrote:

Branch: 
http://github.com/tarantool/tarantool/tree/kshch/gh-2366-whith-select-subquery
Issue: https://github.com/tarantool/tarantool/issues/2366

To follow ANSI SQL standard we should dissallow returning
multiple rows from subselects. To achieve this goal we have
introduced some special Select SF_SingleRow flag that indicates
the case of subselect having no client-defined LIMIT 1 to patch
system implicit LIMIT 1 to be LIMIT 2 and generate some extra
bytecode to HALT execution on reaching this restrict.
The place of patching LIMIT expression iValue is a very special:
this showld be done after simplifying epression tree(as this
restrict could become useless), but before generating related
bytecode.
I've checked in the patch into 2.0 branch.

--
Regards, Kirill Yukhin

Other related posts: