SOLID Server 2.3 New Features Overview

SOLID Server 2.3
NEW FEATURES

Overview

Several SQL Functionality Enhancements
New Version of SQL Optimizer
Resiliency Against Incorrect SQL Improved
JDBC Driver Performance Optimized
New Platforms Supported: FreeBSD, Multithreaded Linux

Several SQL Functionality Enhancements

SOLID Server 2.3 introduces support for a multitude of new SQL features, including:

Keyword INNER accepted in JOIN statements

Revoking privileges at column level

Typecasting of SQL expressions

Derived tables allowed in SELECT FROM clause

CORRESPONDING supported

SELECT clauses without FROM allowed

Function UIC() supported

Subqueries accepted in UPDATE expressions

New Version of SQL Optimizer

Especially SQL statements with keywords GROUP BY and (NOT) EXISTS will generally be faster.

Resiliency Against Incorrect SQL Improved

Several validation checks have been introduced in order to make the SQL Parser more foolproof.

Client Enhancements

JDBC Driver Performance Optimized

Interface to SOLID JDBC Driver was changed to allow performance optimization in delivering query result set to JDBC client. This requires using the new SOLID JDBC Driver 2.3.

Changes to Supported Platforms

FreeBSD Supported

FreeBSD was provided previously as a 2.2 beta release. Now, with SOLID Server 2.3, FreeBSD 2.2.2 becomes a supported platform.

Multithreaded Linux Supported

Multithreaded Linux was provided previously as a 2.3 beta release.
Now, with SOLID Server 2.3 production release, it becomes a supported platform.

Using the multithreading features of SOLID Server requires the Linux system to support multiple threads, i.e. Linux kernel is v.2.0 or later and GNU C library v.2.0 (A.K.A. libc6 on Linux) or later and POSIX threads library are installed and properly configured.