CHANGELOG.md

v5.0 Beta 1 (27-Mar-2023)

New features

• #7447: Parallel sweeping and index creation inside the engine
  Reference(s): /doc/README.parallel_features
  Contributor(s): Vlad Khorsun

• #7397: Inline minor ODS upgrade
  Contributor(s): Dmitry Yemanov

• #7350: SKIP LOCKED clause for SELECT WITH LOCK, UPDATE and DELETE
  Reference(s): /doc/sql.extensions/README.skip_locked.md
  Contributor(s): Adriano dos Santos Fernandes

• #7216: New built-in function BLOB_APPEND
  Reference(s): /doc/sql.extensions/README.blob_append.md
  Contributor(s): Vlad Khorsun

• #7144: Compiled statement cache
  Contributor(s): Adriano dos Santos Fernandes

• #7086: PSQL and SQL profiler
  Reference(s): /doc/sql.extensions/README.profiler.md
  Contributor(s): Adriano dos Santos Fernandes

• #7050: Add table MON$COMPILED_STATEMENTS and column MON$COMPILED_STATEMENT_ID to both MON$STATEMENTS and MON$CALL_STACK tables
  Reference(s): /doc/README.monitoring_tables
  Contributor(s): Adriano dos Santos Fernandes

• #6910: Add way to retrieve statement BLR with Statement::getInfo and ISQL's SET EXEC_PATH_DISPLAY BLR
  Contributor(s): Adriano dos Santos Fernandes

• #6798: Add built-in functions UNICODE_CHAR and UNICODE_VAL to convert between Unicode code point and character
  Reference(s): /doc/sql.extensions/README.builtin_functions.txt
  Contributor(s): Adriano dos Santos Fernandes

• #6713: System table RDB$KEYWORDS with keywords [CORE6482]
  Contributor(s): Adriano dos Santos Fernandes

• #6681: Support for WHEN NOT MATCHED BY SOURCE for MERGE statement [CORE6448]
  Reference(s): /doc/sql.extensions/README.merge.txt
  Contributor(s): Adriano dos Santos Fernandes

• #3750: Partial indices [CORE3384]
  Reference(s): /doc/sql.extensions/README.partial_indices
  Contributor(s): Dmitry Yemanov, Vlad Khorsun

• #1783: New GBAK switch to backup / restore tables/indexes in parallel
  Reference(s): /doc/README.gbak
  Contributor(s): Vlad Khorsun

Improvements

• #7441: More cursor-related details in the plan output
  Contributor(s): Dmitry Yemanov

• #7437: Update zlib to 1.2.13
  Contributor(s): Vlad Khorsun

• #7411: Unify display of system procedures & packages with other system objects
  Contributor(s): Alexander Peshkov

• #7399: Simplify client library build
  Contributor(s): Adriano dos Santos Fernandes

• #7382: Performance improvement for BLOB copying
  Contributor(s): Adriano dos Santos Fernandes

• #7331: Cost-based choice between nested loop join and hash join
  Contributor(s): Dmitry Yemanov

• #7294: Allow FB-known macros in replication.conf
  Contributor(s): Dmitry Yemanov

• #7293: Create Android packages with all necessary files in all architectures (x86, x64, arm32, arm64)
  Contributor(s): Adriano dos Santos Fernandes

• #7284: Change release filenames as the following examples
  Contributor(s): Adriano dos Santos Fernandes

• #7259: Remove TcpLoopbackFastPath and use of SIO_LOOPBACK_FAST_PATH
  Contributor(s): Vlad Khorsun

• #7208: Trace: provide performance statistics for DDL statements
  Contributor(s): Vlad Khorsun

• #7194: Make it possible to avoid fbclient dependency in pascal programs using firebird.pas
  Contributor(s): Alexander Peshkov

• #7186: Nbackup RDB$BACKUP_HISTORY cleanup
  Contributor(s): Vlad Khorsun

• #7169: Improve ICU version mismatch diagnostics
  Contributor(s): Adriano dos Santos Fernandes

• #7168: Ignore missing UDR libraries during restore
  Contributor(s): Adriano dos Santos Fernandes

