firebird
firebird copied to clipboard
FirebirdSQL
Firebird server, client and tools
Submitted by: Robert (rj1102) Normal fields and identity fields \(as of FB3\) can be defined both as data type and domain\. However computed fields can only be defined as datatype\....
The following query results in full table scan instead of using the dedicated indexes on the two fields in the IN clause ``` SELECT e.* FROM Employees e WHERE :SomeID...
In Firebird 5, the error "index XXX cannot be used in the specified plan" occurred. The problem does not occur in earlier versions of FB (2.5, 3, 4). What is...
Implementation of #2358 using standard-compliant clause `ALTER CONSTRAINT [NOT] ENFORCED`.
Hello, Using Firebird 4.0.2. My replication configuration is: database = C:\DATOS\00498829.FDB { journal_directory = C:\JOURNAL\00498829\ journal_archive_command = "C:\FTPSend $(pathname)" journal_segment_count = 0 journal_archive_timeout = 10 } If FTPSend returns always...
`isql -x` always generates the script that creates indices as active even if they are inactive in the database. It makes a database recreated from such script different from source...
Hi, We use FB 4.04 for two month and we observe a lot of FB crashs during normal use and especial during backup prozess. a) The crashes happen often when...
Submitted by: @cincuranet Votes: 14 Temporaly disabling constraints \(FK, check, \.\.\.\) using: ALTER TABLE DISABLE and ALTER TABLE ENABLE This more or less similar to [CORE1084](https://github.com/FirebirdSQL/firebird/issues?q=CORE1084+in%3Atitle), but with wider application\.
The initial implementation was developed by customer request, later it was slightly improved and committed into a separate branch for testing. Some issues were found that prevented it from inclusion...
