firebird
firebird copied to clipboard
FirebirdSQL
Firebird server, client and tools
We encountered customer case where user name, and therefore appdata-path contains & character. In batch files etc it must be escaped as ^&, now in out script otherwise works, but...
When comparing speeds between database platforms, we came across a potentially large firebird optimization. Memory table scan (table pages in memory) speed on MSSQL/Oracle is orders of magnitude faster than...
Extract external procedures and functions in one pass because they have no BLR and cannot have dependencies.
I'm not sure it should be applied to v6 as it supports databases in ODS 13.0 / 13.1 which may be multi-file and the engine will not be able to...
Occasionally, it becomes necessary to specify certain parameters for a database in the databases.conf file. However, there might be cases where creating an alias for these parameters is not desirable....
Stream BLOBs become segmented in target database.
In rare cases (hard to reproduce because caused by races) engine returns error about invalid (zero) page type when switching database to nbak mode.
Windows 10. Firebird 3.0, 4.0, 5.0. The following command works successfully. ``` gstat localhost/3055:horses -u SYSDBA -p masterkey -h ``` However, if you replace the connection string with a URL,...
```sql SELECT * FROM RDB$RELATIONS WHERE RDB$RELATION_NAME IS NULL ``` Explain plan ``` Select Expression -> Filter -> Table "RDB$RELATIONS" Access By ID -> Bitmap -> Index "RDB$INDEX_0" Unique Scan...
We have several crashes of 5.0 with similar symptoms (and stacks). The [stacks](https://github.com/user-attachments/files/16907028/stacks.txt) of the two threads are attached. In the first one, DsqlStatementCache::shrink() is called during statement release. It...
