MERGE statement loses parameters in WHEN (NOT) MATCHED clause that will never be matched, crashes server in some situations

Change type of MON$ATTACHMENTS.MON$IDLE_TIMER and MON$STATEMENTS.MON$STATEMENT_TIMER to TIMESTAMP WITH TIME ZONE

Make usage of TIMESTAMP/TIME WITH TIME ZONE convenient for users when appropriate ICU library is not installed on the client side

Statement "CREATE DOMAIN [dm_name] as BIGINT" raises "numeric value is out of range" if its default value is -9223372036854775808

Next attachment id, next statement id and some other additions [CORE-6300]

Assigning RDB$DB_KEY to MBCS CHAR/VARCHAR does not enforce the target limit

Server is crashing on long GRANT statement

NBACKUP locks db file on error

FB4 Beta 2 may still be using the current date for TIME WITH TIME ZONE and extended wire protocol

Regression in FB 4.x: error "Implementation of text subtype <NNNN> not located" on attempt to use some collations defined in fbintl.conf

Alternate quoting does not work on some particular cases

Rolled back transaction produces unexpected results leading to duplicate values in PRIMARY KEY field

Wire compression causes freezes

INT128 has problems with some PSQL objects

ROUND() does not allow second argument >=1 when its first argument is more than MAX_BIGINT / 10

Adding NOT NULL column with DEFAULT value may cause default values to update when selecting or have the wrong charset

Unable to restore database with tables using GENERATED ALWAYS AS IDENTITY columns (ERROR:OVERRIDING SYSTEM VALUE should be used)

Triggers accessing a table prevent concurrent DDL command from dropping that table

Using binary string literal to assign to user-defined blob sub-types yield conversion error "filter not found to convert type 1 to type -13"

Message length error with COALESCE and TIME/TIMESTAMP WITHOUT TIME ZONE and WITH TIME ZONE

Some PSQL statements may lead to exceptions report wrong line/column

FB crashes on attempt to create table with number of fields greater than 5460

Error message "expected length N, actual M" contains wrong value of M when charset UTF8 is used in the field declaration of a table

Parameter in offset expression in LAG, LEAD, NTH_VALUE window functions requires explicit cast to BIGINT or INTEGER

Timezone offset in timestamp/time literal, CAST, SET TIME ZONE and AT TIME ZONE should follow SQL standard syntax only

ISQL: bad headers when text columns has >= 80 characters

Srp plugin keeps connection after database has been removed for ~10 seconds (SS and SC)

Unexpectedly different text of message for parameterized expression starting from second run

EXECUTE STATEMENT fails on FB 4.x if containing time/timestamp with time zone parameters

Incorrect query result when using named window

Provide ability to see in the trace log actions related to session management (e.g. ALTER SESSION RESET)

COMMENT ON USER can only apply comment on user defined by the default usermanager plugin

FETCH ABSOLUTE and RELATIVE beyond bounds of cursor should always position immediately before-first or after-last

Inconsistent translation "string->timestamp->string->timestamp" in dialect 1

Regression: gstat with switch -t executed via services fails with "found unknown switch" error

Regression: CREATE DATABASE fails with 'Token unknown' error when DB name is enclosed in double quotes and 'DEFAULT CHARACTER SET' is specified after DB name

AV in engine when StatementTimeout is active for user statement and some internal DSQL statement was executed as part of overall execution process

Error "no current record for fetch operation" when sorting by a international string

Results of concatenation with blob has no info about collation of source columns (which are declared with such info)

More efficient implementation of SUBSTRING for UTF8 character set

coalesce fails with data type varchar and a non ascii value [CORE388]

Avoid data retrieval if the WHERE clause always evaluates to FALSE [CORE1287]

Many indexed reads in a compound index with NULLs

Bad execution plan if some stream depends on multiple streams via a function [CORE2975]

Query with SP doesn't accept explicit plan [CORE3451]

Sub-optimal predicate checking while selecting from a view [CORE3981]

Optimize the record-level RLE algorithm for a denser compression of shorter-than-declared strings and sets of subsequent NULLs [CORE4401]

Allow sub-routines to access variables/parameters defined at the outer/parent level [CORE4449]

Index and blob garbage collection doesn't take into accout data in undo log [CORE4701]

Compound ALTER TABLE statement with ADD and DROP the same constraint failed if this constraint involves index creation (PK/UNQ/FK)

Non US-ASCII field names treated as unicode, although charset non-unicode, lowering max field length [CORE5258]

Support full SQL standard character string literal syntax [CORE5312]

Token unknown error on formfeed in query [CORE5479]

Add support for QUARTER to EXTRACT, FIRST_DAY and LAST_DAY [CORE5693]

Connection to server may hang when working with encrypted databases over non-TCP protocol

Slow performance when executing SQL scripts as non-SYSDBA user

Add DPB properties for time zone bind and decfloat configuration [CORE6032]

Error writing to TIMESTAMP/TIME WITH TIME ZONE array

Support for WHEN NOT MATCHED BY SOURCE for MERGE statement

gbak discards replica mode

Allow parenthesized query expression for standard-compliance

Getting "records fetched" for functions/procedures in trace

Add session time zone to system context

MON$ATTACHMENTS.MON$TIMESTAMP is incorrect when DefaultTimeZone is configured with time zone different from the server's default

Add built-in functions UNICODE_CHAR and UNICODE_VAL to convert between Unicode code point and character

When the statement timeout is set, it causes the lock manager to delay reporting deadlocks until timeout is expired

Regression in FB 4.x : "Unexpected end of command" with incorrect line/column info

Integer hex-literals: support for INT128

BASE64_ENCODE and HEX_ENCODE can exceed maximum widths for VARCHAR

Illegal output length in base64/hex_encode/decode functions

Correct error message for DROP VIEW

Deleting multiple rows from a view with triggers may cause triggers to fire just once

Crash occurs when use SIMILAR TO ...

Create user statement fails with SQLSTATE = HY000 when using DataTypeCompatibility

Domain CHECK-expression can be ignored when we DROP objects that are involved in it

SIMILAR TO does not use index when pattern starts with non-wildcard character (in contrary to LIKE)

Significant performance regression of SIMILAR TO and SUBSTRING(SIMILAR) when pattern is taken from variable (rather than directly specified)

Invalid SIMILAR TO patterns may lead memory read beyond string limits

Unable to create ICU-based collation with locale keywords

Allow attribute DISABLE-COMPRESSIONS in UNICODE collations

GTT's pages are not released while dropping it

SQL SECURITY DEFINER has inconsistent behaviour if the object owner is non-privileged

Incorrect singleton error with MERGE and RETURNING

grant references not working

DATEDIFF does not support fractional value for MILLISECOND

Problems with access to RDB$CONFIG table for non-privileged user when he has grant on execution of SP which has necessary access rights (created by SYSDBA with SQL DEFINER clause)

Results of negation must be the same for each datatype (smallint / int /bigint / int128) when argument is least possible value for this type

Server crashes while fetching from a scrollable cursor in PSQL

International characters in table or alias names causes queries of MON$STATEMENTS to fail

Incorrect releasing of user savepoint (older savepoints become inaccessible)

Fetching from a scrollable cursor may overwrite user-specified buffer and corrupt memory