- update sbroad submodule to commit with helper
patches for dml on global tables
- add support for sql dml insert/update/delete
on global tables. Insert on conflict is not
supported yet
- Current implementation uses a single batch of
dml commands via CAS. No additional predicates
are used in CAS, so no isolation level is guaranteed
even when query only refers to global tables

1. make it non-nullable
2. fix tests

Kurdakov Alexander authored 9 months ago and Alexander Kurdakov committed 9 months ago

following sections were renamed:
tiers -> tier
peers -> peer

- rename it to proc_sql_dispatch
- modify args so that it's more suitable for public RPC API

- parse everything before executing
- support multiline sql queries
- user-friendly error messages

Georgy Moshkin authored 10 months ago and Dmitry Rodionov committed 9 months ago

Previously tests did change environment variables and since they run in
parallel this lead to other tests failing because of unexpected env
content

Co-authored-by: Dmitry Rodionov <d.rodionov@picodata.io>

Previously when running `pico.sql [[ create table foo ]]` we would get
this output:
```
---
- null
- "sbroad: rule parsing error:  --> 1:9\n  |\n1 |  create table foo \n  |  ^---\n
  \ |\n  = expected Unique"
...
```

But now the output will be:
```
---
- null
- |+
  sbroad: rule parsing error:  --> 1:9
    |
  1 |  create table foo
    |         ^---
    |
    = expected Unique

...
```

this fixes the following bug:
```
picodata run --data-dir tmp/i1/
C> invalid socket path: tmp/i1//admin.sock
[supervisor:214288] no ipc message from child
[supervisor:214288] subprocess 214289 exited with code 1
```

We don't need to replace $n with question marks any more, as we support
the pg parameters format.

See https://git.picodata.io/picodata/picodata/sbroad/-/merge_requests/377
and https://git.picodata.io/picodata/picodata/sbroad/-/issues/543.