[tarantool-patches] Re: [PATCH v1 1/1] sql: return a tuple result from SQL
Vladislav Shpilevoy
v.shpilevoy at tarantool.org
Tue Aug 21 18:28:32 MSK 2018
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.
More information about the Tarantool-patches
mailing list