Arseniy Volynets authored 10 months ago and Denis Smirnov committed 10 months ago

- update sbroad submodule to commit
with support of UNION operator
- add integration tests for global
tables (sharded tables were tested
in cartridge tests)
- Usage:

`select a from t union select b from t2`

- update sbroad submodule to commit with support of to_char
- add some integration tests, note: there are also
integration tests in cartridge
- This function is implemented as calling `format` on
given datetime object
- Usage:

to_char(datetime, format)

select to_char(datetime_column, 'Last updated: %Y-%m-%d') from t

Second argument is optional and could be specified as `null`:

select to_char(datetime_column, null) from t

- format is specified with the same rules as in strftime function
https://man.freebsd.org/cgi/man.cgi?query=strftime&sektion=3

BREAKING CHANGE: "name" index in the _pico_index has changed:
previously it guarantees uniqueness for a pair of (space_id,
index_name). Now index name must be unique among the cluster.
So, all the global indexes for _pico tables were renamed.

BREAKING CHANGE: _pico_index structure has changed.

The reason for refactoring is the request for the cluster wide
indexes with all possible options. The old structure didn't allow
us to support them all.

Denis Smirnov authored 11 months ago and Yaroslav Dynnikov committed 11 months ago

Support join chains and fix few parsing bugs.

(cherry picked from commit 33a6928b)

- add integration tests for pg-like
parameters.

Example usage:

pico.sql([[select $2, $1 from t]], {1, 2})

- Update sbroad submodule to commit with
grant/revoke procedure support
- Use existing mechanisms for grant/revoke
ACL opcodes for grant/revoke procedure
implementation
- Add integration tests
- Valid combinations:

all procedures: grant/revoke create/execute/drop
specific procedure: grant/revoke execute/drop

- Syntax:

grant create procedure to alice option(timeout=3)
grant execute procedure on "spam"(int) to "alex"
grant drop procedure on foo to bob
revoke drop procedure on foo from bob

- add new ddl opcode for renaming procedure
- update sbroad submodule to get sql support
- syntax:

alter procedure "foo" rename to "bar" option(timeout=3)
alter procedure "foo"(int, int) rename to "bar"

Follow-up for 46fee322

Current commit introduces
- _pico_routine replicated table
- procedure creation with SQL API

1. Add a new option picodata run --shredding to enable shredding upon xlog_remove_file_impl.
2. For test purposes additionally use the inject_errors feature to keep files after shred operation
and allow the test code to look inside and make sure that content was really shredded.

Note: this changes return values from all .proc_* stored procedures,
making them more usable, but completely breaking the compatibility with
older versions.

Closes #500