firebird
firebird copied to clipboard
FirebirdSQL
Firebird server, client and tools
It's been suggested to improve the way replication is configured. Currently, replication can be enabled at the database level and at the configuration level (both are required), but these settings...
At the moment the `isc_info_db_class` ([link](https://github.com/FirebirdSQL/firebird/blob/master/src/jrd/inf.cpp#L761)) returns only `isc_info_db_class_classic_access` or `isc_info_db_class_server_access`. I think the `info_db_class` should be expanded and `MODE_SUPERCLASSIC` should be handled.
We have announced 'cursor stability' for most types of queries in v3, but this improvement does not affect FOR EXECUTE STATEMENT cursors. Consider the following example: ``` create table t...
``` set names UTF8; connect 'inet4://localhost:3053/test' user SYSDBA password 'masterkey'; Database: 'inet4://localhost:3053/test', User: SYSDBA CREATE OR ALTER VIEW VW_TB3( RENT) AS select 'ab '||' ab '||' abcd' from $RDB$DATABASE; show...
Submitted by: Pierre Yager (pierrey) Duplicates [CORE2172](https://github.com/FirebirdSQL/firebird/issues?q=CORE2172+in%3Atitle) Attachments: [CORE-3127.cpp.7z](https://github.com/FirebirdSQL/jira-attachments/raw/main/CORE/CORE-3172/12919_CORE-3127.cpp.7z) While trying to implement support to utf8\_filename DPB flag into UIB Components we cannot pass any test\. 1\) I created a...
Currently index statistics can be re-calculated only when user has system privilege for ALTERING ANY table. It seems useful to split such actions: ALTER ANY table is much powerful (and...
This complements https://github.com/FirebirdSQL/firebird/issues/6815 to allow non-singleton `RETURNING` in PSQL. It should support statements: * `INSERT ... SELECT ...` * Searched `UPDATE` * Searched `DELETE` * `MERGE` * `UPDATE OR INSERT`
Consider script: ``` shell del c:\temp\tmp4test.fdb 2>nul; create database 'localhost:c:\temp\tmp4test.fdb' user sysdba password 'masterkey'; recreate table test(id int, x int, constraint test_pk primary key(id) ); insert into test(id, x) values(1,...
Consider server with dozen of databases. Some of them are under active developing among several programmers. It is difficult to detect name of DB in such cases: ``` SOME_SERVER Thu...