Firebird Documentation Index → Firebird 3.0.1 Release Notes
Firebird Home Firebird Home Firebird Documentation IndexNext: General Notes

Firebird 3.0.1 Release Notes

Helen Borrie (Collator/Editor)

28 October 2016 - Document v.0301-04 - for Firebird 3.0.1 Release


Table of Contents

1. General Notes
Improvements in Sub-release V.3.0.1
Bug Reporting
Documentation
2. New In Firebird 3.0
Summary of Features
Compatibility with Older Versions
3. Changes in the Firebird Engine
Remodelled Architecture
Optimizer Improvements
Other Optimizations
Remote Interface/Network Protocol
Miscellaneous Improvements
4. Changes to the Firebird API and ODS
ODS (On-Disk Structure) Changes
Application Programming Interfaces
5. Reserved Words and Changes
New Keywords in Firebird 3.0
6. Configuration Additions and Changes
Scope of Parameters
Macro Substitution
Includes
Expression of Parameter Values
Per-database” Configuration
New Parameters
Parameters Changed or Enhanced
Parameters Removed or Deprecated
7. Security
Location of User Lists
Database Encryption
New Authentication Method in Firebird 3
"Over the wire" Connection Encryption
Mapping of Users to Objects
International Character Sets for User Accounts
SQL Features for Managing Access
Pseudo-Tables with List of Users
Restriction on DROP ROLE (v.3.0.1)
8. Data Definition Language (DDL)
Quick Links
DDL Enhancements
9. Data Manipulation Language (DML)
Quick Links
Supplemental SQL 2008 Features for MERGE
Window (Analytical) Functions
Advanced Plan Output
Internal Functions
DML Improvements
10. Procedural SQL (PSQL)
Quick Links
PSQL Stored Functions
PSQL Sub-routines
Packages
DDL triggers
Scrollable (Bi-directional) Cursor Support
Exceptions with parameters
CONTINUE in Looping Logic
PSQL Cursor Stabilization
Extension of Colon Prefix Usage
SQLSTATE in Exception Handlers
EXECUTE BLOCK Run-time Errors
PSQL Body Size Limit Raised
11. Monitoring & Command-line Utilities
Monitoring
Tracing
gbak
gsec
isql
fb_lock_print
gfix
Other Tweaks
12. Compatibility Issues
Where Are the Tools?
Other Windows Changes
aliases.conf Is No More
Embedded Connections
Initializing the Security Database
Legacy Authentication
Upgrading a v.2.x Security Database
Local Connections to Superserver on Windows
Configuration Parameters
System Tables are Now Read-only
SQL Language Changes
Reserved Words
Trace Configuration Syntax
Unexpected GDSCODE Errors
Remote Client Recognition
13. Bugs Fixed
Firebird 3.0.1 Release: Bug Fixes
Firebird 3.0.0 Release: Bug Fixes
Firebird 3.0 Release Candidate 2: Bug Fixes and Minor Improvements
Firebird 3.0 Release Candidate 1: Bug Fixes and Minor Improvements
Firebird 3.0 Second Beta Release: Bug Fixes
Firebird 3.0 Second Beta Release: Improvements
Firebird 3.0 First Beta Release
Firebird 3.0 Second Alpha Release
Firebird 3.0 First Alpha Release
14. Firebird 3.0 Project Teams
A. Licence Notice

List of Tables

3.1. Matrix of Server Modes
6.1. Parameters available in databases.conf
11.1. Arguments for gbak STATISTICS Output
14.1. Firebird Development Teams
Firebird Documentation IndexNext: General Notes
Firebird Documentation Index → Firebird 3.0.1 Release Notes