firebird
firebird copied to clipboard
FirebirdSQL
Firebird server, client and tools
Hello, We have a firebird database and it stops responding every 2-3 days and fails with "Unable to complete network request to host "localhost"". Firebird restart doesn't fix the problem....
ISQL Version: WI-V3.0.8.33506 Firebird 3.0 SQL> create table TTT4(COL_INTEGER INTEGER, COL_NUM_6_1 NUMERIC(6,1)); SQL> insert into TTT4 (COL_INTEGER, COL_NUM_6_1) values (2147483647,12345.6); SQL> select COALESCE(COL_INTEGER,COL_NUM_6_1) from TTT4; **Result** > COALESCE > ============...
It would be nice if ISQL command SHOW DATABASE displayed publication status for database and SHOW TABLE command - for particular table.
I have two, similar queries. In one of case have additional dummy where conditions (1=1, 0=0, true): ``` SELECT t1.* FROM table1 t1 JOIN table2 t2 ON t2.fk_t1 = t1.id...
Submitted by: Andrew Ayre (communicare) The comments in Firebird\.conf for client connection settings include: #⁠ Normally, Firebird uses SO\_KEEPALIVE socket option to keep track of #⁠ active connections\. If you...
Example: ``` sql SELECT * FROM T1 LEFT JOIN T2 ON T1.ID = T2.ID WHERE T2.FIELD1 = 0 ``` In this case the condition `T2.FIELD1 = 0` effectively removes all...
Hi all! Discussons on this topic: https://github.com/FirebirdSQL/firebird/issues/6928 https://www.mail-archive.com/[email protected]/msg20326.html Here is my proposal. Things which should be configurable ### 1. two integer type division result config name: "integer_division" options: - DEFAULT:...
Instead of packages or additionally, wouldn't it also make sense to simply store procedures and function for a table? And then call them e.g. table = article article.MyProcedure()
Submitted by: hugo (hugolarson) Hi, We have several hundreds of FB databases running on computers who needs to be backupped to our server\. We use today FB 2\.5 with nbackup...
Submitted by: Anderson Farias (afarias) Assigned to: Claudio Valderrama C. (robocop) Attachments: [SIG_FB15.7z](https://github.com/FirebirdSQL/jira-attachments/raw/main/CORE/CORE-3118/11750_SIG_FB15.7z) Votes: 2 When restoring a FB 1\.5 database on FB 2\.5 some triggers named "CHECK\_n" appears\. Steps...