Firebird Internals Inside a Firebird Database Norman Dunbar Version 1.2, 13 August 2021 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 2. Database Structure. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 3. Standard Database Page Header. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 4. Database Header Page — Type 0x01

5.1. DATABASE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104 5.1.1. CREATE DATABASE . . . 104 5.1.2. ALTER DATABASE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 110 5.1.3. DROP DATABASE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 353 7.6.3. Database Triggers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 5.1.3. The security database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 6.1. Connection strings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 6.1.1. Local connection strings . 29 6.1.2. TCP/IP connection strings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 6.1.3. XNET connection strings. . . . . .

5.1. DATABASE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79 5.1.1. CREATE DATABASE . . . 79 5.1.2. ALTER DATABASE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84 5.1.3. DROP DATABASE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 266 7.5.3. Database Triggers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

....... 20 Connection strings ........................................................................................................................ 20 Connecting to an existing database ........... ................................................................................. 22 Creating a database using isql .................................................................................... .......................................................................... 28 How to corrupt a database ...............................................................................................

12 8. Connecting To A Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 8.1. Connection Strings . . . . . . . . 15 8.1.2. Legacy Connection Strings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 8.1.3. Using Database Aliases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 9. Creating A Database. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

................. 88 DATABASE .............................................................................................................................. 88 CREATE DATABASE ...................... ........................................................... 90 Необязательные параметры CREATE DATABASE ............................................. 91 Кто может создать базу данных? .............. ..................................................................................... 92 ALTER DATABASE ...............................................................................................

100 335544338 from_no_match No match for first value expression 100 335544354 no_record Invalid database key 100 335544367 segstr_eof Attempted retrieval of more segments than exist 100 335544374 stream_eof fetch past the last record in a record stream 0 335741039 gfix_opt_SQL_dialect -sql_dialect set database dialect n -84 335544554 nonsql_security_rel Table/procedure has non-SQL security class defined duplicate user name was found in the security database -85 335544753 usrname_not_found The user name specified was not found in the security database -85 335544754 error_adding_sec_record An error

100 335544338 from_no_match No match for first value expression 100 335544354 no_record Invalid database key 100 335544367 segstr_eof Attempted retrieval of more segments than exist 100 335544374 stream_eof fetch past the last record in a record stream 0 335741039 gfix_opt_SQL_dialect -sql_dialect set database dialect n 0 335544875 bad_debug_format Bad debug info format -84 335544554 nonsql_security_rel A duplicate user name was found in the security database -85 335544753 usrname_not_found The user name specified was not found in the security database -85 335544754 error_adding_sec_record An error

ALTER CHARACTER SET COLLATION CREATE COLLATION DROP COLLATION COMMENT DATABASE CREATE DATABASE ALTER DATABASE DOMAIN CREATE DOMAIN ALTER DOMAIN EXCEPTION CREATE EXCEPTION CREATE управления пользователями CREATE USER ALTER USER DROP USER 11. Контекстные переменные CURRENT_CONNECTION 6 Руководство по языку SQL CURRENT_ROLE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_TRANSACTION ASC, ASCENDING, AUTO, BEFORE, COLLATION, COMMITTED, COMPUTED, CONDITIONAL, CONTAINING, CSTRING, DATABASE, DESC, DESCENDING, DESCRIPTOR, DO, DOMAIN, ENTRY_POINT, EXCEPTION, EXIT, FILE, GEN_ID, GENERATOR