• #7165: Provide ability to see in the trace log events related to missing security context
  Contributor(s): Vlad Khorsun

• #7093: Improve indexed lookup speed of strings when the last keys characters are part of collated contractions
  Contributor(s): Adriano dos Santos Fernandes

• #7092: Improve performance of CURRENT_TIME
  Contributor(s): Adriano dos Santos Fernandes

• #7083: ResultSet::getInfo() implementation
  Contributor(s): Dmitry Yemanov

• #7065: Connection hangs after delivery of 256GB of data
  Contributor(s): Alexander Peshkov

• #7051: Network support for bi-directional cursors
  Contributor(s): Dmitry Yemanov

• #7046: Make ability to add comment to mapping ('COMMENT ON MAPPING ... IS ...')
  Contributor(s): Alexander Peshkov

• #7042: ON DISCONNECT triggers are not executed during forced attachment shutdown
  Contributor(s): Ilya Eremin

• #7041: Firebird port for Apple M1
  Contributor(s): Adriano dos Santos Fernandes

• #7038: Improve performance of STARTING WITH with insensitive collations
  Contributor(s): Adriano dos Santos Fernandes

• #7025: Results of negation must be the same for each datatype (smallint / int / bigint / int128) when argument is least possible value for this type
  Contributor(s): Alexander Peshkov

• #6992: Transform OUTER joins into INNER ones if the WHERE condition violates the outer join rules
  Contributor(s): Dmitry Yemanov

• #6959: IBatch::getInfo() implementation
  Contributor(s): Alexander Peshkov

• #6957: Add database creation time to the output of ISQL's command SHOW DATABASE
  Contributor(s): Vlad Khorsun

• #6954: fb_info_protocol_version support
  Contributor(s): Alexander Peshkov

• #6929: Add support of PKCS v.1.5 padding to RSA functions, needed for backward compatibility with old systems.
  Contributor(s): Alexander Peshkov

• #6915: Allow attribute DISABLE-COMPRESSIONS in UNICODE collations
  Contributor(s): Adriano dos Santos Fernandes

• #6903: Unable to create ICU-based collation with locale keywords
  Contributor(s): tkeinz, Adriano dos Santos Fernandes

• #6874: Literal 65536 (interpreted as int) can not be multiplied by itself w/o cast if result more than 2^63-1
  Contributor(s): Alexander Peshkov

• #6873: SIMILAR TO should use index when pattern starts with non-wildcard character (as LIKE does)
  Contributor(s): Adriano dos Santos Fernandes

• #6872: Faster execution of indexed STARTING WITH with UNICODE collation
  Contributor(s): Adriano dos Santos Fernandes

• #6815: Support multiple rows for DML RETURNING
  Contributor(s): Adriano dos Santos Fernandes

• #6810: Use precise limit of salt length when signing messages and verifying the sign
  Contributor(s): Alexander Peshkov

• #6809: Integer hex-literal support for INT128
  Contributor(s): Alexander Peshkov

• #6794: Improvement: add MON$SESSION_TIMEZONE to MON$ATTACHMENTS
  Contributor(s): Adriano dos Santos Fernandes

• #6740: Allow parenthesized query expression for standard-compliance [CORE6511]
  Contributor(s): Adriano dos Santos Fernandes

• #6730: Trace: provide ability to see STATEMENT RESTART events (or their count) [CORE6500]
  Contributor(s): Vlad Khorsun

• #6571: Improve memory consumption of statements and requests [CORE6330]
  Contributor(s): Adriano dos Santos Fernandes

• #5589: Support full SQL standard character string literal syntax [CORE5312]
  Contributor(s): Adriano dos Santos Fernandes

• #5588: Support full SQL standard binary string literal syntax [CORE5311]
  Contributor(s): Adriano dos Santos Fernandes

• #4769: Allow sub-routines to access variables/parameters defined at the outer/parent level [CORE4449]
  Contributor(s): Adriano dos Santos Fernandes

• #4723: Optimize the record-level RLE algorithm for a denser compression of shorter-than-declared strings and sets of subsequent NULLs [CORE4401]
  Contributor(s): Dmitry Yemanov

• #1708: Avoid data retrieval if the WHERE clause always evaluates to FALSE [CORE1287]
  Contributor(s): Dmitry Yemanov

