v3.22.0

Core

• [fea] Added explain results for the subqueries
• [fea] Added support for limit/offset in Delete and Update queries
• [fea] Optimized ordered indexes' cache logic to achive more cache hits and more compact cache size
• [fea] Added support for COUNT_CACHED(*)/CachedTotal() aggregation in the queries with INNER JOINS. Now it's possible to cache total count results for such queries
• [fix] Fixed SQL parsing for combinations of the subqueries and other conditions in the main query
• [fix] Fixed select functions with '.' delimiter. Previously those functios actually expected '=' as a delimiter

Fulltext

• [fea] Reworked logic for the stop-words. More details
• [fea] Added config for the base ranking algorithm. Check bm25_config field in the fulltext settings

Replication

• [fea] Fixed sync logic to allow modification of the server 's ID at runtime

Reindexer server

• [fix] Fixed SQL suggests for subqueries and certain types of the JOIN-queries

Docker

• [fea] Base docker image was updated to alpine 3.19

Build

• [fix] Fixed dependencies and build for alpine 3.15+
• [fix] Fixed Release build with GCC 13.2

Face

• [fea] Added the subqueries field to the explain mode
• [fea] Upgraded Webpack to 5.х
• [fea] Added the default values to the NS config during the mode changing
• [fix] Fixed the message about the outdated browser version after Chrome upgraded to v120.
• [fix] Fixed the settings panel layout on the Performance page, which was overlapped by the message about the outdated browser version
• [fix] Fixed the table columns auto resizing
• [fix] Fixed the table header width issue that appeared on the table resizing
• [fix] Fixed the table layout that crashed on scrolling
• [fix] Fixed the empty space between the last NS and the Total section on the Memory page
• [fix] Fixed the title changing on the NS page during a new NS creating
• [fix] Fixed the tooltip position in the sidebar menu
• [fix] Fixed the "+" button for the Expire after field