This commit introduces:
 * statement and portal storages;
 * statements with parameter oids;
 * portal encoding;
 * interactive portals;

Portal encoding defines in which format (binary or text) columns
are returned.

Interactive portals allow to limit the number of rows returned from
execute method. Other rows can be extracted by calling execute again
on the same portal.

Also here we refactor all the places where we checked command line
parameters, because now PicodataConfig is the main source of this
information.

- 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"

Anatoly Popov authored 1 year ago and Dmitry Rodionov committed 1 year ago

Signed-off-by: Anatoly Popov <a.popov@picodata.io>

Maksim Kaitmazian authored 1 year ago and Denis Smirnov committed 1 year ago

Without this commit creation of a function for non-admin users fail with
`AccessDenied: Read access to space \'_pico_routine\' is denied` error.

- Update sbroad submodule to commit,
with refactored tracing api: tracer
can be provided by library user (us).
- Use tracer that creates traces under
admin, because traces are created randomly
for 1% of the queries and the user may not
have the privileges to create/modify tracing
tables
- Move tracing related logic to picodata repo.
In particular, now all tables storing tracing
- Add sql tests that were removed from sbroad
during refactoring
- added extra parameter 'query_id' to pico.sql
lua api. 'query_id' is used to identify
each query in tracing tables, if not specified
hash function on query text is used.
- changed signature of pico.sql to:
pico.sql(pattern[, params, options)
options={'traceable'=boolean,'query_id'=string}