firebird
firebird copied to clipboard
FirebirdSQL
Firebird server, client and tools
Currently, when we create an expression index, it must be a singleton function. For example: `CREATE IXAE_TEST_VALUES ON TEST COMPUTED BY(CALC_SINGLE_VALUE(MY_FIELD));` However, if you need to divide a field into...
Suppose we have to run loop with lot iterations and do following within each iteration: - start profiler with some options - do some stuff - stop profiler This can...
Submitted by: lacak (lacak) Replaces [CORE2686](https://github.com/FirebirdSQL/firebird/issues?q=CORE2686+in%3Atitle) Votes: 9 Add support for SQL:2003 : ::= \| \| \( , \[,,\.\.\.\] \) \| ROW \( \[,,\.\.\.\] \) \|
Extend INSERT to support inserting multiple rows in single command (ala PostgreSQL/MySQL) [CORE1978]
Submitted by: Gustavo Torres (gusta1308) Votes: 20 I suggest include INSERT for multi\-values INSERT INTO Table \(a, b, c\) values\(1, 2, 3\), \(4, 5, 6\); for improvement performance insert
IN predicate incorrectly handles single parenthesized subquery as IN-list, instead of table subquery
Currently `IN` with a parenthesized subquery is incorrect handled as an IN-list with a single value, instead of a table subquery. The following use of IN with a subquery will...
Hi as #8173 is closed as not planned, please add `BIN_OR` and `BIN_AND` as aggregate functions (can be under different name if you see some conflicts). Currently we must do...
Change zlib deflate compression level from Z_DEFAULT_COMPRESSION (6 for now) to Z_BEST_SPEED (1). ``` int ret = zlib().deflateInit(&port_send_stream, Z_DEFAULT_COMPRESSION); // remote/remote.cpp int ret = zlib().deflateInit(&strm, Z_DEFAULT_COMPRESSION); // burp/mvol.cpp ``` As...
Submitted by: fbbt (fbbt) Duplicates [CORE1645](https://github.com/FirebirdSQL/firebird/issues?q=CORE1645+in%3Atitle) Examples: \-\- select FieldName from T \-\- select FieldName as FieldNameAlias from T need a way to get FieldName and FieldNameAlias at client not...
Submitted by: Omacht András (aomacht) Votes: 2 Vlad said at the conference in Berlin it is possible the improve gbak and the engine to set swept flag on all data...