- add support for queries that use
union all operator with global tables
- for the case when global table is
used against sharded table, the global
table is materialized only on single
storage, on all other storages the
global child of union all is not
materialized

Alexander Tolstoy authored 1 year ago and Denis Smirnov committed 1 year ago

Also fix UnionAll and Except references.

BREAKING CHANGE!: local motion now means local materialization
of results on the storage without bucket calculation. The old
logic of "do nothing" was moved into none motion.

Implement delete SQL operator. It is always executed locally as we
delete already existing tuples and never change tuple buckets.
We reinvent the logic of the local motion policy (see the desclamer
in this commit) and materialize the primary keys from projection on
the storage. Then they are removed from the space via space API in
a single local transaction.