Release Notes: Configurable access was implemeted for databases, external tables, and UDF libraries. Changes in parser include sub-selects inside COALESCE function and parameter ordering. Fixes were made for the wrong type of event delivery (unnecessary usage of OOB packets), and server crashes in some Services API operations.
Release Notes: NULLs are allowed in unique constraints and indices (SQL-99 spec). It's now possible to return values from the dynamic SQL. Various issues with events used on multihomed hosts have been fixed. It's possible to set up a definite port for event processing. A bug with an aggregate sub-query inside an IN clause has been fixed. The Services API is enabled for POSIX CS builds. Some resource leaks and problems with RECREATE VIEW have been fixed. The VIO undo log now uses a B+ tree to store savepoint record data. It improves performance when doing multiple updates of a record in a single transaction.
Release Notes: Faster selects and speed-ups for index operations (IA32 CPU architecture only) were implemented. A list of currently active transactions is now available via isc_database_info call, and sub-selects in SET clause of UPDATE now can use indices. Some fixes were also made for server crashes due to problems in the optimizer, server hangs during disconnect after mass updates, ineffective PLANs made by the optimizer for SPs and views, stack overflow during statement preparation, and a server crash during service manager operations.
Release Notes: When forced writes are disabled, you can now control how often dirty pages are flushed to disk. The security database was renamed to security.fdb, and connections to the security database are now cached. A problem where the guardian service could not stop the server was fixed, as was one where the client library could not be loaded. The server no longer crashes while retrieving statistics, ISQL can now extract universal triggers, and views no longer affect the result of a query.
Release Notes: Merging (SORT MERGE plans) is now done via an in-memory sorting module . The internal implementation of the memory manager has been changed for better performance. There are better optimizations of "complex" JOIN queries. CREATE VIEW changes : PLAN subclause is not allowed, and aggregate tracking behavior has changed (backwards compatibilty within aggregates has been introduced). There are IB7-compliant functions to return the version of the client library: isc_get_client_version(), isc_get_client_major_version(), and isc_get_client_minor_version().
Release Notes: This release is the first version based on a new, cleaned up and improved C++ source code tree with many new features and bugs fixed. It has ORDER BY in subqueries, improvements in FIRST/SKIP, and new improvements (or fixes if you like) in the optimizer.