New in Firebird 2.0

Table of Contents

Derived Tables
PSQL Now Supports Named Cursors
Reimplemented Protocols on Windows
Reworking of Garbage Collection
Porting of the Services API to Classic is Complete
Lock Timeout for WAIT Transactions
New Implementation of String Search Operators
Reworking of Updatable Views
Additional Database Shutdown Modes Introduced
UDFs Improved re NULL Handling
Run-time Checking for Concatenation Overflow
Changes to Synchronisation Logic
Support for 64-bit Platforms
Record Enumeration Limits Increased
Debugging Improvements
Improved Connection Handling on POSIX Superserver
PSQL Invariant Tracking Reworked
ROLLBACK RETAIN Syntax Support
No More Registry Search on Win32 Servers
More Optimizer Improvements
ODS Changes

Derived Tables

A. Brinkman

Implemented support for derived tables in DSQL (subqueries in FROM clause) as defined by SQL200X. A derived table is a set, derived from a dynamic SELECT statement. Derived tables can be nested, if required, to build complex queries and they can be involved in joins as though they were normal tables or views.

More details under Derived Tables in the DML chapter.