Builtin functions converting binary string to hexadecimal representation and vice versa

Change behavior of skipped and repeated wall times within time zones

Restore of encrypted backup of database with SQL dialect 1 fails

USING PLUGIN clause does not work in RECREATE USER

Creating of the large procedure crashes the server

"SIMILAR TO" hangs when processing parenthesis

BLOB fields may be suddenly set to NULLs during UPDATE after a table format change

Connection does not see itself in the MON$ATTACHMENTS when Domain/Username (using SSPI) is 31 bytes long

Changing FLOAT to a SQL standard compliant FLOAT datatype

Win_Sspi in the list of auth plugins leads message about failed login to be changed (from 'Your user name and password are not defined...' to 'Missing security context ...')

Inconsistent behavior regarding visibility of master record on detail inserts

Error 'Multiple maps found for ...' is raised in not appropriate case

Wrong result in "similar to" with non latin characters

substring similar - extra characters in the result for non latin characters

SUBSTRING of non-text/-blob is described to return NONE character set in DSQL

Problems with long object names (> 255 bytes)

Operations when using "SET DECFLOAT BIND BIGINT,n" with result of 11+ digits, fail with "Decimal float invalid operation"

Some (wrong ?) parameters of ENCRYPT() leads FB to crash

Generate proper error for UNION DISTINCT with more than 255 columns

CREATE DATABASE grant is lost in security.db after backup/restore cycle

request size limit exceeded when selecting from a table with large number of indicies

Add support for special (inf/nan) values when sorting DECFLOAT values

Wrong dependencies of stored function on view after backup and restore

Performance problem when using SRP plugin

Procedures and EXECUTE BLOCK without RETURNS should not be allowed to use SUSPEND

Problem with too many number of columns in resultset

Signature mismatch when creating package body on identical packaged procedure header

UNIQUE / PRIMARY KEY constraint can be violated when AUTODDL = OFF and mixing commands for DDL and DML

SHOW DOMAIN/TABLE does not display character set of system objects

mapping rules destroyed by backup / restore

Failed attach to database not traced

Put options in user management statements in any order

Invalid timestamp errors with RDB$TIME_ZONE_UTIL.TRANSITIONS

SQL-level replication management

Hex number used at end of statement (e.g. CREATE DOMAIN ... DEFAULT) may read invalid memory and produce wrong values or exceptions

Negative 128-bit integer constants are not accepted in DEFAULT clause

Varchar length limit is not enforced when assigning string with trailing spaces in MBCS

Unable to specify new 32k page size

CAST('NOW' as TIME) raises exception

Alter domain operation for domain with collation specified revert its collation to database default

GBAK with service_mgr and WinSSPI authentication for Windows SYSTEM user producing error in clumplet API

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]

Isql's extracted script is unusable with interdependent selectable procedures in FB 2.1 [CORE1862]

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

recreate table T with PK or UK is impossible after duplicate typing w/o commit when ISQL is launched in AUTODDL=OFF mode

Grant and Revoke update (field) [CORE4407]

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]

Add details on compression and crypt status of connection (fb_info_conn_flags) to getInfo() API call [CORE5601]