firebird
firebird copied to clipboard
FirebirdSQL
Firebird server, client and tools
MySQL allows you to leave comments in place for table fields, as well as procedure and function parameters. For example, for a table, it looks like this: ```sql CREATE TABLE...
Consider script: ``` set bail on; set blob all; set list on; set count on; shell del r:\temp\tmp4test.fdb 2>nul; create database 'localhost:r:\temp\tmp4test.fdb' user 'sysdba' password 'masterkey'; set echo on; select...
A significant performance degradation was observed after executing ALTER INDEX ... ACTIVE on all indexes of a Firebird database. Before activating the indexes (right after a backup/restore), the query ran...
Hi *! I can send the database on request. ``` SELECT 1 FROM ktrt rt JOIN ktbt bt ON bt.ktrt_id = rt.id JOIN ktpu kp ON kp.ktbt_id = bt.id LEFT...
Heya guys! This PR provides a update to the CMake build system. My goal was to fix the compilation on Linux (tested on Fedora). Here is a summary of the...
This issue is somewhat similar to long time fixed https://github.com/FirebirdSQL/firebird/issues/6700 (caused by wire compression; only the affected connection is dropped, the server doesn’t crash), but it only occurs under the...
If `pip_used` has its maximum possible value, we can read over the page buffer. This can lead to incorrect validation of SCN pages when requesting the last used page to...
``` internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 494) gds_$receive failed unknown ISC error 336330835 ``` version of the Firebird: ``` gbak:gbak version WI-V5.0.3.1642 Firebird 5.0...
Hi *! database default charset WIN1250 CREATE DOMAIN XTXTBLOB AS BLOB SUB_TYPE 1 SEGMENT SIZE 80 CHARACTER SET WIN1250 COLLATE WIN1250; CREATE DOMAIN XVAR100N AS VARCHAR(100) CHARACTER SET WIN1250 NOT...
**Environment** Firebird Version: 5.0.3 Operating System: Windows 11 Architecture: x64 Page Size: 4096 **Problem Description** When executing a query, Firebird 5 automatically generates and successfully uses a specific execution plan...