firebird
firebird copied to clipboard
FirebirdSQL
Firebird server, client and tools
Currently we are able to convert IN into a semi-join: ```sql select * from t1 where t1.fld1 in (select fld2 from t2); ``` is executed like: ```sql select * from...
For now no reliable way identify connection created by "request" of gbak -se -par -b May be set some special name for such connection?
// 1st of all: sorry for attached images, but without them it is difficult to explain the steps described below Consider following script (save it in some file.sql): ``` set...
Employee DB has table 'sales' with following constraint: ``` ALTER TABLE SALES ADD CHECK (NOT (order_status = 'shipped' AND EXISTS (SELECT on_hold FROM customer WHERE customer.cust_no = sales.cust_no AND customer.on_hold...
In the query below, the CTE returns empty instantly. The full query returns, that just filter the empty result, takes 3s, If I remove the where clause, it also returns...
We are encountering the following error on the replica side: ERROR: cannot update old BLOB At segment 14297, offset 48 This error is not recoverable. There is no way to...
We have encountered a rare issue while using Firebird 5.0.1 SuperServer on Windows. Over the past three months, our application has experienced this error three times: Operating system directive SetFilePointer...
Consider script (unpack it from attached .zip): ``` connect '/:employee'; set echo on; set list on; select '1←2' from rdb$database; select '1→2' from rdb$database; quit; ``` Run it ( isql...
Hello, If later on of the DB development, you find out that you need to make certain fields ("by domain") larger, or maybe smaller and none of the fields are...
In Firebird 5.0.1 when using a partial index with various range selections it always seems to fall back to a table scan (PLAN NATURAL) ``` CREATE INDEX AUDIT_LINETYPE ON AUDIT(LINETYPE)...
