feat: add support of Exists and NonExists operator, fix bug with selecting columns from VALUES, grammar small fix

In case we had a join where one of tables under
Scan had bucket_id column in the middle (not in the end)
than we incorrectly updated position in ALL references in
join condition. The correct way is to update references only
for corresponding join child, which is done in this commit

Arseniy Volynets authored 1 year ago and Arseniy Volynets committed 1 year ago

- Because Unary is also a bool expression, we had
wrong conflict resolution for join (without single),
that didn't take into account that bool expression
may have Unary as one of the children.
- I also noticed a small bug for single distribution
in join, fixed it.

- Refactor 2-stage aggregation pipeline, so it is easier to read and work with
- add logic for removing duplicate grouping expressions and aggregates from local stage:
 
`select sum(a), sum(a) from t` 

We should compute only one aggregate at local stage.

The same goes for grouping expressions: 

`select sum(distinct a) from t group by a`

At local stage we must use `a` only once in projection.

This patch brings stored procedures that manage postgres server.

Make encoded parameters optional. So we can call pico.sql(SQL)
without producing an empty Lua table (that would be GCed later).

Implement the picodata engine for sbroad to integrate distributed
SQL into the picodata binary. In fact, picodata engine simple
exports public rust functions from api.rs. On the picodata side
they (and some lua functions) are imported and included into the
bunary on the build phase.

Current commit is POC and have some problems:
- DDL is still not implemented in the picodata (_pico_space is mocked);
- we include tarantool module symbols twice (first time in sbroad,
  second time in picodata binary);

But anyway, it works and all these problems should be solved in the
next commits.

We had a flaky test in CI because printing order
of keys in Distribution::Segment was random.
Changed Hasher to RepeatableState for HashSet
in Distribution::Segment

The traits to plug new engines became more clear. It would help us
while implementing the picodata engine.

tarantool uses async replication by default, and it is possible to try selecting from a replica that does not have the space or the data yet, which can cause flaky tests
now, we configure storage replicaset and enable sync replication for spaces to work with
Closes #369