firebird
firebird copied to clipboard
FirebirdSQL
Firebird server, client and tools
Submitted by: Douglas Tosi (douglasht) Votes: 10 Currently in Firebird 2\.1 and 2\.5, query parameters are replaced by "?" in mon$statements\. Please make it possible to retrieve parameter values for...
Submitted by: @pcisar Votes: 32 SFID: 807942#⁠ Submitted By: pcisar Allow for the definition of temporary tables which are only visible within the current connection context and which are deleted...
Hello, I am writing a C++ program using the Firebird API and encountered an 'Unknown ISC error' message instead of the correct error message. The problem can be reproduced with...
Currently, Firebird processes `GROUP BY` clauses using `sort-based` aggregation, which is reliable and integrates well with ORDER BY, but can be memory and I/O-intensive for large datasets. An alternative is...
Run DDL + prepare statements: ``` Database: /:employee, User: SYSDBA SQL> recreate table test(x int); SQL> insert into test select rand()*10000 from rdb$types rows 10; SQL> commit; SQL> create index...
Using exists in Firebird 5.0.1 uses a different and slow plan compared to just the select statement
Given the query below: ```sql SELECT IIF(EXISTS( SELECT ORDEM_PRODUCAO.ORP_ID FROM ITEM_SEPARACAO_PEDIDO_VENDA INNER JOIN ORDEM_PRODUCAO ON (ITEM_SEPARACAO_PEDIDO_VENDA.ISP_ID = ORDEM_PRODUCAO.ISP_ID) WHERE (ITEM_SEPARACAO_PEDIDO_VENDA.IPV_ID = 9437253)), 'Sim', 'Não') as TEM_OP FROM RDB$DATABASE ``` All...
The following trigger gives me a connection error. ``` SET TERM ^ ; CREATE OR ALTER TRIGGER SYSTEM_SHAREWARE ACTIVE ON CONNECT POSITION 0 AS DECLARE VARIABLE comando D_VARCHAR_1024; DECLARE VARIABLE...
Firebird 5 add new (virtual) table mon$compiled_statements with blobs mon$sql_text and mon$explained_plan. In (virtual) table mon$statements added field mon$compiled_statement_id. Now fields mon$sql_text and mon$explained_plan in mon$statements are redudant. Suggest add...
This allows GUID-specific code being supported to the replica side. Currently only a check against configuration is performed.
Following was checked on WI-T6.0.0.673 Firebird 6.0 7519f25: Step-1: run script: ``` set bail on; set echo on; shell del c:\temp\tmp4test.fdb 2>nul; create database 'localhost:c:\temp\tmp4test.fdb' user 'sysdba' password 'masterkey'; recreate...