• #281: RDB$BLOB_UTIL system package
  Contributor(s): Adriano dos Santos Fernandes

Bugfixes

• #7388: Different invariants optimization between views and CTEs
  Contributor(s): Dmitry Yemanov

• #7314: Multitreaded activating indices restarts server process
  Contributor(s): Vlad Khorsun

• #7304: Events in system attachments (like garbage collector) are not traced
  Contributor(s): Alexander Peshkov

• #7298: Info result parsing
  Contributor(s): Alexander Peshkov

• #7296: During shutdown op_disconnect may be sent to invalid handle
  Contributor(s): Alexander Peshkov

• #7295: Unexpected message 'Error reading data from the connection' when fbtracemgr is closed using Ctrl-C
  Contributor(s): Alexander Peshkov

• #7283: Suspicious error message during install
  Contributor(s): Alexander Peshkov

• #7262: Repeated op_batch_create leaks the batch
  Contributor(s): Alexander Peshkov

• #7045: International characters in table or alias names causes queries of MON$STATEMENTS to fail
  Contributor(s): Adriano dos Santos Fernandes

• #6968: On Windows, engine may hung when works with corrupted database and read after the end of file
  Contributor(s): Vlad Khorsun

• #6854: Crash occurs when use SIMILAR TO
  Contributor(s): Adriano dos Santos Fernandes

• #6845: Result type of AVG over BIGINT column results in type INT128
  Contributor(s): Alexander Peshkov

• #6838: Deleting multiple rows from a view with triggers may cause triggers to fire just once
  Contributor(s): Dmitry Yemanov

• #6836: fb_shutdown() does not wait for self completion in other thread
  Contributor(s): Alexander Peshkov

• #6832: Segfault using "commit retaining" with GTT
  Contributor(s): Alexander Peshkov

• #6825: Correct error message for DROP VIEW
  Contributor(s): Ilya Eremin

• #6817: -fetch_password passwordfile does not work with gfix
  Contributor(s): Alexander Peshkov

• #6807: Regression in FB 4.x : "Unexpected end of command" with incorrect line/column info
  Contributor(s): Adriano dos Santos Fernandes

• #6801: Error recompiling a package with some combination of nested functions
  Contributor(s): Adriano dos Santos Fernandes

• #5749: Token unknown error on formfeed in query [CORE5479]
  Contributor(s): Adriano dos Santos Fernandes

• #5534: String truncation exception on UPPER/LOWER functions, UTF8 database and some multibyte characters [CORE5255]
  Contributor(s): Adriano dos Santos Fernandes

• #5173: Compound ALTER TABLE statement with ADD and DROP the same constraint failed if this constraint involves index creation (PK/UNQ/FK) [CORE4878]
  Contributor(s): Ilya Eremin

• #5082: Exception "too few key columns found for index" raises when attempt to create table with PK and immediatelly drop this PK within the same transaction [CORE4783]
  Contributor(s): Ilya Eremin

• #4893: Syntax error when UNION subquery ("query primary") in parentheses [CORE4577]
  Contributor(s): Adriano dos Santos Fernandes

• #4085: RDB$INDICES information stored inconsistently after a CREATE INDEX [CORE3741]
  Contributor(s): Dmitry Yemanov

• #3886: RECREATE TABLE T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode [CORE3529]
  Contributor(s): Ilya Eremin

• #3812: Query with SP doesn't accept explicit plan [CORE3451]
  Contributor(s): Dmitry Yemanov

• #3357: Bad execution plan if some stream depends on multiple streams via a function [CORE2975]
  Contributor(s): Dmitry Yemanov

• #1210: Server hangs on I/O error during "open" operation for file "/tmp/firebird/fb_trace_ksVDoc" [CORE2917]
  Contributor(s): Alexander Peshkov

• #3218: Optimizer fails applying stream-local predicates before merging [CORE2832]
  Contributor(s): Dmitry Yemanov

Cleanup

• #7082: Remove the WNET protocol
  Contributor(s): Dmitry Yemanov

• #6840: Remove QLI
  Contributor(s): Adriano dos Santos Fernandes