firebird
firebird copied to clipboard
FirebirdSQL
Firebird server, client and tools
Now when we start Firebird service there is no log in Firebird.log. Worse that also there is no log about recovery start after bad closing/crash. Please add 3 logs into...
Since FB 3.0 we have ability to avoid creating local variables for store values returned by query and use 'AS CURSOR ' feature. This is very convenient in practice and...
Replication protocol header is supposed to be public but is not included into distributed include/firebird directory.
There is some strange statement in isql source code: https://github.com/FirebirdSQL/firebird/blob/682853e827bbc4ce1c9be643fee46c83dcb1229e/src/isql/isql.epp#L9340-L9341 in fucntion` static bool stdin_redirected()` As a result, when isql is called the same way, in Linux `stdin_redirected` returns true,...
Why does Firebird cannot work with custom aliases for column names in where and having clauses? This is a major lack of functionality because you need to write the same...
1. The first commit fixes this script: set autoddl off; create table test (id numeric); commit; create view v_test (id) as select id from test; commit; drop view v_test; create...
If we try to violate unique constraint then problematic value is shown. It will be useful to have the same info for SQLSTATE = 22003: ``` SQL> recreate table test(id...
From firebird.conf: ``` # Normally, Firebird uses SO_KEEPALIVE socket option to keep track of # active connections. If you do not like default 2-hour keepalive timeout # then adjust your...
``` create database 'c:\test.fdb' user 'sysdba' password 'masterkey'; create table t(c blob sub_type 1); commit; set term ^; create or alter procedure p returns (c blob sub_type 1) as begin...
Сan be reproduced with isql: on client side: connect server_host:/tmp/test.fdb user sysdba password masterkey; on server side: disconnect the server from the network on client side: select * from rdb$database;...