firebird
firebird copied to clipboard
FirebirdSQL
Firebird server, client and tools
It should be possible to downgrade v6 databases with gbak/restore into older versions (mainly v5). That should be possible if there is no new feature usage. That normally happens, but...
Firebird 5.0.2.1613 Windows 32-bit "MERGE INTO" gives wrong returning value with the use of sequence
Execution of "MERGE INTO"-sql gives wrong RETURNING-value when using next generator value in the "USING" section. The inserted value is correct and that inserted value with "RETURNING" is also correct....
When computed index is created on RDB$RECORD_VERSION pseudo-column: ``` ALTER TABLE COUNTRY ADD TRA_ID BigInt COMPUTED BY (RDB$RECORD_VERSION); ``` Then query like this that use it: ``` SELECT r.RDB$RECORD_VERSION,r.COUNTRY, r.CURRENCY...
Firebird 5.0.3 ```sql CREATE TABLE TEST ( ID BIGINT GENERATED BY DEFAULT AS IDENTITY, A INT, CONSTRAINT PK_TEST_ID PRIMARY KEY(ID) ); CREATE INDEX TEST_A_IDX ON TEST(A); SET TERM^; EXECUTE BLOCK...
https://www.geraldonit.com/non-positional-insert-statement-insider-story/ "Standardization of non-positional INSERT We believe the non-positional INSERT statement significantly enhances the SQL language. Therefore, Oracle plans to propose this comprehensive feature set to the SQL Standard Committee...
I don't have the opportunity to look at the SQL standard, so I'll just point out where it is described. The search clause is defined in ISO/IEC 9075-2:2023 §7.18 as...
Submitted by: Alexander Tyutik (tut) Is duplicated by [CORE1629](https://github.com/FirebirdSQL/firebird/issues?q=CORE1629+in%3Atitle) Votes: 2 People very often need quersied wich return single record\. For this proposes people use queries like this: SELECT CURRENT\_USER...
I came across this error today: This was with Fb 3.0.11. Searching across the source for all supported branches failed to return neither 336330998 nor 336330999. When I dug into...
