firebird
firebird copied to clipboard
FirebirdSQL
Firebird server, client and tools
Hi regression v5 (WI-V5.0.4.1739 Firebird 5.0 b103e8f) to v3, minimal reproducible test case below DDL ```SQL SET TERM ^ ; CREATE PROCEDURE GET_ROWS_FROM_LIST ( ITEM_LIST VARCHAR(10000), SEPARATOR VARCHAR(20) DEFAULT ','...
Link to RFC - [Distributed queries (Management of External Data) proposal](https://groups.google.com/g/firebird-devel/c/XWoknE2mZvg/m/x75vY8K7BQAJ)
Official Firebird 3.0.13. `select T.NAZWA from TECHNOLOGIA T join OPERACJATECH OT on (T.ID_TECHNOLOGIA = OT.ID_TECHNOLOGIA) left outer join OPERACJATECHBOM OB on (OB.ID_OPERACJATECH = OT.ID_OPERACJATECH) left outer join BOMITEM_VIEW BI on...
# PERCENTILE_DISC and PERCENTILE_CONT functions The `PERCENTILE_CONT` and `PERCENTILE_DISC` functions are known as inverse distribution functions. These functions operate on an ordered set. Both functions can be used as aggregate...
Description: Currently, Firebird lacks support for standard bitwise operators (&, |, ^, ~, ). To perform bitwise operations, users must rely on non-standard functions like BIN_AND, BIN_OR, etc. This creates...
Applying ```LIST([DISTINCT] )``` (and also ```LISTAGG([DISTINCT] ) WITHIN GROUP(ORDER BY )```) causes excessive space-padding of characters if `````` is defined as ```Char(N)```. Length of displayed (padded) data depends on both...
## Summary The privilege checks for the COMMENT ON PARAMETER command on functions in packages are missing. Reproduced on `firebirdsql/firebird:latest` (LI-V5.0.3.1683): a low-privilege user `u1` can comment on package functions'...
## Summary `DROP FILTER` privilege checks can be bypassed when the DROP follows a failing `ALTER FUNCTION` inside the same `SET TERM` block. Reproduced on `firebirdsql/firebird:latest` (LI-V5.0.3.1683): a low-privilege user...
Here is an example table and procedure for this. ```SQL --DROP PROCEDURE ADDMYTABLE; --DROP TABLE MYTABLE; --commit; CREATE TABLE MYTABLE ( FIELDOLD INTEGER ); SET TERM ^ ; create or...
Thread hang when multiple Windows 11 processes write concurrently to same embedded Firebird 5.0.1 DB
Hello, I’m using Firebird 5.0.1 in embedded mode on Windows, together with the official .NET Firebird client (FirebirdSql.Data.FirebirdClient). The problem: Occasionally, one of the threads becomes permanently stuck during execution....
