New
v1.9.6
What's Changed:
Changes
1. Very significant performance improvement:
- Enhanced the efficiency of the JOIN algorithm in the SQL layer.
- Optimized the evaluation of the ORDER BY clause.
- Huge memory usage reduction for multi-database use cases.
2. SQL feature expansion:
Several enhancements to SQL functionality, such as:
- Support for LEFT JOIN, CASE statements.
- SELECT FROM VALUES syntax.
- Support for generic expressions in ORDER BY.
- PRIMARY KEY constraints on individual columns.
3. Query handling improvements:
- Fixes to logical operator precedence and implementation of constant selection queries for better query execution.
4. Enhanced PostgreSQL compatibility:
- Added support for core PostgreSQL system catalog tables (pg_class, pg_namespace, ), improving compatibility with Postgres clients and metadata management.