[24.1.1] - 2024-02-09 - Slightly change calendar versioning semantics, now it's `YY.MINOR` instead of `YY.0M`. CLI - New `picodata admin` command connects to an instance via unix socket under the admin account, see [Tutorial — Connecting — Admin console]. - New `picodata connect` implementation provides a console interface to the distributed SQL, see [Tutorial — Connecting — SQL console] - New option `picodata run --admin-sock` replaces `--console-sock` which is removed. The default value is `<data_dir>/admin.sock`. - New option `picodata run --shredding` enables secure removing of data files (snap, xlog). - New option `picodata run --log` configures the diagnostic log. - New option `picodata run --memtx-memory` controls the amount of memory allocated for the database engine. [Tutorial — Connecting — Admin console]: https://docs.picodata.io/picodata/24.1/tutorial/connecting/#admin_console [Tutorial — Connecting — SQL console]: https://docs.picodata.io/picodata/24.1/tutorial/connecting/#sql_console SQL - Global tables now can be used in the following queries: SELECT SELECT ... EXCEPT SELECT ... UNION ALL SELECT ... WHERE ... IN (SELECT ...) SELECT ... JOIN SELECT ... GROUP BY - `ALTER USER ... WITH LOGIN` can now unblock a user, who was blocked due to exceeding login attempts. Fixes - Revoke excess privileges from `guest` - Fix panic after `ALTER USER "alice" WITH NOLOGIN` - Repair `picodata connect --auth-type=ldap` - Picodata instances will no longer ignore raft entries which failed to apply. Instead now the raft loop will keep retrying the operation forever, so that admin has an opportunity to fix the error manually. Raft entries should never fail to apply, so if this happens please report a bug to us. Compatibility - System table `_pico_replicaset` now has a different format: the field `master_id` is replaced with 2 fields `current_master_id` and `target_master_id`. - All `.proc_*` stored procedures changed their return values. An extra top level array of 1 element is removed. - The current version is NOT compatible with prior releases. It cannot be started with the old snapshots.