Firebird 2.5 Release Notes

Table of Contents

1. General Notes

Firebird 2.5.9 Sub-release

Firebird 2.5.8 Sub-release

Firebird 2.5.7 Sub-release

Firebird 2.5.6 Sub-release

Firebird 2.5.5 Sub-release

Firebird 2.5.4 Sub-release

Firebird 2.5.3 Security Update 1

Firebird 2.5.3 Sub-release

Firebird 2.5.2 Security Update 1

Firebird 2.5.2 Sub-release

Firebird 2.5.1 Sub-release

Bug Reporting

Documentation

2. New in Firebird 2.5

Firebird 2.5.9 Release (June 2019)

Firebird 2.5.8 Release (January 2018)

Firebird 2.5.7 Release (February 2017)

Firebird 2.5.6 Release (June 2016)

Firebird 2.5.5 Release (September 2015)

Firebird 2.5.4 Release (March 2015)

Firebird 2.5.3 Security Update (December 2014)

Firebird 2.5.3 Release (July 2014)

Firebird 2.5.2 Security Update (March 2013)

Firebird 2.5.2 Release (October 2012)

Firebird 2.5.1 Release (September 2011)

Firebird 2.5 Release (October 2010)

Other New Features

3. Changes in the Firebird Engine

New Threading Architecture

Thread-safe Client Library

Improvements

4. Changes to the Firebird API and ODS

ODS (On-Disk Structure) Changes

API (Application Programming Interface) Extensions

5. Reserved Words and Changes

Clean-up of Reserved Words

Newly Reserved Words

Keywords Added as Non-reserved

6. Configuration Parameter Additions and Changes

AuditTraceConfigFile

Parameters Affecting Filesystem Cache Usage

ConnectionTimeout

Authentication

MaxUserTraceLogSize

OldSetClauseSemantics

RemoteAuxPort For Classic and Superclassic

Use Hostname for RemoteBindAddress

RemoteFileOpenAbility

7. Administrative Features

New RDB$ADMIN System Role

Trace and Audit Services

Monitoring Improvements

8. Security Hardening

Windows Platforms

9. Data Definition Language (DDL)

Quick Links

10. Data Manipulation Language (DML)

Quick Links

11. Procedural SQL (PSQL)

Quick Links

Autonomous Transactions

Borrow Database Column Type for a PSQL Variable

New Extensions to EXECUTE STATEMENT

Other PSQL Improvements

12. International Language Support (INTL)

Default COLLATION Attribute for a Database

ALTER CHARACTER SET Command

Connection Strings & Character Sets

Other Improvements

13. Command-line Utilities

fbtracemgr

Retrieve Password from a File or Prompt

gsec

fbsvcmgr

gbak

nBackup

isql

gpre (Precompiler)

gstat

14. Installation Notes

Linux (POSIX)

Windows

15. Compatibility Issues

Effects of Unicode Metadata

Configuration Parameters Removed

SQL Language Changes

Utilities

API Changes

Security Hardening

Access Path for Services

Known Platform Issues

16. Platform Ports

HPPA

IBM eServer z-Series

Linux/sh4 (Renesas SH)

HP-UX

Port for Very Old Windows 32-bit Platforms

17. Bugs Fixed

Firebird 2.5.9 Release

Firebird 2.5.8 Release

Firebird 2.5.7 Release

Firebird 2.5.6 Release

Firebird 2.5.5 Release

Firebird 2.5.4 Release

Firebird 2.5.3 Update 1 Release

Firebird 2.5.3 Release

Firebird 2.5.2 Security Update 1, March 2013

Firebird 2.5.2 Release

Firebird 2.5.1 Release

Firebird 2.5.0 Release

Old Bugs Fixed

18. Firebird 2.5 Project Teams

A. SQLSTATE

SQLSTATE Codes & Messages

B. Licence Notice