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

开启 TLS 验证 生成自签名证书 监控集群 整体监控框架概述 重要监控指标详解 组件状态 API & 监控 扩容缩容 集群扩容缩容方案 使用 Ansible 扩容缩容 升级 升级组件版本 TiDB 2.0 升级操作指南 性能调优 备份与迁移 备份与恢复 数据迁移 数据迁移概述 数据迁移 故障诊断 TiDB 周边工具 Syncer Loader TiDB-Binlog PD Control TiKV Control 2.0.4 2.0.3 2.0.2 2.0.1 2.0 2.0 RC5 2.0 RC4 2.0 RC3 2.0 RC1 1.1 Beta 1.1 Alpha 1.0 Pre-GA RC4 RC3 RC2 RC1 TiDB 路线图 性能测试 TiDB Sysbench 性能测试报告 - v1.0.0 TiDB TPC-H 50G 性能测试报告 - v2.0 TiDB Sysbench 性能对比测试报告 开启 TLS 验证 生成自签名证书 监控集群 整体监控框架概述 重要监控指标详解 组件状态 API & 监控 扩容缩容 集群扩容缩容方案 使用 Ansible 扩容缩容 升级 升级组件版本 TiDB 2.0 升级操作指南 性能调优 备份与迁移 备份与恢复 数据迁移 数据迁移概述 全量导入 增量导入 故障诊断 TiDB 周边工具 Syncer Loader TiDB-Binlog PD Control TiKV

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

Africa/Blantyre Central African Time 2.0 Africa/Brazzaville Western African Time 1.0 Africa/Bujumbura Central African Time 2.0 Africa/Cairo Eastern European Time 2.0 Africa/Casablanca Western European Mean Time 0.0 Africa/Gaborone Central African Time 2.0 Africa/Harare Central African Time 2.0 Africa/Johannesburg South Africa Standard Time 2.0 Africa/Juba Eastern African Time 3.0 Africa/Kampala Eastern African Time 3.0 Africa/Khartoum Eastern African Time 3.0 Africa/Kigali Central African Time 2.0 Africa/Kinshasa Western African Time 1.0 Africa/Lagos Western African Time 1.0 Africa/Libreville

Africa/Blantyre Central African Time 2.0 Africa/Brazzaville Western African Time 1.0 Africa/Bujumbura Central African Time 2.0 Africa/Cairo Eastern European Time 2.0 Africa/Casablanca Western European Mean Time 0.0 Africa/Gaborone Central African Time 2.0 Africa/Harare Central African Time 2.0 Africa/Johannesburg South Africa Standard Time 2.0 Africa/Juba Eastern African Time 3.0 Africa/Kampala Eastern African Time 3.0 Africa/Khartoum Eastern African Time 3.0 Africa/Kigali Central African Time 2.0 Africa/Kinshasa Western African Time 1.0 Africa/Lagos Western African Time 1.0 Africa/Libreville