FirebirdSQL logo
  • Anglaiskeyboard_arrow_down
 Reserved Words and ChangesSecurity 

SubQueryConversion

Defines whether IN/ANY/EXISTS sub-queries can be unnested and merged with the outer query using the semi-join algorithm, provided that such a transformation is possible.

Caution

Being en experimental feature, it’s disabled by default.

It can be enabled to benefit from a possibly better performance due to sub-query being evaluated just once and then cached.However, it may also lead to a worse performance in some cases, e.g. when the sub-query returns many rows.Please test with real-world use cases before enabling this conversion in a production environment.

Changed configuration parameters

WireCryptPlugin

A new variant of the ChaCha#20 plugin was added.It uses a 64-bit internal counter rather than 32-bit.The new default value of this parameter is now ChaCha64, ChaCha, Arc4.

docnext count = 6

Replication Configuration Additions and Changes

cascade_replication

Specifies whether changes applied to the replica database will be also subject of further replication (if any configured).Default value is false (cascading is disabled).

Allow macros in replication.conf

Configuration file macros are now also supported in replication.conf.

Removed configuration parameters

RemotePipeName

This parameter was removed along with the removal of WNET (aka named pipes) protocol support for Windows.

TcpLoopbackFastPath

This parameter was removed because Microsoft discourages using the SIO_LOOPBACK_FAST_PATH socket option.