This would sometimes result in exceptions being thrown if a call was
made in the middle of a schema change.

This will be changed in a second

To run the test you need xk6 installed
(https://github.com/tarantool/xk6-tarantool).

Now it is possible to make the second argument (query parameters)
optional. I.e. now we support 'pico.sql([[select * from t]])' as
well as 'pico.sql([[select * from t where a = ?]], {1})'.

Egor Ivkov authored 1 year ago and Егор Ивков committed 1 year ago

They should cover all the cases specified in the CaS Design Document

Current commit introduces distributed SQL in picodata (we use
'sbroad' library). Now it is possible to execute cluster-wide
SQL with 'pico.sql([[query]], {params})' lua method.

Current limitations:
1. DDL is still not implemented in picodata, so space sharding
   is mocked by '_pico_space' space (we'll remove it later).
2. We still have duplicating symbols of the Tarantool module in
   sbroad and in picodata rlibs.
3. We need to reuse piocdata's sharding functions and handle the
   case when different spaces in the query have different sharding
   functions.

Co-authored-by: Georgy Moshkin <gmoshkin@picodata.io>

Dmitry Travyan authored 1 year ago and Yaroslav Dynnikov committed 1 year ago

This patch introduces `picodata connect` CLI command. It allows
connecting to interactive lua console of a picodata instance via iproto
The whole implementation comes down to invoking a lua script with
`require("console").start()`.

* _picodata_index keys now include space_id
* _picodata_space distribution type changed to "array"
* _picodata_space format type changed to "array"
* add Spaces::insert and Indexes::insert methods
* Ddl now has #[serde(tag = "kind", rename_all = "snake_case")]
* Dml now has #[serde(tag = "op_kind", rename_all = "snake_case")]
* Distribution now has #[serde(tag = "kind", rename_all = "snake_case")]