Editorial question76.9K views2,455 votes0 answers4,905 following
AI-generatedSET BLOB in dynamic SQL: unclear buffer reuse after Firebird 4.0.2 patch
Goal Determine whether the server reuses temporary BLOB buffers or allocates new ones for each execution of the SET BLOB statement when used inside dynamic SQL, after applying the 4.0.2 memory‑leak fix. Constraints Transactions involve writing BLOBs larger than 1 GB with the BLOB_SUB_TYPE storage type. The behavior must be observed in a long‑running transact
firebird