firebird
firebird copied to clipboard
FirebirdSQL
Firebird server, client and tools
Sometimes it is necessary to use `not exists` conditions on big tables. At present, besides common b-tree indexes, Firebird does not provide any efficient way for optimizing such queries: ```...
This ticket has a fairly low priority since MERGE joins are generally less efficient, but it would still be useful for testing purposes. Script for filling tables: ```sql RECREATE TABLE...
In Postgres there is a GRANT syntax for all object of a certain type including all future objects https://www.postgresql.org/docs/current/sql-alterdefaultprivileges.html. For example: ``` GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES...
In the original task https://github.com/FirebirdSQL/firebird/issues/8005#issuecomment-1943688591 the short syntax `FIELD IN UNLIST(..)` was considered but it has been postponed. I would like to revive this discussion within this new task. As...
[Options for Debugging Your Program](https://gcc.gnu.org/onlinedocs/gcc/Debugging-Options.html) > -glevel ... Level 1 produces minimal information, **enough for making backtraces** ... Full debug info are very big and mainly no sense for "plain...
Link to proposal: https://groups.google.com/g/firebird-devel/c/geF0A2_kC28
Soluation for #7769. Skip NULLs keys at the evaluation time and do not put appropriate records into the hash table (for hash joins) or into external sort blocks (for merge...
Submitted by: @pcisar Votes: 9 SFID: 807945#⁠ Submitted By: pcisar The ability to define/control the location of data/user tables within a multi\-file database\. \-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\-\- User: awharrison Logged In: YES user\_id=66088...
Submitted by: Valdir Stiebe Junior (ogecrom) Relate to [CORE2621](https://github.com/FirebirdSQL/firebird/issues?q=CORE2621+in%3Atitle) Replaces [CORE2686](https://github.com/FirebirdSQL/firebird/issues?q=CORE2686+in%3Atitle) Votes: 5 SFID: 1421984#⁠ Submitted By: ogecrom I don't know the complexity of this but it will be good...
Hi Development Team, I identified a potential integer overflow in clone functions in files in `extern/libtommath` sourced from [libtom/libtommath](https://github.com/libtom/libtommath). This issue, originally reported in [CVE-2023-36328](https://nvd.nist.gov/vuln/detail/CVE-2023-36328), was resolved in the repository...
