Utility Kamala Vadlamani, Paul Vinkenoog, Norman Dunbar, Mark Rotteveel Version 1.0, 24 December 2021 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . repository; see https://github.com/FirebirdSQL/firebird-documentation Revision History 1.0 24 Dec 2021 M R • Reversed order of this document history to put the most recent change first • Documented original text by Adriano dos Santos Fernandes in docs/README.isql_enhancements.txt. 0.9 12 Jun 2021 M R • Fixed wrong scope of SET NAMES (firebird-documentation#153) • Documented connection strings

rdb$time_zone_util.database_version() from rdb$database; Returns: DATABASE_VERSION ================ 2021a Chapter 3. Data Types and Subtypes 42 Procedure TRANSITIONS RDB$TIME_ZONE_UTIL.TRANSITIONS returns with time zone) on 2021-05-02 20:00 - 2021-05-03 19:59 New York (or 2021-05-03 00:00 - 2021-05-03 23:59 UTC) with session time zone America/New_York will produce a value TIMESTAMP '2021-05-02 20:00:00 date) or CURRENT_DATE will Chapter 3. Data Types and Subtypes 59 produce either DATE '2021-05-02' or DATE '2021-05-03' depending on the actual date. Sample Date Literal Interpretations select cast('04

Firebird Wire Protocol Carlos Guzman Alvarez, Mark Rotteveel Version 0.15, 26 December 2021 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . information 0.1 4 04 Aug 2020 M R Conversion to AsciiDoc, minor copy-editing 0.1 5 26 Dec 2021 AP Document batch execution Appendix C: Revision history 39

1.9 16 Oct 2021 MR EXECUTE STATEMENT named parameters are regular identifiers (#164) 1.8 31 Jul 2021 MR Fix behaviour documented for SNAPSHOT TABLE STABILITY (#158) 1.7 23 Jul 2021 MR Remove extra extra SELECT in select syntax 1.6 13 Jun 2021 MR • Fixed wrong table title NUMERIC → DECIMAL • Fixed wrong link title DATEADD → DATEDIFF 1.5 27 Apr 2021 MR • Added missing } in regular expression characters • Improve wording of CURRENT_CONNECTION and CURRENT_TRANSACTION (see issue 96) 1.4 27 Apr 2021 MR Fixed GRANT syntax (see issue 130) Appendix H: Document History 518 Revision History 1.3 13

wurden vertauscht (#168) 1.7- de 21. November 2021 MK Übersetzung der englischen Sprachreferenz für Firebird 3.0 ins Deutsche. 1.7 16. Oktober 2021 MR EXECUTE STATEMENT-benannte Parameter sind reguläre Bezeichner (#164) 1.6 29. September 2021 MR Explizite Dokumentation der Transaktions-Isolationsstufen für ON CONNECT/ON DISCONNECT-Trigger (#163) 1.5 31. Juli 2021 MR Behebung des Verhaltens dokumentiert Juli 2021 MR Extra SELECT in Select-Syntax entfernt 1.3 13. Juni 2021 MR • Falschen Linktitel geändert: NUMERIC → DECIMAL • Falschen Linktitel geändert: DATEADD → DATEDIFF 1.2 27. April 2021 MR • Fehlende

Firebird Internals Inside a Firebird Database Norman Dunbar Version 1.2, 13 August 2021 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . repository; see https://github.com/FirebirdSQL/firebird- documentation Revision History 1.2 13 Aug 2021 RR Fix offset off by 2 bytes in Data Page — Type 0x05 — contributed by Rafael Estevam Reis (#161)