firebird
firebird copied to clipboard
FirebirdSQL
Firebird server, client and tools
Submitted by: K. A. (parshua) Votes: 11 One of major pains in updating many client databases in remote areas is recompilation of STORED PROCEDURES\. Having this feature will ease the...
Now, if an error is made in replication.conf, replication is not initialized at all and a situation arises that can lead to desynchronization of an already configured replica. For example,...
Following query reports correct error (except "source column" part): ``` SQL> select cast('1-1-1 1:1:1.1' as abc) from rdb$database; Statement failed, SQLSTATE = 42000 Dynamic SQL Error -SQL error code =...
Submitted by: alassiry (alassiry) Block progress on [CORE644](https://github.com/FirebirdSQL/firebird/issues?q=CORE644+in%3Atitle) Votes: 31 SFID: 1175710#⁠ Submitted By: alassiry It would be great if we could link databases together, even with non\-firebird databases\. for...
Submitted by: eXandr (i.reg) Is related to [CORE740](https://github.com/FirebirdSQL/firebird/issues?q=CORE740+in%3Atitle) Replaces [CORE2686](https://github.com/FirebirdSQL/firebird/issues?q=CORE2686+in%3Atitle) Is duplicated by [CORE1998](https://github.com/FirebirdSQL/firebird/issues?q=CORE1998+in%3Atitle) Relate to [CORE3070](https://github.com/FirebirdSQL/firebird/issues?q=CORE3070+in%3Atitle) Votes: 9 Syntaxis: DECLARE VARIABLE RECORD AS \[TABLE\|VIEW\|CURSOR\|PROCEDURE\[OUTPUT PARAMETERS\]\] ; Example: \.\. AS...
Submitted by: Cosmin Apreutesei (cosmin_ap2) Votes: 18 The LIST\(\) function could rock, if only you could control the order of elements\. Right now I can't use it to display data...
Submitted by: Alexey Kuznetsov (kuaw26) Is related to [CORE2621](https://github.com/FirebirdSQL/firebird/issues?q=CORE2621+in%3Atitle) Votes: 2 It would be very useful if Firebird would support modern syntax for A=v1 AND B=v2 predicates as it implemented...
Using Firebird 5.0.1 and Windows 11 When the Firebird Server is installed locally and there's either no network available or the network card is disabled, a connection with the computer...
Firebird 5.0.1 is not using index when all records are null and left join is converted to inner join
Given the query below: ```sql SELECT ITEM_NOTA_COMPRA.INC_ID FROM ITEM_NOTA_COMPRA LEFT JOIN NOTA_COMPRA ON (ITEM_NOTA_COMPRA.NTC_ID = NOTA_COMPRA.NTC_ID) WHERE (ITEM_NOTA_COMPRA.INC_ID_COMPLEMENTADO = 651321) AND (NOTA_COMPRA.NTC_SITUACAO = 'Finalizada') ``` Field INC_ID_COMPLEMENTADO is a foreign...
Round already have scale, shouldn't Floor and Ceiling also have scale parameter/function ?
