[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