Released: Sep 30, 2021

Mises à jour de 2020 Update 2

Fonctionnalités

ISQL

• Added ISQL support to use EXTRACT for showing EUA database setup and EUA user records when connected as database owner.
• Added ISQL support to EXTRACT Change View Subscription definitions and their use in Database/Table schemas.
• Added support to EXTRACT Encryption Key definitions when run as user SYSDSO and database/column encryptions when run as database owner.

CTE

• Embarcadero InterBase already supports Common Table Expressions, this update adds support for recursive CTE.

IBConsole

• IBConsole can now set database write attributes when restoring databases.

SEP

• Using gstat -h or services API now shows information about SEP (system encryption password) on the header page statistics.

Correctifs

• "CREATE USER foo SET INACTIVE" does not work.
• Incremental Online dumps using the DPB method worked in IB2020 and earlier, but was broken around update 1 timeframe.
• "Stack overflow" error returned when using a derived table as part of a JOIN.
• InterBase server crash when using a derived table alias in a PLAN syntax.
• InterBase installer script on Linux does not work for "Console" mode.
• If the IBConsole WISQL window is minimized, it cannot be restored.
• Wrong result set returned by query when using tablename qualifier from outer scope in subquery.
• For database in Linger mode, if underlying database file is deleted in file system, the loaded database stays resident in memory forever for the server session.
• database linger countdown proceeding even if new attachments came in since last garbage collector check.
• Database write mode not changed with IBConsole Properties.
• IBConsole does not display database properties when connection uses Alias DB Alias.
• Error import csv txt.
• Dropping a subscription using IBConsole fails to delete permissions from RDB$USER_PRIVILEGES.
• Crash when an EUA user activates a subscription tracking deletes.
• A syntax error in CTE query crashes the server.
• Untrapped Server crash when setting a subscription to active.
• Impossible to modify a view in InterBase 2020 with IBConsole.
• Atom unlock invalid state level: 1 appearing in interbase.log with build 14.1.0.366.
• Examining the metadata of an ODS 17 backup MUCH slower than that of an ODS 18.
• Recompile of stored procedures hangs when hundreds of them are done at the same time.
• It is not possible to log in to an EUA database if the sysdba password is not the same as server's SYSDBA password.
• Unexplained InterBase server crash due to heavy load.
• A full backup of a database with tablespaces breaks the restore of a tablespace and corrupts the database.
• InterBase server crash with UNIONs in Derived Table definition.
• Not possible to connect to a database in IBConsole if EUA SYSDBA Password is different from Server password.
• Silent installer places superkey slip files in Program Files.
• Using invalid column alias in derived table causes server crash.
• IBServer crash on update online dump.
• Crash on executing selects with derived tables.
• IBConsole cannot set up Performance Monitoring Logs on ODS 16 and above.
• Derived table column naming.
• "Invalid command must specify column name for view select expression" querying count in a CTE expression.