Firebird 2.0 Error Codes Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT 101 335544366 segment Segment buffer length shorter than expected 100 335544338 from_no_match No match for first value 336003088 dsql_datatypes_not_comparable Datatypes %sare not comparable in expression %s Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT -104 335544343 invalid_blr Invalid request BLR at offset expression in the %s (not contained in either an aggregate function or the GROUP BY clause) Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT -104 335544825 dsql_agg_having_err Invalid expression in

Максимальная длина индексируемого (VAR)CHAR 6.3 Макс. число индексов в таблице, начиная с Firebird 2.0 7.1 Размещение NULL при сортировке столбцов 12.1 Сравнение IS [NOT] DISTINCT с “=” и “<>” 14.1 Допустимые TPB на явную блокировку А2 Максимальное количество индексов на таблицу в версиях Firebird 1.0 — 2.0 11 Руководство по языку SQL Глава 1 Введение • Операторы PSQL (Procedural SQL — процедурный функциях рассматриваются в соответствующих разделах. Различные улучшения Изменено: 2.0 Описание: В Firebird 2.0 были реализованы несколько усовершенствований для текстовых BLOB: • Предложение DML

Firebird 2.0 and 2.1 Quick Start Guide IBPhoenix Editors Firebird Project members 11 July 2011, document version 3.11 covers Firebird 2.0–2.0.6 and 2.1–2.1.4 2 Table of Contents About this guide Before you read on, verify that this guide matches your Firebird version. This guide covers versions 2.0– 2.0.6 and 2.1–2.1.4. For all other Firebird versions, get the corresponding Quick Start Guide at http://www If you want to rely on Linux forced writes to work correctly, upgrade to at least 2.0.4. Firebird 2.0 and 2.1 Quick Start 4 The Firebird licenses Firebird is a free, open-source database management

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 2.5.2. Firebird 2.0 and up . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55 Table of Contents 2 17.2.1. Firebird 2.0 and up. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . “cast( NULL as int )”, or using a field or variable that you know is NULL, etc. 2.5.2. Firebird 2.0 and up Firebird 2 allows the use of NULL literals in every context where a normal value can also be

Firebird 2.0 and higher. Important For those who have already done the migration to v.2.0, there are a few more issues that need to be attended to in migrating to v.2.1, in addition to the v.2.0 issues Firebird 2.0 server, you should create a gbak backup of your old security.fdb (from v.1.5) or isc4.gdb (from v.1.0) using the old server's version of gbak and then restore it using the Firebird 2.0 gbak. CHECK (DEPTNO IN (10, 20, 30)) should allow NULL in the DEPTNO column but it did not. In Firebird 2.0, if you need to make NULL invalid in a CHECK constraint, you must do so explicitly by extending the

Normal users, ie all those accounts not listed above, can only see their own user details from version 2.0 of Firebird. They can, however, change their own passwords with the new version. Previously the SYSDBA server in a normal Firebird database named security.fdb for Firebird 1.5 or security2.fdb for Firebird 2.0 onwards. The default locations for this file are: • C:\Program Files\Firebird\Firebird_1_5 for Windows and by doing so, allows users to be added, amended and deleted from the system. Up until Firebird 2.0, it used to be possible to use isql to connect directly to the security database as the SYSDBA user

. . . . . . . . . . . . . . . . . . . . . 28 11.3. New Startup and Shutdown States in Firebird 2.0 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 12. Database Page below for details because it looks like the response code is always zero — at least up until Firebird 2.0.  When logging into a database on a remote server, you will always be required to pass the -⁠u[ser] are available when accessing that database. There are three dialects at present (Firebird version 2.0), these are: • Dialect 1 stores date and time information in a DATE data type and has a TIMESTAMP

Firebird 2.0 and can be used to send the statistics and plans to the same output file that receives the input from the -o(utput) switch. In earlier versions of Firebird (before version 2.0), when a user or isql session, type: SQL> SET SQL DIALECT n; Chapter 11. SQL Dialects 20  Prior to Firebird 2.0 when isql disconnected from a database, either by dropping it or by trying to connect to a non-existent the previous connection, which lead to some inappropriate warning messages. This has been fixed in 2.0 Chapter 11. SQL Dialects 21 Chapter 12. Terminator Character The default terminator symbol for

the table (binary). Added in Firebird 2.0 UNICODE Collation works according to the UCA algorithm (Unicode Collation Algorithm) (alphabetical). Added in Firebird 2.0 UTF8 The default, binary collation . ORDER BY NAME COLLATE UNICODE_CI_AI 3.5.5. Character Indexes In Firebird earlier than version 2.0, a problem can occur with building an index for character columns that use a non-standard collation Data Types and Subtypes 34 compound indexes limit the size even further. Starting from Firebird 2.0, the maximum length for an index equals one quarter of the page size, i.e. from 1,024 — for page size

einen ausreichenden Schutzlevel eingestellt. Diese Parameter werden in den Release Notes (1.5 und 2.0; beide sind in Firebird 2 inkludiert) und über die Kommentare in firebird.conf beschrieben. Windo die Titelbar „Firebird Server Control“ ver- wendet, obwohl es in der Systemsteuerung als Firebird 2.0 Server Manager angeführt wird. Firebird 2 Schnellanleitung 18 Bedauerlicherweise funktioniert dieses Feldgröße – zu lang ist, dann bekommen Sie nur eine Warnung, aber die Aktion wird durchgeführt. (In pre-2.0 Firebird würde dies ebenfalls einen Fehler melden und die Ausführung stoppen.) Beachten Sie auch den