From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <tarantool-patches-bounce@freelists.org>
Received: from localhost (localhost [127.0.0.1])
	by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 68F4F220AC
	for <tarantool-patches@freelists.org>; Mon,  2 Jul 2018 03:17:49 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
	by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id r1mh8USUKvs4 for <tarantool-patches@freelists.org>;
	Mon,  2 Jul 2018 03:17:49 -0400 (EDT)
Received: from smtpng1.m.smailru.net (smtpng1.m.smailru.net [94.100.181.251])
	(using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
	(No client certificate requested)
	by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id CAFFC2208E
	for <tarantool-patches@freelists.org>; Mon,  2 Jul 2018 03:17:48 -0400 (EDT)
Subject: [tarantool-patches] Re: [PATCH v2 1/1] sql: disallow returning
 many rows from subselect
References: <FC4E732A-6AEB-4288-BC42-E2F04F8147D4@tarantool.org>
 <7815ec2cb5cfb0d837478cff88fe4ba95503e8d7.1530113937.git.kshcherbatov@tarantool.org>
 <B374F578-8B54-42C2-80F0-96051883D7E0@tarantool.org>
 <e4103509-5dac-0b30-49b6-48859f0a357b@tarantool.org>
 <F935E91B-A4CB-4ECA-9D1B-994635A71323@tarantool.org>
From: Kirill Shcherbatov <kshcherbatov@tarantool.org>
Message-ID: <80d9fc88-3030-764b-55f2-86d6e5e33f03@tarantool.org>
Date: Mon, 2 Jul 2018 10:17:46 +0300
MIME-Version: 1.0
In-Reply-To: <F935E91B-A4CB-4ECA-9D1B-994635A71323@tarantool.org>
Content-Type: text/plain; charset=utf-8
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Sender: tarantool-patches-bounce@freelists.org
Errors-to: tarantool-patches-bounce@freelists.org
Reply-To: tarantool-patches@freelists.org
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <tarantool-patches-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: tarantool-patches <tarantool-patches.freelists.org>
List-subscribe: <tarantool-patches-request@freelists.org?Subject=subscribe>
List-owner: <mailto:>
List-post: <mailto:tarantool-patches@freelists.org>
List-archive: <http://www.freelists.org/archives/tarantool-patches>
To: tarantool-patches@freelists.org, "n.pettik@corp.mail.ru" <n.pettik@corp.mail.ru>

> Please, use upper-case for all SQL keywords (here and in other SQL tests you modified).
-        CREATE TABLE t5(a int primary key, b int);
+        CREATE TABLE t5(a INT PRIMARY KEY, b INT);

-        SELECT b from t5 WHERE a = (SELECT a FROM t5 WHERE b=6);
+        SELECT b FROM t5 WHERE a = (SELECT a FROM t5 WHERE b=6);

-        SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=6 LIMIT (select b-1 from t1 where a =1));
+        SELECT b FROM t1 WHERE a = (SELECT a FROM t1 WHERE b=6 LIMIT (SELECT b-1 FROM t1 WHERE a =1));


-        SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=6 LIMIT (select b from t1 where a =1));
+        SELECT b FROM t1 WHERE a = (SELECT a FROM t1 WHERE b=6 LIMIT (SELECT b FROM t1 WHERE a =1));