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 44C692930D
	for <tarantool-patches@freelists.org>; Tue, 21 Aug 2018 11:28:35 -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 UoYToA8rA5Tl for <tarantool-patches@freelists.org>;
	Tue, 21 Aug 2018 11:28:35 -0400 (EDT)
Received: from smtp15.mail.ru (smtp15.mail.ru [94.100.176.133])
	(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 A610D29303
	for <tarantool-patches@freelists.org>; Tue, 21 Aug 2018 11:28:34 -0400 (EDT)
Subject: [tarantool-patches] Re: [PATCH v1 1/1] sql: return a tuple result
 from SQL
References: <7e5108046f80ecc136b68e3c00d5b24de614ad99.1534863415.git.kshcherbatov@tarantool.org>
From: Vladislav Shpilevoy <v.shpilevoy@tarantool.org>
Message-ID: <ebf510fe-bca3-ea34-017f-061c917bb229@tarantool.org>
Date: Tue, 21 Aug 2018 18:28:32 +0300
MIME-Version: 1.0
In-Reply-To: <7e5108046f80ecc136b68e3c00d5b24de614ad99.1534863415.git.kshcherbatov@tarantool.org>
Content-Type: text/plain; charset=utf-8; format=flowed
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, Kirill Shcherbatov <kshcherbatov@tarantool.org>
Cc: korablev@tarantool.org

Hi!

On 21/08/2018 18:00, Kirill Shcherbatov wrote:
> @TarantoolBot document
> Title: Return a tuple result from SQL
> SQL insert/update/delete requests would return
> table with processed tuples. It is default behavior.
> 
> tarantool> box.sql.execute("CREATE TABLE t (s1 INT, s2 INT,
>                           s3 INT, s4 INT PRIMARY KEY);")
> tarantool> t = box.sql.execute("INSERT INTO t VALUES (1,1,1,2),
>                              (1,1,1,5),(1,1,1,6);")
> - - [1, 1, 1, 2]
>    - [1, 1, 1, 5]
>    - [1, 1, 1, 6]
> 
> tarantool> t[3].S4
> 6
> 
> NetBox would no return tuple metadata:
> tarantool> t_cn[1].S4
> nul
> 
> Feature may be disabled with interactive_mode pragma:
> tarantool> box.sql.execute("pragma interactive_mode=0;")
> 
> Closes #2370.

Please, do not include 'Closes' into TarantoolBot request.