firebird

firebird copied to clipboard

Fix for #8565

4

So far this is a simplest quick fix to let Pavel Zotov test it.

aafemt

Grant ROLE session scope

24

Hi For us, this would be a security game changer, and I believe it wouldn't be difficult for you to implement — similar to how GRANT ROLE or SET ROLE...

livius2

Extremely slow to do "Left Join" on the same table

29

This command below takes 40 minutes SELECT CM.Codigo, CM.MERCADORIA, Sum(E.quant) As Saldo, AVG(E2.preco_custo) As Preco FROM CADASTRO_MERCADORIAS CM left Join ESTOQUE E ON (E.Cod_Mercadoria = CM.codigo) left Join ESTOQUE E2...

luapfr

Replace sprintf with snprintf

1

Replaces occurrence of sprintf with snprintf; I ignored all code in `extern` (including cloop). I also did not touch the `.c`, and `.e` code in examples.

mrotteveel

Silent truncation of user-provided data of type SQL_TEXT

2

This is an initial architectural problem which surfaced after apply #8145. For multibyte encodings engine validates data in input message limiting it to a supposed character length `dsc_length / BPC`....

aafemt

LPAD with length from DB tries to return 64k varchar and fetch via ISC API fails with 335544358 'message length error' error

4

Hello, we are trying to migrate from firebird 2.5 to v5. On client side we are using Delphi with IBObjects. When using firebird v5 some 'select' statements, for example: select...

ppazera

non-decimal integer literals (SQL:2023 T661) HEX Hexadecimal numeric constants are prefixed with the digits '0' and 'X' (or 'x') immediately followed by a sequence of bytes represented by the digits...

ChudaykinAlex

[FB3+] RPAD works incorectly in a connection with the charset NONE

2

Hello, When I use connection charset NONE, RPAD generates VARCHAR with length 65533 (==-3) Is it OK? **FB4** ``` SQL> SET SQLDA_DISPLAY ON; SQL> show version; ISQL Version: WI-V4.0.3.2937 Firebird...

dmitry-lipetsk

Multiple Fatal lock manager error: Process disappeared in LockManager::acquire_shmem, errno: 22 --Invalid argument

2

``` xxxx Fri Apr 25 12:23:30 2025 Fatal lock manager error: Process disappeared in LockManager::acquire_shmem, errno: 22 --Invalid argument xxxx Fri Apr 25 12:23:30 2025 /opt/firebird/bin/fbguard: /opt/firebird/bin/firebird terminated abnormally (-1)...

giopk

UPDATE must not touch fields that are not explicitly mentioned

3

we are trying to migrate from firebird v2.5.9 to v5.0.2 (classic, windows and linux) but noticed one critical issue with bulk updates which are stopping us from upgrading bulk update...

ppazera